exceltoxl.com

Hi there,

Reporting team will have to work on weekly, bi-weekly, monthly or yearly reports on day-to-day reporting. This reporting mostly involves in duplicating worksheets except 5% of manual changes.

Let me explain with example: Say, we are working on Attendance report. Each sheet is renamed with Date, starting from 01-01-2015 till 01-31-2015. Here we require 31 sheets to display. The change between one sheet to the another is nothing except renaming the sheet name with different date. 

To do this, we will work on one sheet and then we will copy and insert the sheet next to the existing by renaming the sheet to next date. Similarly we will do it for the rest of the sheets.

...

MOVE/COPY/DUPLICATE SHEETS (3 ways to go):

Here the regular process we follow is to right click on the sheet using mouse and will choose move/copy option to place the sheet in the same workbook to duplicate the worksheet.

The second method is:

GoTo HOME Ribbon -->CELLS Group -->Under FORMAT Icon --> Select Move or Copy Sheet Option as shown below.

But, these both are tidious to do when compared to what the third trick I am going to show it here.

The Third Method is:

Hold CTRL button and drag the sheet to where ever the sheet to be appeared as duplicate. Leave the mouse button to see the duplicate sheet.

That's it. Magic works!!!

DO YOU USE CTRL MOVE OPTION?

Please do share with us how you do to achieve this result, in the below comments section.

If you like this post, please do share it on your social networking sites, by clicking on the icons placed around the blog.

If you want to support me for maintaining this blog, REGISTER here for free.

SOME IMPORTANT LINKS:

Few more Shortcuts on Excel

Best ways of using Excel on Day-to-Day

50+ Excel Tips & Tricks

Thanks,