Copy Across Formatting aswell using "=[Cell Ref]" ?

D

dim

Hi,
I'm using the old straightforward " = B5" to copy across text from B5 into
my new cell. No problems there, but I want whatever text formatting is in B5
to copy across aswell. Changing the format of my new cell is not an option
because it's locked for the user.
Any ideas?
Thanks....
 
D

Dave Peterson

Formulas return values--not formats like this.


Hi,
I'm using the old straightforward " = B5" to copy across text from B5 into
my new cell. No problems there, but I want whatever text formatting is in B5
to copy across aswell. Changing the format of my new cell is not an option
because it's locked for the user.
Any ideas?
Thanks....
Click to expand...
 
A

Andrew Taylor

You can copy just the format by copying the source cell and then
doing Edit/Paste Special/Formats on the target.

If the source format might change and you want the target always
to reflect it, you can use the Camera Tool, aka Paste Picture Link
See http://j-walk.com/ss/excel/odd/odd04.htm for details.

hth
Andrew
 
D

dim

Thanks Andrew,
That looks like it will work a treat. I guess I just learned another new
thing about MS Excel. :D Bye for now.
 
Top