How do you alphabetize a whole spreadsheet ?
 

How do you alphabetize a whole spreadsheet ?
 

Data sort?
--
Paul B
Always backup your data before trying something new
Please post any response to the newsgroups so others can benefit from it
Feedback on answers is always appreciated!
Using Excel 2002 & 2003

"PageRW" wrote in message
...

How do you alphabetize a whole spreadsheet ?
 

The same way you explain the details of what is desired.

--
Don Guillett
SalesAid Software

"PageRW" wrote in message
...

How do you alphabetize a whole spreadsheet ?
 

If you mean sort on Column A,
1) select all the cells on the worksheet
Excel 2000 and earlier you would use Ctrl+A
With Excel 2003 and up Ctrl+A is unsafe to use
without extraordinary precautions. So I guess
you would use Ctrl+Shift+SpaceBar
2) Data, Sort,
Sort by Column A
at the bottom choose either
my list has a header row, or
my list has no headers
OK

Pages with additional help on sorting things
http://www.mvps.org/dmcritchie/excel/sorting.htm
---
HTH,
David McRitchie, Microsoft MVP - Excel
My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm
Search Page: http://www.mvps.org/dmcritchie/excel/search.htm

"PageRW" wrote
( no question posted)

How do you alphabetize a whole spreadsheet ?
 

"PageRW" wrote in message
...

Well, go to the pull down menu and choose ASAP Utilities then Sheets and
then Sort all sheets in alphabetical order. If you don't have the add-in,
you can down load the free version from
http://www.asap-utilities.com/news.php

How do you alphabetize a whole spreadsheet ?
 

Pick up the spreadsheet and gently shake it until the heaver text moves to the bottom.
--
Jim Cone
San Francisco, USA
http://www.realezsites.com/bus/primitivesoftware



"PageRW"
wrote in message