Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 1
Default How do you alphabetize a whole spreadsheet ?


  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 709
Default 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
...



  #3   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 10,124
Default 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
...



  #4   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 903
Default 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)


  #5   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 11
Default 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




  #6   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 3,290
Default 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
Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Big problem with excel recalculating spreadsheet Prometheus Excel Discussion (Misc queries) 2 August 9th 06 07:50 PM
Linked Spreadsheet Opens CarlaInJax Excel Discussion (Misc queries) 0 July 25th 06 05:17 PM
summarize data from one spreadsheet to other spreadsheet sa02000 Excel Worksheet Functions 10 June 27th 06 07:10 PM
Working spreadsheet highlighting function for Excel 2007 Mr. Low Excel Worksheet Functions 4 June 16th 06 06:12 PM
Spreadsheet merging problems Sam B Excel Worksheet Functions 0 September 19th 05 08:05 PM


All times are GMT +1. The time now is 07:34 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"