LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #6   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 2,344
Default sort multiple columns

Hi,

If your data setup meets the following conditions, just put your cursor in a
single cell of the column you want to sort on and click the Ascending Sort
button on the toolbar.
1. One row of headers (titles)
2. No data directly adjacent to your data that you don't want sorted (leave
a mote around your data.) For example no total row touching the data - it
may be sorted into the data.
3. No completely blank rows or columns within your data.
4. (Should not be necessary with your data) format the title row a little -
bold or center or underline or whatever.

Remember, Sort is undoable. Press Ctrl+Z if you don't like the results.
--
Thanks,
Shane Devenshire


"wynb" wrote:

good day all, i have a spreadsheet with muliple columns and rows.what i am
tring to do is sort all data by the date column and maintain the
corresponding row data to each date. any help would be appreciated.

 
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
Sort multiple columns on all worksheets jlclyde Excel Discussion (Misc queries) 2 September 17th 08 01:22 PM
SORT MULTIPLE COLUMNS AT SAME TIME automatically bkunes Excel Worksheet Functions 7 February 21st 08 05:05 PM
Sort multiple columns to look for gaps duketter Excel Discussion (Misc queries) 6 January 15th 08 08:23 PM
Sort multiple columns with multiple formulas without returning #R bellsjrb Excel Worksheet Functions 0 July 14th 06 10:01 AM
UDF to sort array with multiple columns flygis Excel Worksheet Functions 0 June 2nd 06 06:00 PM


All times are GMT +1. The time now is 10:50 AM.

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"