A Microsoft Excel forum. ExcelBanter

If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.

Go Back   Home » ExcelBanter forum » Excel Newsgroups » Excel Discussion (Misc queries)
Site Map Home Register Authors List Search Today's Posts Mark Forums Read Web Partners

Row height changes when copying and pasting



 
 
Thread Tools Display Modes
  #1  
Old July 6th 05, 06:11 AM
Bill Turner
external usenet poster
 
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
Ads
  #2  
Old July 6th 05, 06:41 AM
Anne Troy
external usenet poster
 
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



  #3  
Old July 6th 05, 05:44 PM
Bill Turner
external usenet poster
 
Posts: n/a
Default

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
 




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
Macros for copying and pasting denny Excel Discussion (Misc queries) 4 July 8th 05 09:44 AM
Copying and Pasting between Workbooks NothingButRomance Excel Worksheet Functions 0 May 13th 05 09:54 PM
Copying and Pasting between Workbooks NothingButRomance Excel Worksheet Functions 0 May 13th 05 07:33 PM
Trouble copying and pasting a formula Julie P. Excel Discussion (Misc queries) 6 March 4th 05 05:11 AM
Trouble copying and pasting a formula Julie P. Excel Worksheet Functions 4 March 3rd 05 04:16 AM


All times are GMT +1. The time now is 05:19 AM.


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