April Fools’ Tips & Tricks

 Happy April 1st.

First the tip: When leaving your PC unattended, press WINDOWS KEY + L to lock your screen and keyboard. This will prevent you from falling prey to any seasonal pranks (like these).

Now the tricksHere is a short list of relatively harmless April Fools’ pranks you could play on a friend’s unlocked PC.

Windows

Change the Double+Click speed

“My mouse is broken”

  1. Click Start, type “mouse”, select Settings filter, then click Change Mouse Settings.
  2. Select the Buttons Tab.
  3. In the Double-Click area move the slider bar to the fastest setting.
  4. Click OK.

Flip the Screen

They might need to stand on their heads for a bit

  • Press CTRL + ALT + DOWN ARROW to rotate the display 180°
  • To return screen to normal press CTRL + ALT + UP ARROW

Excel

Cursor Up on Enter

Gravity will seem to have taken a holiday as Enter moves the cursor up instead of down.

  1. File/ Options / Advanced.
  2. In the Editing section, check After Pressing Enter move selection,
  3. For Direction select Up.
  4. Ok.

Ribbonus-Interruptus

Formula entry is problematic when pressing = moves the focus from the sheet to the Ribbon.

  1. File/ Options / Advanced.
  2. In the Lotus Compatibility section, in the Microsoft menu key field type  =.
  3. Ok.

 

Cheers!

hɔuᴉnb

Excel: Insert Tables From Web

Use the Insert from Web option, to quickly import tables from web pages into Excel.

Watch this 2 minute video to see all you need to know.


To Insert Data From Web into Excel

  1. Using your web-browser, locate the content to be imported.
  2. RIGHT + CLICK in the addressbar and select Copy.
  3. In Excel, on the Data tab of the Ribbon, click From Web. A New Web Query dialog will appear.
  4. RIGHT + CLICK in the addressbar, select Paste, and click Go. The source webpage will populate the dialog.
  5. Click the yellow arrow grnarrw next to the table(s) you wish to copy (the icon will change to a green check grnchk  ).
  6. Optionally, click Options and select formatting preference (i.e., None, Rich Text, HTML) then click OK.
  7. Click Import. The Import Data dialog will appear.
  8. Select starting cell to import data to or select “New Worksheet” to import into a new sheet.
  9. Click Properties, uncheck Save Query Definition*, and click OK.
    *Alternatively, to maintain a link to variable data, leave Save Query Definition checked; you will be prompted to ‘Enable Content’ each time the file is opened.
  10. Click OK to complete the import.
Additional reading..

Cheers!

hɔuᴉnb

Comments and questions are always welcome!

Enter your email address to follow this blog and receive notifications of new posts by email.

MS Office: Insert Screenshot

Need to insert a screenshot into your presentation, document, spreadsheet or email? The Office 2010/2013 Insert Screenshot button makes this easy.

Watch this 60 second video to see all you need to know.


To Insert a Screenshot

  1. Display content window that has the material to capture. Do not minimize this window.
  2. Open or switch to destination application (i.e., MS Word, PowerPoint, Excel, or Outlook).
  3. Place cursor where you wish to insert the screen capture.
  4. On the Insert tab of the Ribbon, click Screenshot button. The available (i.e. not minimized) windows will display as thumbnails.
    • To insert an entire window; select associated thumbnail from the drop-down.
    • To insert a portion of the window previously displayed; select Screen Clipping, then CLICK + DRAG cross-hair around the portion to insert.
Additional reading..

Cheers!

hɔuᴉnb

Comments and questions are always welcome!

Enter your email address to follow this blog and receive notifications of new posts by email.

Windows 8.1-What’s new?

Give me back my Desktop and Start Button! 

Yes, we all complained, and millions of voices could not be silenced. Newer wasn’t necessarily better, so Windows 8.1 has returned some old features and improved some others. The desktop is now much easier to access (yay!), but the Return of the Start button, misses the mark. START is back, but only as a means to access the much maligned START screen (boo!).

Return of the DESKTOP

The only thing on my Windows 8 Start screen I ever used was the Desktop tile. So going from boot-up to START screen, and then clicking on Desktop was an extra and unappreciated step. Now, with 8.1, you can re-enable booting up with Desktop.

Windows81a

Additionally, you can

  • Share the Desktop background with the Start screen,
  • Control the Corner Navigation ‘aka: hotspopts’

To access, RIGHT + CLICK  on the Taskbar , and select PropertiesNavigation.

Better SEARCH

With Windows 8.1 your Search includes not only your local drive and apps, but also your SkyDrive and web results. And speaking about SkyDrive, there is better integration and support for SkyDrive users.

Better CONTROL PANEL

The Windows 8 PC Settings was an abbreviated version of the familiar control panel. With limited settings available, To make a setting change one either had to search for it, or access the legacy windows Control Panel. Windows 8.1 has made more control panel applets accessible under Settings (although I still find it easier to use the search  option to locate the setting I am tweaking).

Easier TILING (aka ‘SNAP’)

The Windows 8 SNAP feature was (sorry) annoying, mostly in that you could not control the size of the windows you were tiling. Windows 8.1 improves this feature by allowing you to control the size of the tiled (oops, I mean SNAPPED) windows.

Additional articles to peruse:

Cheers!

hɔuᴉnb

Comments and questions are always welcome!

Enter your email address to follow this blog and receive notifications of new posts by email.