Microsoft Excel: Transposing a Cell Range in Excel

Home Site Map

Subject:
Microsoft Excel: Transposing a Cell Range in Excel

Body:

Your Ad Here
*******************************************************\nDUMMIES eTIPS: Health & Fitness\nhttp://etips.dummies.com\n\n*******************************************************\n\nTODAY\'S eTIP(TM): Delivering the Gluten-Free Message\n\nRestaurant cards are small cards that explain the basics of the\ngluten-free dietary guidelines that you can give to a server or\nchef. You can make your own, download one from the Internet, or\nbuy them from support groups and other entities. Basically, the\ncard says something like this:\n\nI have a severe reaction to gluten and am on a strict\ngluten-free diet. Thank you for working with me to prepare a\nmeal I can safely enjoy.\n\nI cannot eat wheat, rye, barley, or their derivatives. These\ninclude kamut, spelt, durum, semolina, bulgur, triticale,\nand malt. I also avoid oats. Foods and ingredients I need to\navoid include croutons, bread, breadings, flour, soy sauce,\norzo, buns and rolls, brown rice syrup, and malt vinegar. I\ncaneat rice, corn, potatoes, tapioca, soy, beans, amaranth,\narrowroot, buckwheat, quinoa, millet, teff, and nut flours.\nI can also eat vinegar (except malt vinegar) and distilled\nalcohols.\n\nIf you have any questions, please ask me. Thank you for\nworking with me on this! Know that you have given me the\nopportunity to relax and enjoy my meal; I appreciate that\nvery much.\n\nIf you make your own card, laminating it is a good idea, because\nit\'s likely to get covered in food when the chef handles it. You\ncan even make up several of these cards and leave them behind\nwith the chef for other patrons he or she may have in the future.\n\nFind ways to adjust your foodstuffs with Living Gluten-Free For\nDummies [ http://www.dummies.com/WileyCDA/DummiesTitle/productCd-0471773832.html?cid=etipBookLink ],\nby Danna Korn.\n\nRelated Articles\n\nCoping with Food Allergies\n[ http://www.dummies.com/WileyCDA/DummiesArticle/id-576.html?cid=etipArticleLink ]\n\nBagging the Benefits of Taking Your Lunch\n[ http://www.dummies.com/WileyCDA/DummiesArticle/id-3183.html?cid=etipArticleLink ]\n\nTaking Steps to Change Your Eating Habits\n[ http://www.dummies.com/WileyCDA/DummiesArticle/id-3338.html?cid=etipArticleLink ]\n\n*******************************************************\n\n*******************************************************\nWIN AN XBOX 360 SYSTEM!\n\nAttention all you big gamers out there! Dummies.com\nis giving you a chance to win the ultimate gaming\nconsole -\Z the new Xbox 360. You can play your favorite\ngames, as well as watch DVDs, play digital music, view\ndigital photos, and more!\n\nDrop by soon for the full details of the prize package,\nand to enter!\n\nhttp://etips.dummies.com/contest.asp?template=FORDUMMIES&cid=sweeps0506\n\n\n*******************************************************\nCATCH SUDOKU FEVER\n\nSudoku (or Su Doku) is the latest addiction to hit puzzle\nfans everywhere, and Dummies has three volumes of challenging\nSudoku puzzles to keep beginners, experts, and everyone in\nbetween plenty occupied. Give Sudoku a try by checking out\nour sample puzzles.\n\nhttp://www.dummies.com/WileyCDA/Section/id-290387.html?cid=specialtypage\n\n\n*******************************************************\nEXPERIENCE THE SPANISH LANGUAGE\n\nDiscover a wide world or information made\nfun and easy to understand with our new\nPara Dummies series.\n\nDrop in soon.\n\nhttp://ad.doubleclick.net/clk;18951747;11583957;y?http://www.dummies.com/WileyCDA/Section/id-106195.html\n\n*******************************************************\nA WORD FROM US\n*******************************************************\nHello 1@informationstreams.com. This commercial e-mail is coming\nyour way because you subscribed to the service at http://etips.dummies.com/.\nIf you\'d like to add more topics, choose a different format,\nhave your eTips sent to a different e-mail address, subtract\ntopics, or unsubscribe, visit http://etips.dummies.com/change.asp.\n\n\n*******************************************************\nA WORD FROM OUR LAWYERS\n*******************************************************\nThis absolutely FREE service is brought to you by Dummies.com (http://www.dummies.com).\n\nCopyright 2006, Wiley. All Rights Reserved.\nWiley Publishing, Inc. Attn: Dummies.com 10475 Crosspoint Blvd. Indianapolis, IN 46256\nCustomer Care: 1-877-762-2974\n\nContact Us\nhttp://www.dummies.com/WileyCDA/Section/id-100100.html\n\nPrivacy Policy\nhttp://www.dummies.com/WileyCDA/Section/id-100065.html\n\nLegal and Copyright Notices\nhttp://www.dummies.com/WileyCDA/Section/id-100099.html\n\n*******************************************************
DUMMIES eTIPS: Microsoft Excel
http://etips.dummies.com

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

TODAY'S eTIP(TM): Transposing a Cell Range in Excel

If you need to change the orientation of a cell range, Excel can
do it for you in a snap. If you transpose a range, rows become
columns and columns become rows.

To transpose a range, follow these steps:

1. Select the range to transpose.

2. Choose Edit, Copy (or press Ctrl+C or click the Copy
button on the Standard toolbar).

3. Click the upper-left cell where you want the transposed
range to go.

The transposed range can't overlap the original range.

4. Choose Edit, Paste Special.

5. Select the Transpose check box in the Paste Special
dialog box.

6. Click OK.

7. Delete the original range, if necessary.

Remember that Excel adjusts any formulas in the original range so
that they work correctly after you transpose them.

If you need quick Excel help, check out Excel 2003 For Dummies
Quick Reference [ http://www.dummies.com/WileyCDA/DummiesTitle/productCd-0764539876.html?cid=etipBookLink ],
by John Walkenbach and Colin Banfield.

Related Articles

Opening Files with a Twist in Excel 2003
[ http://www.dummies.com/WileyCDA/DummiesArticle/id-297.html?cid=etipArticleLink ]

Using Columns and Bars to Compare Items in Excel Charts
[ http://www.dummies.com/WileyCDA/DummiesArticle/id-3122.html?cid=etipArticleLink ]

Solving the Mystery of the Disappearing Record in Access 2002
[ http://www.dummies.com/WileyCDA/DummiesArticle/id-286.html?cid=etipArticleLink ]

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

*******************************************************
WIN AN XBOX 360 SYSTEM!

Attention all you big gamers out there! Dummies.com
is giving you a chance to win the ultimate gaming
console - the new Xbox 360. You can play your favorite
games, as well as watch DVDs, play digital music, view
digital photos, and more!

Drop by soon for the full details of the prize package,
and to enter!

http://etips.dummies.com/contest.asp?template=FORDUMMIES&cid=sweeps0506

*******************************************************
CATCH SUDOKU FEVER

Sudoku (or Su Doku) is the latest addiction to hit puzzle
fans everywhere, and Dummies has three volumes of challenging
Sudoku puzzles to keep beginners, experts, and everyone in
between plenty occupied. Give Sudoku a try by checking out
our sample puzzles.

http://www.dummies.com/WileyCDA/Section/id-290387.html?cid=specialtypage

*******************************************************
EXPERIENCE THE SPANISH LANGUAGE

Discover a wide world or information made
fun and easy to understand with our new
Para Dummies series.

Drop in soon.

http://ad.doubleclick.net/clk;18951747;11583957;y?http://www.dummies.com/WileyCDA/Section/id-106195.html

*******************************************************
A WORD FROM US
*******************************************************
Hello 1@informationstreams.com. 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).

Copyright 2006, Wiley. All Rights Reserved.
Wiley Publishing, Inc. Attn: Dummies.com 10475 Crosspoint Blvd. Indianapolis, IN 46256
Customer Care: 1-877-762-2974

Contact Us
http://www.dummies.com/WileyCDA/Section/id-100100.html

Privacy Policy
http://www.dummies.com/WileyCDA/Section/id-100065.html

Legal and Copyright Notices
http://www.dummies.com/WileyCDA/Section/id-100099.html

Date: 2006-06-13 - 01:10:06

Back

Subject:	Microsoft Excel: Transposing a Cell Range in Excel
Body: Your Ad Here	*****************************************************\nDUMMIES eTIPS: Health & Fitness\nhttp://etips.dummies.com\n\n***************************************************\n\nTODAY\'S eTIP(TM): Delivering the Gluten-Free Message\n\nRestaurant cards are small cards that explain the basics of the\ngluten-free dietary guidelines that you can give to a server or\nchef. You can make your own, download one from the Internet, or\nbuy them from support groups and other entities. Basically, the\ncard says something like this:\n\nI have a severe reaction to gluten and am on a strict\ngluten-free diet. Thank you for working with me to prepare a\nmeal I can safely enjoy.\n\nI cannot eat wheat, rye, barley, or their derivatives. These\ninclude kamut, spelt, durum, semolina, bulgur, triticale,\nand malt. I also avoid oats. Foods and ingredients I need to\navoid include croutons, bread, breadings, flour, soy sauce,\norzo, buns and rolls, brown rice syrup, and malt vinegar. I\ncaneat rice, corn, potatoes, tapioca, soy, beans, amaranth,\narrowroot, buckwheat, quinoa, millet, teff, and nut flours.\nI can also eat vinegar (except malt vinegar) and distilled\nalcohols.\n\nIf you have any questions, please ask me. Thank you for\nworking with me on this! Know that you have given me the\nopportunity to relax and enjoy my meal; I appreciate that\nvery much.\n\nIf you make your own card, laminating it is a good idea, because\nit\'s likely to get covered in food when the chef handles it. You\ncan even make up several of these cards and leave them behind\nwith the chef for other patrons he or she may have in the future.\n\nFind ways to adjust your foodstuffs with Living Gluten-Free For\nDummies [ http://www.dummies.com/WileyCDA/DummiesTitle/productCd-0471773832.html?cid=etipBookLink ],\nby Danna Korn.\n\nRelated Articles\n\nCoping with Food Allergies\n[ http://www.dummies.com/WileyCDA/DummiesArticle/id-576.html?cid=etipArticleLink ]\n\nBagging the Benefits of Taking Your Lunch\n[ http://www.dummies.com/WileyCDA/DummiesArticle/id-3183.html?cid=etipArticleLink ]\n\nTaking Steps to Change Your Eating Habits\n[ http://www.dummies.com/WileyCDA/DummiesArticle/id-3338.html?cid=etipArticleLink ]\n\n***************************************************\n\n***************************************************\nWIN AN XBOX 360 SYSTEM!\n\nAttention all you big gamers out there! Dummies.com\nis giving you a chance to win the ultimate gaming\nconsole -\Z the new Xbox 360. You can play your favorite\ngames, as well as watch DVDs, play digital music, view\ndigital photos, and more!\n\nDrop by soon for the full details of the prize package,\nand to enter!\n\nhttp://etips.dummies.com/contest.asp?template=FORDUMMIES&cid=sweeps0506\n\n\n***************************************************\nCATCH SUDOKU FEVER\n\nSudoku (or Su Doku) is the latest addiction to hit puzzle\nfans everywhere, and Dummies has three volumes of challenging\nSudoku puzzles to keep beginners, experts, and everyone in\nbetween plenty occupied. Give Sudoku a try by checking out\nour sample puzzles.\n\nhttp://www.dummies.com/WileyCDA/Section/id-290387.html?cid=specialtypage\n\n\n***************************************************\nEXPERIENCE THE SPANISH LANGUAGE\n\nDiscover a wide world or information made\nfun and easy to understand with our new\nPara Dummies series.\n\nDrop in soon.\n\nhttp://ad.doubleclick.net/clk;18951747;11583957;y?http://www.dummies.com/WileyCDA/Section/id-106195.html\n\n***************************************************\nA WORD FROM US\n***************************************************\nHello 1@informationstreams.com. This commercial e-mail is coming\nyour way because you subscribed to the service at http://etips.dummies.com/.\nIf you\'d like to add more topics, choose a different format,\nhave your eTips sent to a different e-mail address, subtract\ntopics, or unsubscribe, visit http://etips.dummies.com/change.asp.\n\n\n***************************************************\nA WORD FROM OUR LAWYERS\n***************************************************\nThis absolutely FREE service is brought to you by Dummies.com (http://www.dummies.com).\n\nCopyright 2006, Wiley. All Rights Reserved.\nWiley Publishing, Inc. Attn: Dummies.com 10475 Crosspoint Blvd. Indianapolis, IN 46256\nCustomer Care: 1-877-762-2974\n\nContact Us\nhttp://www.dummies.com/WileyCDA/Section/id-100100.html\n\nPrivacy Policy\nhttp://www.dummies.com/WileyCDA/Section/id-100065.html\n\nLegal and Copyright Notices\nhttp://www.dummies.com/WileyCDA/Section/id-100099.html\n\n*************************************************** DUMMIES eTIPS: Microsoft Excel http://etips.dummies.com *************************************************** TODAY'S eTIP(TM): Transposing a Cell Range in Excel If you need to change the orientation of a cell range, Excel can do it for you in a snap. If you transpose a range, rows become columns and columns become rows. To transpose a range, follow these steps: 1. Select the range to transpose. 2. Choose Edit, Copy (or press Ctrl+C or click the Copy button on the Standard toolbar). 3. Click the upper-left cell where you want the transposed range to go. The transposed range can't overlap the original range. 4. Choose Edit, Paste Special. 5. Select the Transpose check box in the Paste Special dialog box. 6. Click OK. 7. Delete the original range, if necessary. Remember that Excel adjusts any formulas in the original range so that they work correctly after you transpose them. If you need quick Excel help, check out Excel 2003 For Dummies Quick Reference [ http://www.dummies.com/WileyCDA/DummiesTitle/productCd-0764539876.html?cid=etipBookLink ], by John Walkenbach and Colin Banfield. Related Articles Opening Files with a Twist in Excel 2003 [ http://www.dummies.com/WileyCDA/DummiesArticle/id-297.html?cid=etipArticleLink ] Using Columns and Bars to Compare Items in Excel Charts [ http://www.dummies.com/WileyCDA/DummiesArticle/id-3122.html?cid=etipArticleLink ] Solving the Mystery of the Disappearing Record in Access 2002 [ http://www.dummies.com/WileyCDA/DummiesArticle/id-286.html?cid=etipArticleLink ] *************************************************** *************************************************** WIN AN XBOX 360 SYSTEM! Attention all you big gamers out there! Dummies.com is giving you a chance to win the ultimate gaming console - the new Xbox 360. You can play your favorite games, as well as watch DVDs, play digital music, view digital photos, and more! Drop by soon for the full details of the prize package, and to enter! http://etips.dummies.com/contest.asp?template=FORDUMMIES&cid=sweeps0506 *************************************************** CATCH SUDOKU FEVER Sudoku (or Su Doku) is the latest addiction to hit puzzle fans everywhere, and Dummies has three volumes of challenging Sudoku puzzles to keep beginners, experts, and everyone in between plenty occupied. Give Sudoku a try by checking out our sample puzzles. http://www.dummies.com/WileyCDA/Section/id-290387.html?cid=specialtypage *************************************************** EXPERIENCE THE SPANISH LANGUAGE Discover a wide world or information made fun and easy to understand with our new Para Dummies series. Drop in soon. http://ad.doubleclick.net/clk;18951747;11583957;y?http://www.dummies.com/WileyCDA/Section/id-106195.html *************************************************** A WORD FROM US *************************************************** Hello 1@informationstreams.com. 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). Copyright 2006, Wiley. All Rights Reserved. Wiley Publishing, Inc. Attn: Dummies.com 10475 Crosspoint Blvd. Indianapolis, IN 46256 Customer Care: 1-877-762-2974 Contact Us http://www.dummies.com/WileyCDA/Section/id-100100.html Privacy Policy http://www.dummies.com/WileyCDA/Section/id-100065.html Legal and Copyright Notices http://www.dummies.com/WileyCDA/Section/id-100099.html
Date:	2006-06-13 - 01:10:06