Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.newusers
|
|||
|
|||
FormatRowAutofit
Hi
in Excel 2003, I have a 380row x 2col sheet, all text, no functions so far. Text was imported from Word, other Excels etc. Up to 10 lines of text in some cells, word-wrapped, many new-line (Alt + Enter) breaks. No merged cells. Problem is, FormatRowAutofit is unreliable. For 90% of cells works fine but some either show white space between text lines, or shrink too much, cutting off last text line(s). If adjusted manually, seems unstable - will revert for no reason. |
#2
Posted to microsoft.public.excel.newusers
|
|||
|
|||
FormatRowAutofit
Looks like you need to remove the formatting before you pasted into the new
spreadsheet. when youu paste - if you use paste special there should be an option to remove the fomatting so you just paste text. Anywhite space will have to be removed manually. -- Dave Eade EPCS Ltd www.EPCS.me.uk "fostertom" wrote: Hi in Excel 2003, I have a 380row x 2col sheet, all text, no functions so far. Text was imported from Word, other Excels etc. Up to 10 lines of text in some cells, word-wrapped, many new-line (Alt + Enter) breaks. No merged cells. Problem is, FormatRowAutofit is unreliable. For 90% of cells works fine but some either show white space between text lines, or shrink too much, cutting off last text line(s). If adjusted manually, seems unstable - will revert for no reason. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
FormatRowAutofit | Excel Discussion (Misc queries) | |||
format:column width: autofit selection | Setting up and Configuration of Excel | |||
FormatRowAutofit | Excel Discussion (Misc queries) | |||
can't format rows to autofit | Excel Discussion (Misc queries) | |||
format-row-autofit not working | Excel Worksheet Functions |