How to Insert or Delete a Worksheet in Excel 2016?


Post learning about “How to Create a New Workbook in Microsoft Excel?“, now we will see about how to insert, rename, or delete a worksheet in excel 2016, with some of its shortcut keys.

How to Insert a Worksheet?

In excel you can easily insert a worksheet. Let’s see how we can insert it…

Click on the “+” icon at the bottom of the screen

OR

Another way, from the “Home” Tab Under the “Cells” group -> insert click on “Insert Sheet”.

Insert Excel Sheet Via Shortcut Key

Press “SHIFT + F11” or “Press “ALT + SHIFT +F11” to insert an excel sheet, with the help of this shortcut key you can insert multiple worksheets.


How to Rename a Worksheet?

1. To rename it double click on sheet and rename it as per your need

OR

2. Right Click on the sheet and choose the option to “Rename” it.


How to Delete a Worksheet?

  • Right-click on the sheet and choose the option “Delete” or Press “D” only after right click on the sheet, that sheet will be deleted.
  • Choose the sheet that you want to delete. Go to “Home” Tab “Delete” under the “Cells” group and select “Delete Sheet or Press S”.

Delete a Worksheet via Shortcut

Choose the sheet that you want to delete and press  ‘Alt’ + ‘H’, ‘D’, ‘S’, that sheet will be deleted.


How to Delete Multiple Excel Sheets?

To delete multiple sheets first you need to select the sheets that you want to delete.

To select multiple sheets hold “CTRL” and select sheets one by one, you can also select any alternate sheet. After that right-click on any selected sheet and choose the option “Delete”. Let’s see below:


For Latest Updates & Learning Join Our YouTube Channel: Join Now

If you have any query related to this topic then please do write your query below in the comment box!

author

EduTaxTuber Team

We are here to help for every updates related to everything...👍📙👍📗

Similar Posts

Leave a Reply

England vs Senegal: FIFA World Cup 2022 No Curfew in Mumbai: Section 144 Imposed to ensure Peace Elon Musk suspends Kanye West Twitter Account for inciting violence Pak Vs England: England vs Pakistan FIFA World Cup 2022: CBDT Notifies Income Tax Exemption
Ads Blocker Image Powered by Code Help Pro

Ads Blocker Detected!!!

We have detected that you are using extensions to block ads. Please support us by disabling these ads blocker.

Powered By
Best Wordpress Adblock Detecting Plugin | CHP Adblock