| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Column hidden and Auto filter
Hide columns data will follow the unhide filter or new order
hth -- regards from Brazil Thanks in advance for your feedback. Marcelo "David" escreveu: 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 |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Column hidden and Auto filter
Thanks! Good luck! David "Marcelo" wrote: Hide columns data will follow the unhide filter or new order hth -- regards from Brazil Thanks in advance for your feedback. Marcelo "David" escreveu: 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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How can I auto refresh a column that has an auto filter in place | Excel Discussion (Misc queries) | |||
| Hidden Rows with Auto-Filter | Excel Worksheet Functions | |||
| Re-running an AutoFilter filter when applied to a hidden column .. | Excel Worksheet Functions | |||
| Column Auto Width and Hidden Rows | Excel Discussion (Misc queries) | |||
| How do I use auto filter on only 1 column in a spreadsheet? | Excel Worksheet Functions | |||
Hybrid Mode
