PC Review


Reply
Thread Tools Rate Thread

Copy row/column- height/width and data

 
 
rekoop
Guest
Posts: n/a
 
      2nd Mar 2004
Hello,
Is there a way to copy and paste a row(s), or column(s)
from one workbook to another and retain column and width
setting in the new workbook?
I have used the Move/Copy worksheet but this only allows
for a worksheet to be moved/copied, I am hoping for the
same result using only specified column or widths.

Any suggestions appreciated.
 
Reply With Quote
 
 
 
 
Frank Kabel
Guest
Posts: n/a
 
      2nd Mar 2004
Hi
one way:
- click onf the column header (or the row number) to select the entire
column (row)
- Hit CTRL+C to copy the contents
- goto the target worksheet and select the target column (row)
- insert the contents (e.g. with CTRL+V)


--
Regards
Frank Kabel
Frankfurt, Germany

rekoop wrote:
> Hello,
> Is there a way to copy and paste a row(s), or column(s)
> from one workbook to another and retain column and width
> setting in the new workbook?
> I have used the Move/Copy worksheet but this only allows
> for a worksheet to be moved/copied, I am hoping for the
> same result using only specified column or widths.
>
> Any suggestions appreciated.


 
Reply With Quote
 
 
 
Reply

Thread Tools
Rate This Thread
Rate This Thread:

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

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are Off


Similar Threads
Thread Thread Starter Forum Replies Last Post
Create Sheets from a Range and Copy Data on copy Data on newlycreated Sheets with the Sheet Names prkhan56 Microsoft Excel Programming 2 7th Feb 2012 04:52 PM
Copy local users and groups, copy shares with security, copy homeuser folders usenet@sphere10.com Microsoft Windows 2000 Active Directory 1 17th Feb 2009 02:31 PM
Copy local users and groups, copy shares with security, copy homeuser folders usenet@sphere10.com Windows Vista General Discussion 2 17th Feb 2009 02:31 PM
Data Entry Online, Data Format, Data Conversion and Data EntryServices through Data Entry Outsourcing admin.dataentryoutsourcing@gmail.com Microsoft Excel Misc 0 20th Mar 2008 01:45 PM
Data Entry Online, Data Format, Data Conversion and Data EntryServices through Data Entry Outsourcing admin.dataentryoutsourcing@gmail.com Microsoft Access Form Coding 0 20th Mar 2008 01:44 PM


Features
 

Advertising
 

Newsgroups
 


All times are GMT +1. The time now is 06:45 PM.