"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.



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

Custom Search


Related Links:

Add To Your Social Bookmarks: add to BlinkBlink add to Del.icio.usDel.icio.us add to DiggDigg
add to FurlFurl add to GoogleGoogle add to SimpySimpy add to SpurlSpurl Bookmark at TechnoratiTechnorati add to YahooY! MyWeb


Google Search:

Custom Search

Recommended Books:

Click on the image to view the details of the book.
Excel 2007 ebook
The Ultimate Guide to
Excel 2007!


PowerPoint 2007 ebook
The Ultimate Guide to
PowerPoint 2007




XML RSS
What is this?
Add to My Yahoo!
Add to My MSN
Add to Google


Enjoy This Site?
Then why not use the button below, to add us to your favorite bookmarking service?

Copyright © www.msoffice-tutorial-training.com. All Rights Reserved.