ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Row width (https://www.excelbanter.com/excel-discussion-misc-queries/190871-row-width.html)

pgl

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.

David Biddulph[_2_]

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.




pgl

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.





Dave Peterson

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

pgl

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



All times are GMT +1. The time now is 07:16 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com