Renaming sheets in Excel
By default, worksheets are named Sheet 1, Sheet 2, etc. These should be renamed and given meaningful names so that the user knows what they contain. To rename them, right-click with the mouse and select rename and then type the new name in and press Enter. Alternatively, with a mouse, you can go to the Home menu, select the Format menu in the Cell group and Rename. This would involve the following sequence of keyboard clicks:
- Alt - provides a letter for each menu item
- H - selects the Home menu
- O - opens the Format dropdown
- R - selects Rename
- Type your new sheet name and press Enter.
The following video shows you different ways of renaming sheets.
When you have renamed your worksheets, there should be no default names and no spare worksheets, like this:
To move between worksheets using the keyboard, you can use Ctrl + Page Up/Page Down.