View Single Post
  #2   Report Post  
Anne Troy
 
Posts: n/a
Default

You might just want to learn how to use the Format Painter.
http://www.officearticles.com/misc/f...oft_office.htm
*******************
~Anne Troy

www.OfficeArticles.com
www.MyExpertsOnline.com


"Bill Turner" wrote in message
...
I have several rows which are relatively large but which have a small
font in the cells. When I copy and paste to another area or another
worksheet, the row height decreases to fit the small font. How can I
keep the row height the same when copying and pasting? I've tried
several options in paste special but nothing works. I'm using Excel 97
at home and 2000 at work and they both do the same.

Thanks in advance,

--
BT