Posts Tagged ‘2007’

Where is Close All and Save All Command in Word 2007?

Wednesday, January 27th, 2010

In previous versions of  MS Word it was easier to use the Close All and Save All command.  All you had to do was click the Shift key and hold it while you simultaneously clicked on File. The menu would then display those commands for you.

Unfortunately, these commands are not as readily available to you in version 2007.  Fear not though, you can still use these commands.

Follow the steps below to learn how:

  1. Click the small drop-down arrow to the right of your Quick Access (QAT) toolbar and select More Commands.
  2. Click on Customize in the left column.
  3. Click on Choose Commands From drop-down arrow and select Commands Not in the Ribbon.
  4. Select Close All.
  5. Click on the Add button.
  6. Select Save All.
  7. Click on the Add button.
  8. Click OK.

You will now have access to those commands on your QAT.

Shortcut for Accented Letters in MS Word

Wednesday, January 13th, 2010

Most folks do not use accented letters in their documents in MS Word documents on a daily basis. However, you find that you will have the need to use certain words that require an accented letter at some point, (i.e., café, résumé, fiancé).

I am sure that most of you are aware that you can insert an accented letter in your document the long way:

  1. In versions 2007 and 2010 Insert tab in versions 2007 or 2010 or the Insert menu in version 2003.
  2. Click on Symbol.
  3. Locate the needed accented letter.
  4. Click it.
  5. Click Insert.
  6. Close the Symbol dialog box.

There is another method you could employ, which is a keyboard shortcut for that symbol, which is easy enough to create —

  1. Navigate to the Symbol menu.
  2. Click on the symbol you need.
  3. Click Shortcut Key.
  4. Press the key combo you would like to use.
  5. Make sure your key combination is not currently assigned to another shortcut.
  6. Click Assign.

 — but not always easy to remember if you do not use it on a daily basis!

Either of the above methods would work just fine for you, but as you know, I am a huge proponent of less time and less keystrokes. There is another shortcut that will insert your accented letter for you much more quickly and easily:

Depress Ctrl + ` + the letter of your choosing. For instance, if you want to type the word fiancé, you simply press Ctrl+’, release those keys and type the letter e.

The other option is to depress simultaneously (Ctrl + ` + e). Both options will give you the same result.

If you need a letter with a tildè (~) above it, use Ctrl + Shift +`. Using the Shift key gives you the tildè. Release and click the letter of your choosing and a tilde will now appear above it.

Depressing all keys simultaneously will not give you the same result for the tildè; instead it will give you an upper case letter.

Unhide Hidden Rows or Columns in MS Excel

Thursday, December 10th, 2009

I have, on occasion, become the recipient of an MS Excel workbook that has hidden rows or columns. Mind you, it doesn’t happen often but when it does it can be a real problem because I don’t always remember how to unhide them and as you all know, I hate wasting time floundering around trying to find a resolution.

Follow the steps below to learn how to unhid rows and columns:

  1. Highlight the row above and the row below the hidden row(s), or the column to the left and right of the hidden column(s).

There are a couple of methods to reveal the hidden rows and columns:

  • Click on Shift + Ctrl + zero.
  • Right-click your selection and select Unhide.
  • Click on Format | Column (or Row) and select Unhide.
  • In version 2007, in the Cells group on the Home tab, clcik Hide & Unhide and select Unhide Rows or Unhide Columns.

Very simple eh?