How to copy Formatting Attributes from Source Workbook when Linkin

[m_egle]

I am a fairly new Excel User. What I am trying to do is create a totally
separate Excel Workbook that includes the data already populated in an
existing Excel Workbook, but in the new Workbook I only want to include a few
selected columns from the Source Workbook, rather than the entire Source
Workbook.

What I have done so far is :

a) Right-Clicked on the Column Header in my Source Workbook of the first
Column that I wanted to include in my new Target Workbook, and selected the
"Copy" Option
b) Right-Clicked on the Column Header in my Target Workbook of the Column
where I want the replicated data to appear, and selected the "Paste Special"
option (selecting Paste ALL, Operation NONE), and selecting the "Paste Link"
option.
c) I then repeated this process for each additional column in my Source
Workbook that I want to appear in my new, Target Workbook.

This process worked GREAT, copying all of the data from the columns that I
wanted into my new Workbook, but what it didn't copy is the Formatting type
attributes (Boldness, Alignment, Cell Format, etc.) from the Source Workbook.

What I would like to know is whether there is anything I could do
differently, so that I would get not only the raw data, but also the same
formatting that it has in the Source Workbook when it is displayed in my
Target Workbook.

Thanks

m_egle

 

[Tom Hutchins]

What you could do differently is: after you use the right-click menu to paste
link your data, immediately right-click again (same spot) and Paste Special
selecting Formats.

Hope this helps,

Hutch

 

[m_egle]

Thanks Hutch. That did it !. I also had to right-click again and Paste
Special to select "Formulas and Number Formats" to change the zero-filled
blank cells, back to displaying as blanks.

I'm surpriset the selection of "All" didn't include both of these options.

Thanks for your help.

Mike

 

[m_egle]

Hey Hutch,

I guess I must have been lucky the first time I tried it, and had my cursor
in exactly the right place, because it worked perfectly the first time, but
now when I tried to repeat it, the second right-click gives me the same
"Paste Special" options (either "Paste" or "Paste link"), instead of that
screen which allowed me to select Format before.

I guess I'm missing the subtlety of (same spot), since when I right click to
select the Paste Special option, I have to move the pointer to select the
"Paste link", and then, each time I try right-clicking again, I don't get the
choices that helped me the first time.

Any ideas of what I'm doing wrong here ?

Thanks.

m_egle