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 .


Revenue recognition: A complex effort

Implementing the new standard requires careful judgment. Learn how to make significant accounting judgments and document them and collaborate with peers for consistent application.


How to Excel pivot a general ledger

The general ledger is a vast historical data archive of your company's financial activities, including revenue, expenses, adjustments, and account balances. J. Carlton Collins, CPA, shows how to prepare data for, and mine data with, PivotTables.


News quiz: Taking an economic snapshot and looking to the future

Recent news included IRS actions that affect individuals and partnerships and a possibly influential move by a Big Four accounting firm.Take this short quiz to see how much you know about the news.