Office
 

Getting Started with Microsoft Excel 2010 : Moving Around the Workbook

10/8/2011 3:45:09 PM
You can move around a worksheet using your mouse or the keyboard. You might find that using your mouse to move from cell to cell is most convenient, while using various keyboard combinations is easier for quickly covering large areas of a worksheet. Or, you might find that entering numbers on the keypad and pressing Enter is a better method. Certain keys on the keyboard—Home, End, and Delete to name a few—are best used as shortcuts to navigate in the worksheet. However, there is no right way; whichever method feels the most comfortable is the one you should use.

Use the Mouse to Navigate

Using the mouse, you can navigate to:

  • Another cell

  • Another part of the worksheet

  • Another worksheet

  • Did You Know?

    Microsoft IntelliMouse users can roll from cell to cell with IntelliMouse. If you have the new Microsoft IntelliMouse—with the wheel button between the left and right buttons—you can click the wheel button and move the mouse in any direction to move quickly around the worksheet.

    You can quickly zoom in or out using IntelliMouse.
    Instead of scrolling when you roll with the IntelliMouse, you can zoom in or out. To turn on this feature, click the File tab, click Options, click Advanced, select the Zoom On Roll With IntelliMouse check box, and then click OK.

For Your Information: Storing Data in Excel

Excel takes advantage of new technology to help you store more data and increase performance. Excel now supports over 1 million rows and 16 thousand columns in each worksheet, dual-processors and multithreaded chips, memory management up to 2 GB, and up to 16 million colors.


Use the Keyboard to Navigate

Using the keyboard, you can navigate in a worksheet to:

  • Another cell

  • Another part of the worksheet

    Refer to the table for keyboard shortcuts for navigating around a worksheet.

    You can change or move cell selections after pressing Enter. When you press Enter, the active cell moves down one cell. To change the direction, click the File tab, click Options, click Advanced, click the Direction list arrow, select a direction, and then click OK.

Keys For Navigating in a Worksheet

Press This KeyTo Move
Left arrowOne cell to the left
Right arrowOne cell to the right
Up arrowOne cell up
Down arrowOne cell down
EnterOne cell down
TabOne cell to the right
Shift+TabOne cell to the left
Page UpOne screen up
Page DownOne screen down
End+arrow keyIn the direction of the arrow key to the next cell containing data or to the last empty cell in current row or column
HomeTo column A in the current row
Ctrl+HomeTo cell A1
Ctrl+EndTo the last cell in the worksheet containing data


Go To a Specific Location

Click the Home tab.

Click the Find & Select button, and then click Go To.

Type the cell address to the cell location where you want to go.

To go to other locations (such as comments, blanks, last cell, objects, formulas, etc.), click Special, select an option, and then click OK.

Timesaver

To open the Special dialog box directly, click the Find & Select button, and then click Go To Special.

Click OK.

 
Others
 
- Microsoft Outlook 2010 : Working with the Ribbon and the Backstage View
- Microsoft Outlook 2010 : Working in the Outlook Program Window
- Microsoft OneOnte 2010 : Creating Pages - Choose the Default Page Template for Section Pages
- Microsoft OneOnte 2010 : Creating Sections & Creating Section Groups
- Facilitating Your Plan with Microsoft Project 2010
- Microsoft Project 2010 : Understanding Project Management Basics
- Microsoft Access 2010 : Working with Table Data
- Microsoft Access 2010 : Working with an Existing Database
- Microsoft Visio 2010 : Sharing and Publishing Diagrams - Saving in Other File Formats
- Microsoft Visio 2010 : Sharing and Publishing Diagrams - Creating Graphics
- Microsoft Word 2010 : Customizing Word - Setting Editing Options
- Microsoft Word 2010 : Customizing Word - Setting Print Options
- Microsoft PowerPoint 2010 : Presenting a Slide Show - Annotating a Slide Show
- Microsoft PowerPoint 2010 : Presenting a Slide Show - Navigating a Slide Show
- Getting Started with Microsoft Excel 2010 : Converting an Existing Workbook & Using Task and Window Panes
- Getting Started with Microsoft Excel 2010 : Creating a Workbook Using a Template & Opening an Existing Workbook
- Get Started with Outlook 2010 : Troubleshooting Connection Problems
- Get Started with Outlook 2010 : Connecting to E-Mail Accounts
- Microsoft Access 2010 : A Preview of the Database Components (part 2)
- Microsoft Access 2010 : A Preview of the Database Components (part 1)
 
 
Most View
 
- Microsoft Visio 2010 : Adding Structure to Your Diagrams - Finding Containers and Lists in Visio (part 2) - Wireframes
- Windows Server 2012 : Deploying Dynamic Access Control (part 4) - Validating the Configuration
- Exchange Server 2013 administration overview : Exchange Server and Active Directory, Exchange Online and Office 365
- Microsoft OneNore 2010 : Distributing Your Notes - Saving Pages, Sections, and Notebooks in Alternative File Formats
- Sharepoint 2013 : Understanding SharePoint app model architecture (part 3) - Understanding app hosting models
- Windows Small Business Server 2011 : Group Policy Preferences (part 1)
- Microsoft Lync Server 2010 : Installing Mediation Server (part 1) - Hardware Recommendations
- Microsoft Project 2010 : Work Breakdown Structure (part 2) - WBS and Scheduling
- Exchange Server 2013 : Defining a Highly Available Messaging Solution - Defining Availability
- Taking Microsoft Project 2010 for a Test Drive (part 2) - The Project Window
 
 
Top 10
 
- Securing an Exchange Server 2007 Environment : Securing Outlook Web Access
- Securing an Exchange Server 2007 Environment : Protecting Against Spam (part 2) - Filtering Junk Mail
- Securing an Exchange Server 2007 Environment : Protecting Against Spam (part 2) - Filtering Junk Mail
- Securing an Exchange Server 2007 Environment : Protecting Against Spam (part 1) - Protecting Against Web Beaconing
- Securing an Exchange Server 2007 Environment : Securing Outlook 2007 (part 2) - Encrypting Communications Between Outlook and Exchange , Blocking Attachments
- Securing an Exchange Server 2007 Environment : Securing Outlook 2007 (part 1) - Outlook Anywhere
- Securing an Exchange Server 2007 Environment : Securing Your Windows Environment (part 3) - Keeping Up with Security Patches and Updates
- Securing an Exchange Server 2007 Environment : Securing Your Windows Environment (part 2) - Utilizing Security Templates
- Securing an Exchange Server 2007 Environment : Securing Your Windows Environment (part 1) - Windows Server 2003 Security Improvements , Windows Vista Security Improvements
- Securing an Exchange Server 2007 Environment : Client-Level Secured Messaging - Exchange Server 2007 Client-Level Security Enhancements