View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
David David is offline
external usenet poster
 
Posts: 1,560
Default Column hidden and Auto filter

Hi,

I would like to ask if I have hidden several column in my spreadsheet, and
use auto filter to sort the data with unhidden columns, will the contents in
the hidden column stick in the same row with the unhidden columns? Or they
will remain in the same position (cell) no matter how the other unhidden
columns are sort?(So the data on the same row before and after sorting will
not be the same)

Looking to your replies.

David