ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Change height of row (https://www.excelbanter.com/excel-discussion-misc-queries/2996-change-height-row.html)

Pam MacT

Change height of row
 
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.

Frank Kabel

Hi
i think the limit is 1 pixel

--
Regards
Frank Kabel
Frankfurt, Germany
"Pam MacT" <Pam schrieb im Newsbeitrag
...
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.




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.

--
Earl Kiosterud
mvpearl omitthisword at verizon period net
-------------------------------------------

"Pam MacT" <Pam wrote in message
...
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.





All times are GMT +1. The time now is 02:21 AM.

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