Instead, it's usually better to replicate an existing sheet, and there's a quick shortcut for that. Simply hold down the Ctrl key while clicking and dragging the tab of the sheet. When you let go of the mouse, Excel will duplicate the sheet exactly. To see this shortcut in action, watch the video below.
Select the sheet you wish to duplicate with a left-click and hold.
Keep the Ctrl key pressed and held. In the sheet mouse icon, a plus sign will show.
Drag the sheet to the right until the right-hand down arrow appears.
The left mouse button should be released. Then press and hold the Ctrl key.
To do so, first select all of the sheets you want to remove. Hold down the Ctrl key and then click on each of the worksheets you wish to delete to select them all.
The following keyboard shortcut will remove the active sheet or the selected sheets if we want to use the keyboard instead of the mouse.
Use the keyboard shortcut ALT + H + D + S to delete the sheet.
As a result, Sheet1 has vanished from our workbook.
Learner's Ratings
4.7
Overall Rating
83%
10%
4%
3%
0%
Reviews
P
Prabhat Yadav
5
Superb and amazing 😍🤩 enjoyable experience.
P
pritam chakraborty
5
very good
S
Sudip Sadhukhan
5
Very good teaching technique. And it is totally free so who has only want to learn free so it is so much useful for them. Thank you
S
sadananda basak
5
Teaching technique is easy to understand. Thanks.
J
Joydeep
5
nice
U
Uttam Nandi
5
Very nice teaching.
R
RABIN DEY
5
REALLY HELPFUL COURSE
S
Subhasis Bosu
5
good
A
Anamul Huq
5
This is helpful how are zero to intermediate level.
Share a personalized message with your friends.