Anup singhPost 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!
