#1   Report Post  
Pam MacT
 
Posts: n/a
Default 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.
  #3   Report Post  
Earl Kiosterud
 
Posts: n/a
Default

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
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
How do I change the thickness of a bottom boarder in Excel 2002? Dawn Excel Discussion (Misc queries) 12 January 14th 05 05:50 PM
How do I change row height to 16.0? I get choice of 15.6 (26 Pix. jlloyd Excel Discussion (Misc queries) 4 December 9th 04 05:47 PM
Worksheet Row Change event crazybass2 Excel Discussion (Misc queries) 4 December 8th 04 06:29 PM
Time Stamp without change AntonyY Excel Discussion (Misc queries) 3 November 26th 04 10:13 AM
Time Stamp-With Change AntonyY Excel Discussion (Misc queries) 1 November 26th 04 12:38 AM


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

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"