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 .


Year-end tax planning and what’s new for 2016

Practitioners need to consider several tax planning opportunities to review with their clients before the end of the year. This report offers strategies for individuals and businesses, as well as recent federal tax law changes affecting this year’s tax returns.


News quiz: Retirement planning, tax practice, and fraud risk

Recent reports focused on a survey that gauges the worries about retirement among CPA financial planners’ clients, a suit that affects tax practitioners, and a guide that offers advice on fraud risk. See how much you know with this short quiz.


Bolster your data defenses

As you weather the dog days of summer, it’s a good time to make sure your cybersecurity structure can stand up to the heat of external and internal threats. Here are six steps to help shore up your systems.