Home |
Search |
Today's Posts |
#1
|
|||
|
|||
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 |
#2
|
|||
|
|||
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 |
#3
|
|||
|
|||
Anne Troy wrote:
You might just want to learn how to use the Format Painter. http://www.officearticles.com/misc/f...crosoft_office. htm ******************* ~Anne Troy _________________________________________________ Thank you, Anne. It doesn't work on Office 97 here at home, but I'll try it on Office 2000 when I get to work. On Office 97, Format Painter copies the font format ok, but not the row height. -- BT |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Macros for copying and pasting | Excel Discussion (Misc queries) | |||
Copying and Pasting between Workbooks | Excel Worksheet Functions | |||
Copying and Pasting between Workbooks | Excel Worksheet Functions | |||
Trouble copying and pasting a formula | Excel Discussion (Misc queries) | |||
Trouble copying and pasting a formula | Excel Worksheet Functions |