Home |
Search |
Today's Posts |
#1
![]() |
|||
|
|||
![]()
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. |
#2
![]() |
|||
|
|||
![]()
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. |
#3
![]() |
|||
|
|||
![]()
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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
How do I change the thickness of a bottom boarder in Excel 2002? | Excel Discussion (Misc queries) | |||
How do I change row height to 16.0? I get choice of 15.6 (26 Pix. | Excel Discussion (Misc queries) | |||
Worksheet Row Change event | Excel Discussion (Misc queries) | |||
Time Stamp without change | Excel Discussion (Misc queries) | |||
Time Stamp-With Change | Excel Discussion (Misc queries) |