How to change default row height

R

rmt131

Hello,

I thought I'd share a cludge-fix I found for one of Excel's mor
annoying non-features: inability to set a default row height and stil
allow the occasional row that requires more space (i.e., one of it'
cells has multiple lines of wrapped text) to AutoFit if necessary.

Say you have the data shown in NormalSettings.png in an Excel file (se
attachments) and you want to have a little more room between the shorte
rows, but not have them all set as big as the expanded rows. One way t
do this in bulk is to select the entire spreadsheet and set a fixed ro
height, but this chops off any cells that require more space than you
default height (see FixedRowHeight20.png). The only way to fix this i
to manually scan through your sheet and individually select all row
with cells that need more room than your preferred row height an
AutoFit them (good luck if your spreadsheet is any size...) . If yo
try selecting the entire sheet and choose Format-Row-Autofit, you'r
back to the crowded display shown in 'NormalSettings.png'.

My workaround to this annoying problem is this: choose a column tha
you're not using (I just select the very last column in the sheet b
holding down CTRL and pressing the right arrow until the screen stop
moving) and highlight the entire column by selecting the column header
Then increase the font size for that column...voila, even your blan
rows will now AutoFit to the new font size rather than the font siz
you are using for your data...effectively increasing your default ro
height without sacrificing AutoFit capabilities. I find that using 1
as a dummy font size makes my data (which is font size 10, Arial) loo
nicely spaced out, but experiment and try stuff until you find what yo
like!

Hope this is helpful to someone out there...:)

regards,
rmt13

+-------------------------------------------------------------------
|Filename: Corrected.png
|Download: http://www.excelforum.com/attachment.php?postid=5232
+-------------------------------------------------------------------
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top