#1   Report Post  
Old January 4th 05, 09:01 PM
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.

  #2   Report Post  
Old January 4th 05, 09:09 PM
Frank Kabel
 
Posts: n/a
Default

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   Report Post  
Old January 5th 05, 01:54 AM
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 04: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 04:47 PM
Worksheet Row Change event crazybass2 Excel Discussion (Misc queries) 4 December 8th 04 05:29 PM
Time Stamp without change AntonyY Excel Discussion (Misc queries) 3 November 26th 04 09:13 AM
Time Stamp-With Change AntonyY Excel Discussion (Misc queries) 1 November 25th 04 11:38 PM


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

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

About Us

"It's about Microsoft Excel"

 

Copyright © 2017