How to Create, Hide and Delete a Worksheet in Excel

Share this

worksheet Excel

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.

worksheet Excel

Right-click on a sheet name and choose Insert from the menu.

worksheet Excel

A small dialog box will open with Worksheet selected as the new page type. Click on OK button.

worksheet Excel

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.

worksheet Excel

Your worksheet will be copied to a new location with all contents in it.

worksheet Excel

Hide a worksheet in Excel

Right-click on a sheet name and choose Hide option.

worksheet Excel

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.

worksheet Excel

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.

worksheet Excel

A confirmation box will appear to confirm the operation. Click on Delete to erase the page and its contents.

That’s all.

Read  How to Quickly Shut down Your Windows 10 Computer


Share this