Microsoft Excel: Transferring Sheets Among Workbooks

*******************************************************
DUMMIES eTIPS: Microsoft Excel
http://etips.dummies.com

*******************************************************

TODAY'S eTIP(TM): Transferring Sheets Among Workbooks

Instead of copying cell ranges from one workbook to another,
Excel enables you to move (or copy) entire worksheets between
workbooks. You can do this by dragging-and-dropping or by using
the Edit, Move or Copy menu command.

To use drag-and-drop to move a sheet between open windows, simply
drag a sheet tab from one window to the row of sheet tabs in the
other window. As soon as you release the mouse button, the entire
worksheet is moved from one file to the other, and its sheet tab
now appears among the others in that workbook. To copy a sheet
rather than move it, just hold down the Ctrl key as you
drag-and-drop.

To use the Edit, Move or Copy Sheets command, follow these steps:

1. Select the sheet tab you want to move or copy.

To select more than one sheet, hold down the Ctrl key while
selecting multiple sheets.

2. Choose Edit, Move or Copy Sheets on the menu bar.

The Move or Copy dialog box appears.

3. Click the filename of the workbook into which you want
to move or copy the sheet.

4. Click the name of the sheet that should immediate
follow the sheet(s) that you're about to move or copy
in the Before Sheet list.

5. If you want to copy the selected sheets rather than
move them, click the Create a Copy check box.

6. Click OK.

For more on working with Excel worksheets, check out Excel 2003
All-in-One Desk Reference For Dummies
[
http://portal.hungryminds.com/etip.asp?topic=dd01&promo=FeaturedTitles&link=www.dummies.com/WileyCDA/DummiesTitle/productCd-076453758X.html
],
by Greg Harvey.

Password-Protecting an Excel 2003 File
[
http://portal.hungryminds.com/etip.asp?topic=dd01&promo=RelatedArticles&link=www.dummies.com/WileyCDA/DummiesArticle/id-2200.html
]

Using AutoFilter in Excel 2003
[
http://portal.hungryminds.com/etip.asp?topic=dd01&promo=RelatedArticles&link=www.dummies.com/WileyCDA/DummiesArticle/id-2201.html
]

Working with Multiple Excel 2003 Workbooks
[
http://portal.hungryminds.com/etip.asp?topic=dd01&promo=RelatedArticles&link=www.dummies.com/WileyCDA/DummiesArticle/id-2198.html
]

*******************************************************

*******************************************************
NEW TITLES ON DUMMIES.COM!

Don't miss your chance for enrichment with these new
titles, now available at dummies.com.

The updated edition of iPod & iTunes For Dummies covers
cool new third-party accessories, new iTunes features,
iPod functions, troubleshooting, and more; while the
second edition of Wedding Planning For Dummies will
help you plan a dream wedding on any budget. Check
them both out today!

iPod & iTunes For Dummies, 2nd Edition
http://portal.hungryminds.com/etip.asp?topic=dd01&promo=iPoditunesFD&link=www.dummies.com/remtitle.cgi?track=DUMETIPS:0764577727%26site=D%26isbn=0764577727

Wedding Planning For Dummies, 2nd Edition
http://portal.hungryminds.com/etip.asp?topic=dd01&promo=WeddingPlanningFD&link=www.dummies.com/remtitle.cgi?track=DUMETIPS:0764556851%26site=D%26isbn=0764556851

*******************************************************
GO YOUR OWN WAY

Find new insight and inspiration to start and
grow your own small business on our Small Business
& Entrepreneurship page.

Check it out soon.

http://portal.hungryminds.com/etip.asp?topic=dd01&promo=SmallBusinessLgBanner&link=www.dummies.com/WileyCDA/Section/id-100041.html

*******************************************************
FINE TUNE YOUR CREATIVE SIDE

Find new ways to explore the arts -� from learning
a new musical instrument to writing great prose --
with help from our Arts & Music subctegory.

Drop by for a visit anytime.

http://portal.hungryminds.com/etip.asp?topic=dd01&promo=ArtsMusicBanner&link=www.dummies.com/WileyCDA/Section/id-100049.html

*******************************************************
A WORD FROM US
*******************************************************
Hello [EMAIL PROTECTED] This commercial e-mail is coming
your way because you subscribed to the service at http://etips.dummies.com/.
If you'd like to add more topics, choose a different format,
have your eTips sent to a different e-mail address, subtract
topics, or unsubscribe, visit http://etips.dummies.com/change.asp.

*******************************************************
A WORD FROM OUR LAWYERS
*******************************************************
This absolutely FREE service is brought to you by Dummies.com (http://www.dummies.com).

A Word From Our Lawyers
http://etips.dummies.com/disclaimer.html

Reply via email to