Printer Friendly

Move (or copy) a batch of Excel worksheets.

Key to Instructions

To help readers follow the instructions in this article, we use two different typefaces:

* Boldface type is used to identify the names of icons, agendas and URLs.

* Sans serif type shows 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 at left.

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

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 Boom a new name.

When finished, click on OK.
COPYRIGHT 2004 American Institute of CPA's
No portion of this article can be reproduced without the express written permission from the copyright holder.
Copyright 2004, Gale Group. All rights reserved. Gale Group is a Thomson Corporation Company.

Article Details
Printer friendly Cite/link Email Feedback
Title Annotation:Technology Q&A
Author:Zarowin, Stanley
Publication:Journal of Accountancy
Date:Nov 1, 2004
Previous Article:Nonindividual QTP contributions: how employers can help workers save for college.
Next Article:Expand the use of format painter in word.

Related Articles
Spreadsheets: faster, smarter.
The power of spreadsheets.
Show-and-tell in real time: link a spreadsheet to a PowerPoint slide for up-to-the-minute visuals.
Technology Q&A: control Excel's underline function ... learn the nuances of AutoFill ... put worksheets in separate panes ... an easy way to...
Copy print settings in excel worksheets.
Transfer excel formula from one worksheet to another.
Enter data simultaneously on multiple sheets.
Prepare a workpaper stamp.
Navigate speedily in excel data: click on a button to get to target information.

Terms of use | Copyright © 2018 Farlex, Inc. | Feedback | For webmasters