"Microsoft Excel Shortcut Keys: The 19 Amazing Shortcut Keys for Selecting Cells, Rows, and Columns in Excel"

Do you believe that using the Microsoft Excel shortcut keys can practically replaces your mouse clicks!!

Using mouse: To select a single cell, simply click it. To select a range of cells with the mouse, you simply click and drag. Do you think the keyboard shortcuts also can achieve the same result?

Make sure you don't miss the following Microsoft Excel Shortcut keys for selecting cells, rows, and columns:

1. Extend the selection in the direction of the arrow key
[Shift]+[→], [Shift]+[←], [Shift]+[↓], [Shift]+[↑]

2. Select the current column
[Ctrl]+[Spacebar]

3. Select the current row
[Shift]+[Spacebar]

4. Select all cells on the current worksheet
[Ctrl]+[A]

5. Reduce the selection to the active cell
[Shift]+[Backspace]

6. Select all the objects on the current worksheet while retaining the current selection
[Ctrl]+[Shift]+[Spacebar]

7. Toggle Extend mode on and off
[F8]

8. Toggle Add mode on and off
[Shift]+[F8]

9. Extend the selection to the first or last cell in the data area
[Ctrl]+[Shift]+[→], [Ctrl]+[Shift]+[←], [Ctrl]+[Shift]+[↓], [Ctrl]+[Shift]+[↑]

10. Extend the selection to the first cell in the row
[Shift]+[Home]

11. Extend the selection to the first cell in the worksheet
[Ctrl]+[Shift]+[Home]

12. Extend the selection to the last cell used on the worksheet
[Ctrl]+[Shift]+[End]

13. Extend the selection to the last cell with contents in the active column or row
[End], then [Shift]+[→], [Shift]+[←], [Shift]+[↓], [Shift]+[↑]

14. Extend the selection to the last cell with contents on the worksheet
[End], then [Shift]+[Home]

15. Extend the selection to the last cell in the active row
[End], then [Shift]+[Enter]

16. Extend the selection downward by one screen
[Shift]+[PageDown]

17. Extend the selection upward by one screen
[Shift]+[PageUp]

18. Extend the selection to the first cell in the window
[ScrollLock], then [Shift]+[Home]

19. Extend the selection to the last cell in the window
[ScrollLock], then [Shift]+[End]

Yes, that is totally 19 Microsoft Excel shortcut keys for you to use. I highly recommend you visit the links below if you wish to discover more Microsoft Excel shortcut keys.

• 16 Powerful Shortcut Keys to Help You Easily Navigate in Worksheets
• How to Use the Shortcut Keys for Entering and Editing Data in Excel?
• 11 Must-know Shortcut Keys When Working with Formulas
• Top 10 Excel Keyboard Shortcuts To Help You Format Excel Data As You Wish
• 10 Great Microsoft Excel Keyboard Shortcuts for Applying Outline and Cell Borders
• Microsoft Excel Shortcut Keys for Working in Print Preview

Can't find what you're looking for? Try Google Search!

Custom Search

Related Links:

• Microsoft Word Keyboard Shortcuts - Function Keys
• Microsoft PowerPoint Keyboard Shortcuts - Function Keys
• Microsoft Outlook Keyboard Shortcuts - Function Keys

Add To Your Social Bookmarks: Blink Del.icio.us Digg
Furl Google Simpy Spurl Technorati Y! MyWeb