LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #3   Report Post  
Tom Ogilvy
 
Posts: n/a
Default

Sort it and if you don't like it, close it without saving.

If you do like it, but aren't sure, then do a file=Save As and give it a
new name. In either case, the original will be retained unperterbed.


For sorting, select the area you want to sort and do Data=Sort. Set the
parameters you want to use. If you select the full area you want to sort
prior to sorting, and don't let Excel expand it when it prompts, you should
have full control.

--
Regards,
Tom Ogilvy

"PeterM" wrote in message
...
I have 32k lines to sort in various ways. The area in question is almost

at
the end , and I'm scared to sort it. What is the best way to do it.Column

J
has Audi and Volkswagen in it, I need to separate them by make first.

Then
I think I'm ok. sorting gives me the heebie-jeebies ....... Many thanks in
advance.......Peter



 
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
sorting more than 3 keys Brooke Excel Discussion (Misc queries) 3 June 18th 05 04:52 AM
sorting names alphabetically when names may start with numbers John Smith Excel Discussion (Misc queries) 3 May 11th 05 08:06 PM
Using Macro to Sort Names, Numbers & addresses Tareq Excel Worksheet Functions 1 March 1st 05 02:08 PM
how to sort names and social security numbers a to z olajune1 Excel Worksheet Functions 2 February 25th 05 12:31 PM
"-" ignored in sort Mike H Excel Discussion (Misc queries) 8 January 2nd 05 07:48 AM


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