Oct 10, 2016
Microsoft Excel is one of the most popular and widely used Microsoft applications in businesses worldwide.
The capabilities of Excel are limitless if you know how to use it. However, there are some limitations in Excel as well. Those limitations can be overcome by free or paid add-ins tools. Those tools will certainly enhance the power of the Excel application.
One of my attendees for an Excel 2013 training session asked me the other day if she can make several copies of a spreadsheet without copying it one by one. She had to create the same worksheet for 31 days of the months for generating daily sales target reports for the sales team. While daily sales target varies slightly, most sales people have the same sales target value. Therefore, she wanted to make 31 copies for 31 days of the sales target report and all she has to do is to change the values for a few sales employees.
I told her that normally Microsoft Excel does not have that capability unless she is downloading an Add-Ins tool. I knew about the Kutools Add-In because I did use this tool several times in the past. Kutools Add-In is not a free download. It comes with a 60-day free trial before you need to purchase it. The trial version is fully functional.
You can download Kutools Add-In from the following website address:
After downloading it, you will see the tool listed on your Microsoft Excel Ribbon. It comes with two tabs:
See the figure below.
Kutools tab groups and commands
Enterprise tab groups and commands
Kutools Add-In has a navigation pane on left side of Excel application window. This pane gives you access to a collection of Utilities for the workbook and for the sheet. See below.
The A collection of utilities for sheet button has a drop-down list with a few great options.
One of the options is called Copy Multiple Worksheets
To create multiple copies of one worksheet in one simple way, follow the steps listed below:
- Open the workbook you want to use
- Click the A collection of utilities for sheet button
- Click the Copy Multiple Worksheets option. The Copy Multiple Worksheets dialog box will display
- Select the number of copies you want
- Select the location where you want Excel to insert the copies
The following dialog box displays:
Microsoft Excel created 31 copies of your worksheet in seconds saving you time and effort.
You just have to rename the sheets tab names and change the Title of the worksheets.