Preserve column width & formatting when using copy/paste [Excel 2003]

Dynamo Nath

Board Regular
Joined
Aug 5, 2009
Messages
142
I have a master data sheet which I filter for specific manager names and then create new sheets with the exact same columns, formatting etc but with just that specific managers data on it; this is repeated a number of times depending upon how many names are entered into the user form.

Is there a way to ensure that the pasted information takes across column widths etc? At the moment I am applying formatting after the data has been pasted but was wondering if there was a neater way.

Thx in advance, Nathan.
 

Excel Facts

How to change case of text in Excel?
Use =UPPER() for upper case, =LOWER() for lower case, and =PROPER() for proper case. PROPER won't capitalize second c in Mccartney

Sandeep Warrier

Well-known Member
Joined
Oct 31, 2008
Messages
2,672
Hi,

Paste Special -> Column Widths will let you keep same column widths.

So you can paste twice, once the normal paste so that it can take formats and then PasteSpecial -> Column Widths.
 

Dynamo Nath

Board Regular
Joined
Aug 5, 2009
Messages
142
When I use pastespecial viacode to paste the column widths it also pastes over the exisiting data leaving blank cells, yet when I do this manually it doesn't. Am I missing something simple?
 
Master Excel Bundle

Excel contains over 450 functions, with more added every year. That’s a huge number, so where should you start? Right here with this bundle.

Forum statistics

Threads
1,163,495
Messages
5,832,024
Members
430,104
Latest member
briannnnleong

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top