Corporate users of Microsoft Excel utilize large spreadsheets encompassing many rows and columns. Regardless of whether the spreadsheet is being used for budgeting, cash projections, depreciation, or acquisition analysis, there is usually a few cells containing some critical piece of information. Most users constantly scroll left and right, or up and down, to see the effect of changes on these critical cells.

Excel contains a feature known as the Watch Window. The Watch Window is a floating dialog box that displays the value of your ‘critical cells’ even when those cells are not currently displayed. Using this feature will not only save time, but also carpal tunnel syndrome.

To display the Watch Window in Excel 2007 or 2010, click on the Watch Window icon contained on the Formulas ribbon. [For Excel 2003 select Tools → Formula Auditing → Show Watch Window on the menu bar.]

This will display the Watch Window.

Click Add Watch on the menu bar. This displays a pop-up allowing you to either type a cell (or range) address or by clicking the icon, selecet the cell (or range) with your mouse.

When the correct cell (or range) is shown in the pop-up, click the Add button.

The Watch Window will then display the book name, sheet name, optional range name, cell (or range) address, current value of the cell, and the formula contained in the cell.

You can continue to add more additional items to the Watch Window by clicking on Add Watch on the menu bar.

The Watch Window will remain ‘in your face’ as you move around the spreadsheet. However, you also have the option of docking the Watch Window below the ribbon by dragging the window up towards the ribbon until it snaps into place.

You can turn off the display of the Watch Window by either clicking the Watch Window icon on the Formula ribbon or by clicking the ‘x’ in the upper right corner of the Watch Window.

Copyright 2010 - VBA Consultants Ltd

One of the ironies of using computer software programs with a graphical interface is that you have to move at least one hand from the keyboard to the mouse in order accomplish some command or task. When using a word processing program most users immediately reach for their mouse to make a text selection in order to apply formatting properties. This is very inefficient considering that you will be moving your hand back to the keyboard to continue typing one you are finished formatting the selected text.

This article explains some of the methods to select text with the keyboard when using Microsoft Word. These keyboard shortcuts should work in Word 2003, 2007, and 2010. NOTE: The '+' between the key names indicates that you have to press the keys at the same time.

Shift + End

• Selects text from the cursor to the end of the line.
• In this context ‘line’ equals row. It does not equal ‘sentence’.

Shift + Home

• Selects text from the cursor to the beginning of the line.
• This is the opposite of Shift + End

Shift + Page Down

• Selects text from the cursor one screen down.
• ‘Screen’ does not equal ‘page’.
• Will select text across two pages.
• If cursor is not at beginning of line, will select text to approximately same location (minus 1 character) in last line of the screen.

Shift + Page Up

• This is the opposite of Shift + Page Down.

Shift + Right Arrow/Shift + Left Arrow

• Extends selection one character to the right or left depending on the arrow key pressed.

Ctrl + Shift + Right Arrow

• Selects from the cursor to the end of the word.
• If cursor is within a word, the remainder of the word will be selected.
• If the cursor is at the end of a word, the next ‘space’ will be selected.

Ctrl + Shift + Left Arrow

• Selects from the cursor to the beginning of the word.
• If the cursor is already at the beginning a a word, this shortcut will select the previous word.

Ctrl + Shift + Down Arrow

• Selects from cursor to end of paragraph.
• If the cursor is already at the end of a paragraph, this shortcut will select the next ‘space’.

Ctrl + Shift + Up Arrow

• Selects from the cursor to the start of the paragraph.
• If the cursor is already at the start of a paragraph, the previous paragraph will be selected.

Ctrl + Shift + End

• Selects from the cursor to the end of the document.

Ctrl + Shift + Home

• Selects from the cursor to the beginning of the document.

Ctrl + A

• Selects the entire document.

Word also comes with another method for selecting text via the keyboard: Extend Mode. Extend Mode works through successive pressings of the function key F8.

1. Turns on Extend Mode
2. Selects the current or nearest word.
3. Selects the sentence containing the selected word.
4. Selects the paragraph containing the selected sentence.
5. Selects the entire document.

You must press the Esc key to turn Extend Mode off.

There is also a ‘reverse’ Extend Mode that is accessed by successively pressing Shift + F8. This keystroke combination reduces the text selection from Everything → Paragraph → Sentence → Word → Nothing.

Copyright 2010 - VBA Consultants Ltd