You can see worksheets in the sheet tab, which is just above the status bar. The default number of worksheet in a Workbook is three. Using the following path you can customize the number of worksheets to be opened every time when you create a new file.
Tools => Options => General tab => Sheets in new workbook and change the number.
Inserting worksheets:
To insert an additional worksheet, follow any one of the options below:
- Press Shift and F11 key at a time.
- Select ‘Insert worksheet’ from Insert Menu
- Keep your mouse on sheet tab, which is above status bar and right click the mouse. A pop-up menu appears. Select ‘Insert’ from the pop-up menu. (Recommended option)
Tip: Using this pop-up menu option, you can even insert multiple worksheets. Hold shift key to select many worksheets and select ‘Insert’ from the pop-up menu.
Move or Copy Worksheets
Worksheets can be moved within workbook. It can also be moved to an existing workbook or a new workbook.
To move a worksheet, follow any one of the options below:
- Select ‘Move or Copy’ from Edit menu.
- Drag the sheet directly into the desired location.
- Keep your mouse on sheet tab, which is above status bar and right click the mouse. A pop-up menu appears. Select ‘Move’ from the pop-up menu. (Recommended option)
A dialog box appears now. You need to choose the exact location where you want to move. Use ‘To book’ drop menu if you like to move it to an existing worksheet or a new worksheet.
Tip: To make a similar copy of worksheet please enable the option ‘Create a copy’ in the dialog box.
Info: Always save your workbook before performing this command.
Delete Worksheets
A workbook must have minimum one worksheet. Keeping any one worksheet available in the workbook you can delete one or more number of worksheets.
To delete a worksheet, follow any one of the options below:
- Select ‘Delete sheet’ from Edit menu.
- Keep your mouse on sheet tab, which is above status bar and right click the mouse. A pop-up menu appears. Select ‘Delete’ from the pop-up menu. (Recommended option)
Tip: Using this pop-up menu option, you can even delete multiple worksheets. Hold your shift key to select many worksheets and select ‘delete’ from the pop-up menu.
Info: Remember deleted sheets will be lost and unrecoverable so always save your workbook before performing deleting operations.
Hide and Unhide Worksheets
You can hide a worksheet if you do not like to keep it in display. You can unhide it whenever you want. Click ‘Format’ Menu, click ‘Sheet’ submenu and find Hide or Unhide options.
Info: Worksheets that are hidden by Visual Basic program cannot be Unhide by this method. We will discuss soon how to unhide a workbook that is made hidden by visual basic program.
.jpg)
