Sorting 7 columns

  • Thread starter Thread starter terrysoper
  • Start date Start date
T

terrysoper

How do I sort more then 4 columns? I've set up a worksheet that sort
columns in a base 1000 number system. I want to use the sheet t
organize Ideas that I get for creative writing, so to compile the Idea
in chronological order. I need to sort more then 4 columns to make it
usable worksheet. How Do I sort more then 4 columns, or get around th
problem

+-------------------------------------------------------------------
|Filename: testtwo.txt
|Download: http://www.excelforum.com/attachment.php?postid=3471
+-------------------------------------------------------------------
 
You can sort in groups of 3 columns at a time.

Sort by the least important to the most important.

With 7 columns, you'll have to sort at least 3 times.

If you find this irritating, you may want to turn on the macro recorder, and do
all 3 sorts.

Then you could just execute this macro when you want to resort the data.
 
Back
Top