Change height of row

P

Pam MacT

Excel seems to limit the height of the row to some presets. Is there a way
to set height of row to any height? Am trying to make spreadsheet line up
with a pre-printed form.
 
E

Earl Kiosterud

Mac,

It does the row height in increments. You may have to get them all close,
then adjust a few rows here and there to one increment up or down to get the
total spread you need for the forms. You can adjust multiple rows to the
same height simultaneously by selecting them (use Ctrl or Shift as you click
in the row header at left), then manually adjusting any of the selected
ones. Some range names may speed the process a bit, for quick selection of
a set of rows. Zooming up makes it a little easier, though it doesn't
change the increment size. It goes to 400%. This may work. Or it may
drive you mad.
 
Top