View Single Post
  #1   Report Post  
Bill Turner
 
Posts: n/a
Default Row height changes when copying and pasting

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