Move (Or Copy) A Batch Of Excel Worksheets

BY STANLEY ZAROWIN

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 .

SPONSORED REPORT

How to make the most of a negotiation

Negotiators are made, not born. In this sponsored report, we cover strategies and tactics to help you head into 2017 ready to take on business deals, salary discussions and more.

VIDEO

Will the Affordable Care Act be repealed?

The results of the 2016 presidential election are likely to have a big impact on federal tax policy in the coming years. Eddie Adkins, CPA, a partner in the Washington National Tax Office at Grant Thornton, discusses what parts of the ACA might survive the repeal of most of the law.

QUIZ

News quiz: Scam email plagues tax professionals—again

Even as the IRS reported on success in reducing tax return identity theft in the 2016 season, the Service also warned tax professionals about yet another email phishing scam. See how much you know about recent news with this short quiz.