Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 22
Default Sort all cells except one?

I have a spreadsheet with a sort on the date column (A). All columns (B-K)
correspond with column A. I have a notes section placed on the same sheet
which is column K and all of these rows under this column need to be merged
but when I do so I can no longer sort ascending or descending.

So my question is...

Is there any way I can exclude column K from the sort?
  #2   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 8,651
Default Sort all cells except one?

Select the columns (and, if necessary, the rows) which you want to sort,
before you impose the sort.
By the way, you'll find that merging cells is strongly discouraged here.
--
David Biddulph

"HoganD87" wrote in message
...
I have a spreadsheet with a sort on the date column (A). All columns (B-K)
correspond with column A. I have a notes section placed on the same sheet
which is column K and all of these rows under this column need to be
merged
but when I do so I can no longer sort ascending or descending.

So my question is...

Is there any way I can exclude column K from the sort?



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
Sort a list with cells referring to others cells Friis(DK) Excel Discussion (Misc queries) 6 February 24th 07 03:56 AM
sort spreadsheet, "merged cells" comes up. Find cells? Unmerge ? lowell Excel Discussion (Misc queries) 1 August 20th 06 09:10 AM
How do I sort protected cells? Stephen238 Excel Discussion (Misc queries) 5 September 13th 05 11:11 PM
sort cells with hyphen #####-###-#### bagman Excel Discussion (Misc queries) 6 January 1st 05 07:05 PM
sort cells with hyphen #####-###-#### infurtaris Excel Discussion (Misc queries) 0 January 1st 05 05:15 PM


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