Archive | May, 2014

Tame your computer – it’s a snip!

29 May

Some time ago I made you fall in love with Windows 7’s easy way to capture, edit, save and share snippets of your screen (see tip 386 if you missed it). As I seem to be using it more and more, I’ve given it its own keyboard shortcut.

Here’s how:

  1. Right-click the Snipping Tool in the Start Menu. (If you cannot find it in the Start menu, simply type Snipping Tool – or snip – in the search box. See tip 327 if you don’t know about this functionality.)
  2. Select Properties from the drop-down list.
  3. Click in the Shortcut key box.  (No need to delete what’s there.)
  4. Press any keyboard combination you will find easy to remember. (I’ve set mine as CTRL + ALT + S, so it won’t interfere with the normal CTRL + S keyboard shortcut, saving files.)
  5.  Click OK.

In future, press the keyboard shortcut that you assigned, rather than first having to open the Snipping Tool.

See tip 345 to find out how to assign keyboard shortcuts to symbols or special characters in Word.

Tame your computer – track down a title

20 May

Searching in Windows 7 is easy. Simply press the Windows key on your keyboard (next to your Alt key) or type in the search box at the top of any open window, and start typing. The search begins automatically – ideal for those of us who are touch-typists, watching our monitor – but not for those who use hunt-and-peck. Items that match your search term(s) will appear, based on text in the file or folder name, text in the file and other properties the item might have.

If you get way too many results, perhaps you know you can use double quotation marks (” “) in the same way you might when you search the web or in Outlook.

But what if you know the title of the document or folder and want to use that to limit what you find?

Here’s how:

  1. Press WIN + F or navigate to the folder from which you want to search.
  2. In the Search box (CTRL + E, anyone?) in the top right hand corner, type name: followed by (part of) the item’s title.
  3. If necessary, exclude certain items, using a hyphen (-).

For example, if you want to exclude pdfs or jpgs, simply type

name:whatever -pdf -jpg.

Or, if you want to find folders only, you can type

name:whatever kind:folder.

(By the way, the search is NOT cAse sENsiTIve so it doesn’t matter whether you type, for example, “name:whatever” or “Name:WHATEVER” or “NAME:Whatever”.)

So, once you know how, it is very simple to search by title only. But why on earth did Microsoft not put Name as an option in the search box – whereas it did include Kind, Date modified, Type and Size?!

(With thanks to Tina for this week’s tip inspiration!)

Tame your computer – a formula for success

5 May

Have you ever had the need to keep your formulas in a worksheet, but get rid of all the other data? For example, you might want to create a new sheet for the new tax year, containing exactly the same headers and formulas, but not the data from the previous tax year.

Here’s how:

  1.  Select the rows and/or columns that contain the formulas. (Remember the quick way to select a range of cells?)
  2. On the Home tab, in the Editing group, click Find & Select, and then click Go To Special. (Or press CTRL + G and click on the Special button.)
  3. In the Go To Special dialog box, click the Constants radio button.
  4. Click OK.
  5. Press the Delete key on your keyboard.

This will delete all the data, but leave the formulas, ready for next year’s tax year.  (Thanks for the inspiration, Melissa.)