When you open Excel, it will show three blank sheets by default. They are the platform of any work on the application including calculations, charts, pivot tables and others.
It is easy to create, copy, hide, and delete a worksheet in Excel. In this post, we’ll show how you can do it in simple steps.
Create a new worksheet in Excel
Open Microsoft Excel.
Sheet names will be displayed at the bottom.
Right-click on a sheet name and choose Insert from the menu.
A small dialog box will open with Worksheet selected as the new page type. Click on OK button.
A new blank sheet will be created as shown in the above screenshot where you can start working with the numbers.
Copy an existing worksheet in Excel
Right-click on a sheet name and choose Move or Copy from the menu. Choose where do you want to insert the new sheet. Check Create a copy option. Click on OK button.
Your worksheet will be copied to a new location with all contents in it.
Hide a worksheet in Excel
Right-click on a sheet name and choose Hide option.
The selected sheet will be hidden without any mark of its existence.
Unhide a worksheet in Excel
Right-click on any sheet name in your workbook. You will see a Unhide option there if any sheet is hidden in the book.
Choose Unhide and a small dialog box will open with a full list of hidden worksheets in your book. Select a sheet and hit the OK button. The hidden sheet will be back.
Delete a worksheet in Excel
Right-click on a sheet name and choose Delete from the menu.
A confirmation box will appear to confirm the operation. Click on Delete to erase the page and its contents.