Prev: unique name list
Next: Select a formula / range from Excel drop down suggestions
From: Ryan on 12 Feb 2010 10:59
I have a large spread sheet and frequently use the auto filter capabilities.
My rows are getting out of sequence (the data is not staying in the correct
row). I've marked cells and then tested by sorting different columns
ascending, desending, etc. and I've done this on multiple columns. I can not
get the data to return to the original format even when I turn the filters
off. I have in excess of 100 hours invested in this data. Needless to say
it's a very important document! Any help will be greatly appreciated.
From: Pete_UK on 12 Feb 2010 11:32
If you want to get back to original order of the rows, then you can
put a simple sequence 1, 2, 3, 4 etc down a column before you start
changing anything in your sheet. Then you will always be able to sort
back to this sequence. Remember to include this column in the sort
range whenever you sort.

Hope this helps.

Pete

On Feb 12, 3:59 pm, Ryan(a)Wpl <Ryan(a)W...@discussions.microsoft.com>
wrote:
> I have a large spread sheet and frequently use the auto filter capabilities.  
> My rows are getting out of sequence (the data is not staying in the correct
> row).  I've marked cells and then tested by sorting different columns
> ascending, desending, etc. and I've done this on multiple columns.  I can not
> get the data to return to the original format even when I turn the filters
> off.  I have in excess of 100 hours invested in this data.  Needless to say
> it's a very important document!  Any help will be greatly appreciated.

 | 
Pages: 1
Prev: unique name list
Next: Select a formula / range from Excel drop down suggestions