Hiding and sorting

  • Thread starter Thread starter David French
  • Start date Start date
D

David French

Apparently when rows or columns are hidden and a sort is performed on a list
in Excel that the hidden rows or columns end up visible again.
I have had this behavior shown to me and I really find that as odd.

Can anyone else confirm or deny this allegation?

Windows XP
Office XP

Dave French
 
I've only got XL97 but it does not act that way. Hidden columns sort with
the field they are associated with and do NOT re-appear just because of the
sort. Perhaps there is a change-event macro at play where you saw
this.........or maybe XP is different in that respect.

Vaya con Dios,
Chuck, CABGx3
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Mailing address block: sorting 1 row to columns 1
Expand and collapse rows 7
Sort partially hidden data 1
Hide Question 4
VBA filter and sorting 1
Cannot sort blanks to bottom of table 2
Hide Rows and Columns based on Date Input 6
Hide/unhide 4

Back
Top