Thread: how can i fix a spreadsheet that didn't sort hidden columns?
View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.misc
Gord Dibben Gord Dibben is offline
external usenet poster
  
Posts: 22,906
Default 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:


Reply With QuoteReply With Quote