Question
How to insert, move, & rename worksheets in Excel?
Answer
Worksheets are much like pages within a book; you peruse through them like you flip the pages of a book. There are several ways to move and copy worksheets. Right click on the sheet tab and choose Move or Copy. Select a new position in the workbook for the worksheet or click the Create a copy checkbox and Excel will paste a copy of that worksheet in the workbook. The same shortcut menu for the sheet tab also gives you the option to insert, delete, or rename a worksheet.
Navigation Keystrokes
| Keystroke |
Action |
| ↑, ↓, ←, → |
Moves the active cell up, down, right, or left one cell |
| Enter |
Moves the active cell down one cell |
| Tab |
Move the active cell to the right one cell |
| Page Up |
Moves the active cell up one full screen |
| Page Down |
Moves the active cell down one full screen |
| Home |
Moves the current cell to column A of the active row |
| Ctrl + Home |
Moves the current cell A1 |
| F5 (Function Key) |
Opens the “Go To” dialog box in which you can enter the cell address of the cell you wish to make active |
For more information about Microsoft Excel Basics, please view the full tutorial from the CTL here: Excel Part 1
If you need further assistance, please click the CTL Support Request button on this page.