Home
MS Office - How to ?
Excel Tutorials
Word Tutorials
PowerPoint Tutorials
Free e-books
VIDEO Tutorials
Office 2007 Guides
Excel 2007 Tutorials
PowerPoint 2007 Guides
Word 2007 Tutorials
MS Office Template
Free Clip Art
Keyboard Shortcut
Tips and Tricks
MS Outlook
MS Publisher
Free Newsletter
MS Windows
Contact Us
Site Map
Google Docs and ...
You and This Site
Resources Page

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


Excel Navigation – How Effective Are You?


Excel Navigation – How to move from one place to another in Excel worksheet?

Yes, you may needs to move from one cell to another in Excel? Or moving between worksheets by using either mouse or keyboard. Here are the steps:

To move to a particular cell using the mouse

  • Place the mouse pointer on the particular cell and click.

    To move to a particular cell (quick way)

  • Enter the cell that you wish to jump to into the Name Box (at the top, left of the screen). In the example shown the cell reference D12 has been entered. When you press the Enter key you will jump to the cell you entered.

    excel name box



    To move from cell to cell using the keyboard

  • To move from cell to cell, use one of the following methods:

    excel navigation using keyboard



    To move within a selected range of cells

  • Select the range of cells by dragging the mouse.
  • Use one of the following combinations key to move from one cell to another:

    excel navigation



    To move between worksheets using the mouse

  • Click on the appropriate worksheet tab displayed along the bottom of the worksheet.

    To move between worksheet tabs using the keyboard

  • To move one tab to the left, press Ctrl+Page Up.
  • To move one tab to the right, press Ctrl+Page Down.

    Get FREE ebooks!
    (Click for more info)

    Subscribe to...
    MS Office Tips Newsletter

    E-mail Address:
    First Name:
    Then

    Don't worry -- your e-mail address is totally secure.
    I promise to use it only to send you MS Office Tips.

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

    Google
     

    Back to Top


    Recommended book:

    Revealed! 101 Excel Secrets Revealed! 101 Excel Secrets


    You're viewing the Excel Navigation info page, click here to go back to the Home Page


    footer for excel navigation page