Higher the number of worksheets in an Excel file, higher the time spent trying to find a specific sheet. In this guide, we’re going to show you how to manage worksheets in Excel with some simple tips and shortcuts.
See all sheets and navigate
To see the list of all visible (not hidden) worksheets and quickly move to another, right click on the two arrows (◄►) next to the sheet tabs. Once the list is open, double-click on the sheet you want to go.
Navigate to the first or last sheet
You can directly go to the first or the last sheet using a keyboard - mouse click combination:
- Hold Ctrl and left click on the left arrow (◄) to go to the first sheet
- Hold Ctrl and left click on the right arrow (►) to go to the last sheet
Move between worksheets
This trick is useful for when you need to check each sheet manually. Use the following shortcuts to navigate between sheets one-by-one:
- Next worksheet: Ctrl + Page Down
- Previous worksheet: Ctrl + Page Up
Commands to manage worksheets
Our next tip for managing the worksheets is helpful for configuring them. Right-clicking on a worksheet name reveals a menu with all available commands for the selected worksheet.
Move or copy a sheet
From the context menu, you can copy your worksheet using the Move or Copy command. However, there is an easier way to do this: drag & drop.
You can click, hold, and move a sheet with your mouse. You can copy the sheet using the same method by holding down the Ctrl button before clicking.
Insert a new worksheet
Another command in the context menu which you can apply with a single shortcut is for creating new worksheets. Just press Shift + F11 keys to insert a new sheet.
Please note that, if you click Ctrl + F11, you will see that a worksheet is added under the name Macro1. Although it looks like a worksheet, it is not. Macro sheets are from the outdated Excel 4.0 macros, and are still kept for backward compatibility. If you want to use macros, try Visual Basic for Applications (VBA).