LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #4   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 22,906
Default HOW DO I ALPHABETIZE MULTIPLE PAGES OF A SPREADSHEET?

In your mind, what is the difference between a "sheet" and a "page"?

Which version of Excel?

In versions earlier than 2007 you can have up to 65536 clients on a worksheet.

Those you would sort by name column.

If 2007 version you have more than one million rows to a worksheet.


Gord Dibben MS Excel MVP


On Tue, 20 May 2008 07:58:01 -0700, JAY wrote:

I AM TRYING TO MAKE A RATHER LARGE LIST OF CLIENTS, AND I WOULD LIKE TO FILE
THEM ALPHABETICALLY, BUT I AM ONLY GETTING THE FIRST SHEET TO ALPHABETIZE.
HOW DO I GET MULTIPLE PAGES TO ALL BE IN ORDER?


 
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
How do I number the pages of an Excel spreadsheet Numbering spreadsheet pages Excel Discussion (Misc queries) 1 April 18th 07 08:50 PM
How do you alphabetize a whole spreadsheet ? PageRW Excel Worksheet Functions 5 January 17th 07 10:56 PM
print excel spreadsheet splitting cell contents on multiple pages vrm7620 Excel Discussion (Misc queries) 2 October 27th 06 05:25 PM
oversize spreadsheet should spill over into multiple pages Oversize exported files to worksheet Excel Discussion (Misc queries) 4 August 4th 06 11:33 PM
How do I automatically alphabetize multiple worksheets in a singl. TS Excel Discussion (Misc queries) 2 March 19th 05 01:05 AM


All times are GMT +1. The time now is 04:08 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"