| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Row width
I have a spreadsheet that is continually being updated and rearranged/sorted.
Everytime I do this the row widths change and I have to resize them. Is there a way to freeze a row width? Every row is not the same width -depending on the content. |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Row width
Rows have height; columns have width.
-- David Biddulph "pgl" wrote in message ... I have a spreadsheet that is continually being updated and rearranged/sorted. Everytime I do this the row widths change and I have to resize them. Is there a way to freeze a row width? Every row is not the same width -depending on the content. |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Row width
sorry, i meant heighth. i've been struggling with this for awhile - just had
a senior moment. "David Biddulph" wrote: Rows have height; columns have width. -- David Biddulph "pgl" wrote in message ... I have a spreadsheet that is continually being updated and rearranged/sorted. Everytime I do this the row widths change and I have to resize them. Is there a way to freeze a row width? Every row is not the same width -depending on the content. |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Row width
Can you just select all the cells (ctrl-a a few times), then autofit the
rowheight? pgl wrote: I have a spreadsheet that is continually being updated and rearranged/sorted. Everytime I do this the row widths change and I have to resize them. Is there a way to freeze a row width? Every row is not the same width -depending on the content. -- Dave Peterson |
|
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Row width
thanks, but my problem is that i would like the rows to be no 'shorter' than
25.5. some rows have 1 line of text, some have 15 lines. i hate seeing such a mishmash of different heights so i try to standardize the majority of them. i know you can select a standard column width for a worksheet but it's not set up for a standard row height (other than the default). "Dave Peterson" wrote: Can you just select all the cells (ctrl-a a few times), then autofit the rowheight? pgl wrote: I have a spreadsheet that is continually being updated and rearranged/sorted. Everytime I do this the row widths change and I have to resize them. Is there a way to freeze a row width? Every row is not the same width -depending on the content. -- Dave Peterson |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Concvert Full Width Katakana characters into Half Width Katakana C | Excel Discussion (Misc queries) | |||
| Row eight and row width | Excel Discussion (Misc queries) | |||
| Data-Validation-List-Width of list must be colomn width, is this possible | Excel Worksheet Functions | |||
| ASC() does not convert full-width to half-width letters (Exel 2003 | Excel Worksheet Functions | |||
| How to make cell width different than the column width it lies in | Excel Discussion (Misc queries) | |||
Linear Mode
