bottom
Great ExcelTips!
         
Your e-mail address is safe!
Close Note

Tips.Net > ExcelTips Home > Worksheets > Moving from Sheet to Sheet

Moving from Sheet to Sheet

Summary: You can use the keyboard to accomplish many common tasks in Excel. You can even use the keyboard to move between worksheets, as described in this tip. (This tip works with Microsoft Excel 97, Excel 2000, Excel 2002, and Excel 2003.)

If you want to quickly move from one worksheet to another using the keyboard, you can do so by using Ctrl+PgUp and Ctrl+PgDown. You use Ctrl+PgUp to move toward the first worksheet in the workbook, and Ctrl+PgDown to move toward the last. When you reach the first or last worksheet, Excel does not wrap to the opposite end of the workbook if you continue to press the same shortcut key.

Tip #2143 applies to Microsoft Excel versions: 97 | 2000 | 2002 | 2003


Save Time! You can have this tip (and several hundred just like it) in the ExcelTips annual archives. Imagine having over 400 tips available at your fingertips, in each annual volume.

Helpful Links

Ask an Excel Question
Make a Comment

Tips.Net Home
Vital News Home

ExcelTips FAQ
ExcelTips Premium

Learn Access Now

Beauty Tips
Bugs and Pests Tips
Car Tips
Cleaning Tips
College Tips
Cooking Tips
Excel2007 Tips
ExcelTips
Family Tips
Gardening Tips
Health Tips
Home Tips
Money Tips
Organizing Tips
Pet Tips
Word2007 Tips
WordTips

Advertise on the
ExcelTips Site

 

Great Info!

Get tips like this every week in ExcelTips, a free productivity newsletter. Enter your e-mail address and click "Subscribe."
     
(Your e-mail address will never be shared with anyone, ever.)