Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
how can i fix a spreadsheet that didn't sort hidden columns?
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
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: |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Are Hidden Rows/ Columns Included in a Sort? | Excel Discussion (Misc queries) | |||
How do I sort or compare data from 2 different spreadsheet columns | New Users to Excel | |||
How to sort an Excel spreadsheet by more than 3 columns? | Excel Worksheet Functions | |||
only the first 5 columns of a 10 column excel spreadsheet sort | Excel Discussion (Misc queries) | |||
sort column data with hidden columns - excel 2003 | Excel Discussion (Misc queries) |