Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
DiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWord
DirectoryUser Groups
Related Topics
Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ...

MS Office Forum / Excel / New Users / November 2006

Tip: Looking for answers? Try searching our database.

Formatting

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
Steven - 29 Nov 2006 12:38 GMT
Can I copy and paste data in a way that the column width/row height is also
copied? If so, how?

Sincerely

Steven Shelton

           "Those who hammer their guns into plows will plow for those who
do not!" --Thomas Jefferson
Scott - 29 Nov 2006 15:57 GMT
You can paste the column width, but it is a separate task.

Paste Special -> Column Widths

I don't know how to do it for heights.

Scott

> Can I copy and paste data in a way that the column width/row height is also
> copied? If so, how?
[quoted text clipped - 5 lines]
>             "Those who hammer their guns into plows will plow for those who
> do not!" --Thomas Jefferson
Gord Dibben - 29 Nov 2006 17:10 GMT
For row heights, if you select the entire row the height will paste.

Individual cells.........no.

Gord Dibben  MS Excel MVP

>You can paste the column width, but it is a separate task.
>
[quoted text clipped - 13 lines]
>>             "Those who hammer their guns into plows will plow for those who
>> do not!" --Thomas Jefferson

Rate this thread:






 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2008 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.