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

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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....
 
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...
 
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
 
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.
 
Back
Top