Navigate and Rename Excel Worksheets



Navigate a Worksheet: You can use a few keyboard techniques that make it easier to navigate data after it is entered in a worksheet. After you enter data into a cell, it is usually easiest to use your mouse to click in the next cell you want to work with. However, if you are entering data and your hands are already on the keyboard, then it is often faster to use the keyboard to navigate to the next cell.

Rename a Worksheet: You can make your Excel workbooks easier to understand and navigate by providing each worksheet with a name that reflects the contents of the sheet. Excel provides worksheets with generic names such as Sheet1 and Sheet2, but you can change these to more descriptive names such as Sales 2010, Amortization, or Budget Data. You can use any combination of letters, numbers, and symbols in a worksheet name, but the maximum number of characters you can use in the name is 31.



Please wait...

Subscribe to ExcelMOOC posts

Want to be notified when our Excel article is published? Enter your email address and name below to know all new Excel features and cool tips