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

To move from cell to cell using the keyboard

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

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: Blink Del.icio.us Digg
Furl Google Simpy Spurl Technorati Y! MyWeb