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

• The 19 Amazing Shortcut Keys for Selecting Cells, Rows, and Columns in Excel
• 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
• Excel 2003 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