how can i fix a spreadsheet that didn't sort hidden columns?
 

how can i fix a spreadsheet that didn't sort hidden columns?
 

If you already saved it, you will need to retrieve your backup copy and
try again. Otherwise CTRL-Z is Undo.

seanut0625 wrote:

how can i fix a spreadsheet that didn't sort hidden columns?
 

Hidden columns will sort along with the unhidden ones if the columns on either
side of the hidden one are selected or adjacent columns are selected.

Excel will pop up a message asking if you want to "expand the selection".

If you click "No" then you get what you asked for.

No much consolation, but make note for the future.


Gord Dibben MS Excel MVP

On Tue, 29 Jan 2008 13:16:03 -0800, seanut0625
wrote: