Home |
Search |
Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Why is Excel amending formatting itself, when i sort a sheet?
I have a fairly large spreadsheet that i need to sort regularly. Lately,
Excel is changing the row & column formatting when i do this. I have version 2007, but it is saved as version 1997 - 2003 due to compatibility reasons. Can someone help resolve this issue please? |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Why is Excel amending formatting itself, when i sort a sheet?
I would need more information to be able to assist. When you say Row and
Column formatting are you referring to the Width/Height of a column/Row? If cells are merged (joined) you may experience some difficulties with this when sorting. Also it may be something with word wrapping. Can you tell me more about what kind of formatting is getting modifies and provide some sample data perhaps? Frank "Reddhed" wrote: I have a fairly large spreadsheet that i need to sort regularly. Lately, Excel is changing the row & column formatting when i do this. I have version 2007, but it is saved as version 1997 - 2003 due to compatibility reasons. Can someone help resolve this issue please? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Updating workbook with an alpha sort sheet and a numeric sort shee | Excel Discussion (Misc queries) | |||
Amending 1 work sheet saving in all | Excel Worksheet Functions | |||
Sort sheet based on particuilar sort order | Excel Worksheet Functions | |||
Amending standard Excel popups | Excel Worksheet Functions | |||
Excel Sort function should not sort the cell formatting! | Excel Worksheet Functions |