Move (Or Copy) A Batch Of Excel Worksheets


Key to Instructions
To help readers follow the instructions in this article, we used two different typefaces:
Boldface type is used to identify the names of icons, agendas and URLs.
Sans serif type indicates the names of files and the names of commands and instructions users should type into the computer.

Q. How can I move many Excel worksheets at once from one workbook to another? It’s very time-consuming to move them one at a time.

A. I’ll show you an easy way. The process also gives you the choice of moving them or copying them to another worksheet. Here are the steps:

Open the workbook. Let’s say you named it Division Finance, which contains four worksheets—Divisions 1, 2, 3 and 4. Hold down the Ctrl button and click on the tab of each worksheet you wish to move or copy. When you’re finished, right-click to bring up the screen below.

Click on Move or Copy . Notice Excel recognizes which worksheets you want to act on, as shown in the screen at below.

Now you must instruct Excel whether you want to move or copy the worksheets. If you want to copy them, check the Create a copy box; to move them, leave the box empty. No matter whether you want them moved or copied, tell Excel, in the box labeled To book, where to place the sheets. The default location is the same workbook. If you click on the down-pointing arrow, the screen at right will appear, giving you the option of moving (or copying, if you checked the Create a copy box) to a new file, which is automatically named Book1 by Excel. Afterwards, you can give Book1 a new name.

When finished, click on OK .


Why cybercriminals are targeting CPAs

This free report expands on the most commonly found scams, why education and specialized IT knowledge help to lessen security vulnerabilities, and why every firm should plan carefully for how it would respond to a breach.


How tax reform will impact individual taxpayers

Amy Wang, a CPA who is a senior technical manager for tax advocacy at the AICPA, answers to some of the most common questions on how the new tax reform law will impact individual taxpayers.