The best keyboard shortcuts for moving in a workbook - Help and How-to

Click here to switch to other Office Online sites worldwide

United Kingdom (change) | All Microsoft Sites

	Help and How-to

Search

	Buy Office 2007 Free Office 2007 trial
Get Office 2007

	Technical support Register your product
Help & support

	Check for free updates
Office updates

Help and How-to

» Help and How-to home

Help by Product

» All Products

How-to Resources

» Training

» Demos

» Get Started with the 2007 Programs

» 2007 Training Course Catalog

» User Interface Guides

» Office Online Site Help

Support and Feedback

» Product Support

» Send Us Your Comments

Technical Resources

» Office System on TechNet

» Developer Center

» Office Resource Kit

» Microsoft Security

» For Office Live Partners

Additional Resources

» For Small Businesses

» Office Marketplace

» Discussion Groups

» Enterprise Solutions

» Microsoft Learning

Get Office 2007

» Buy Office 2007

» Free 60-day Trial

Home > Help and How-to

Warning: You are viewing this page with an unsupported Web browser. This Web site works best with Microsoft Internet Explorer 6.0 or later, Firefox 1.5, or Netscape Navigator 8.0 or later. Learn more about supported browsers.

Printer-Friendly Version

The best keyboard shortcuts for moving in a workbook

Applies to
Microsoft Excel 2000

The best way to move around in a workbook is to get to know the keyboard shortcuts PAGE UP and PAGE DOWN. Used with the ALT key, each combination scrolls through the worksheet one screen's width.

Picture of which directions PAGE UP, PAGE DOWN, ALT+PAGE UP, and ALT+PAGE DOWN scroll through the screen.

There are other useful keyboard shortcuts to use for moving in a workbook.

Press	To
PAGE DOWN	Move down one screen
PAGE UP	Move up one screen
ALT+PAGE DOWN	Move one screen to the right
ALT+PAGE UP	Move one screen to the left
CTRL+HOME	Move to the beginning of the worksheet
CTRL+END	Move to the last cell on the worksheet, which is the cell at the intersection of the rightmost used column and the bottommost used row (in the lower-right corner), or the cell opposite the home cell, which is typically A1
CTRL+PAGE DOWN	Move to the next sheet in the workbook
CTRL+PAGE UP	Move to the previous sheet in the workbook
CTRL+F6 or CTRL+TAB	Move to the next workbook or window

For more information about keyboard shortcuts, type shortcuts in the Office Assistant or on the Answer Wizard tab in the Excel Help window, and then click Search.

Get Office 2007