"Microsoft Excel Keyboard Shortcuts: 16 Powerful Shortcut Keys to Help You Easily Navigate in Worksheets"


Microsoft Excel keyboard shortcuts can save you a large amount of scrolling and clicking with the mouse. If you really master the excel shortcut keys, you can even perform certain task faster than mouse clicks.

Below are the Microsoft Excel keyboard shortcuts for navigations in the worksheets. You can use it to move from one place to another in the worksheets faster.

1. Move the active cell up or down one row, or left or right one column
[←], [→], [↓], [↑]

2. Insert a new worksheet in the active workbook
[Shift]+[F11], [Alt]+[Shift]+[F1]

3. Move to the first cell in the active row
[Home]

4. Move to the first cell in the worksheet
[Ctrl]+[Home]

5. Move to the last used cell in the worksheet
[Ctrl]+[End]

6. Move to the next worksheet
[Ctrl]+[PageDown]

7. Move to the previous worksheet
[Ctrl]+[PageUp]

8. Select the current worksheet and the next worksheet
[Ctrl]+[Shift]+[PageDown]

9. Select the current worksheet and the previous worksheet
[Ctrl]+[Shift]+[PageUp]

10. Move to the specified edge of the data region
[Ctrl]+[→], [Ctrl]+[←], [Ctrl]+[↓], [Ctrl]+[↑]

11. Move down one screen
[PageDown]

12. Move up one screen
[PageUp]

13. Move to the right by one screen
[Alt]+[PageDown]

14. Move to the left by one screen
[Alt]+[PageUp]

15. Scroll the workbook to display the active cell
[Ctrl]+[Backspace]

16. Display the Go To dialog box
[Ctrl]+[G]


With these 16 shortcuts, I strongly believe that you can work faster with the worksheets if you really go to use the keyboard shortcuts. If you want to learn more Microsoft Excel keyboard shortcuts, follow the links below:



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.