"Excel Navigation - How Effective Are You?"

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

Yes, you need to move from one cell to another in Excel from time to time? Also, we show you how to move between Excel worksheets by using either mouse or keyboard.

This tutorial will show you how to effectively move from one place to another in the worksheet using the simple 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 2007 name box

To move from cell to cell using the keyboard

  • To move from cell to cell, use one of the following methods:
  • Excel 2007 navigation with 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:
  • Tab - To the right one cell.
    Shift + Tab - To the left one cell.
    Enter - One cell down.
    Shift + Enter - One cell up.

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.

Related Topics:

Using the Excel 2007 Pick List Feature to Boost up Your Entering Data Speed!
How to Change the Excel 2007 Cell Color?
What you Can do with Excel 2007 Paste Special Feature?
Excel 2007 Help - Your Personal Virtual Assistant!

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

Custom Search

Back to Top

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

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

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.