Copying Formats with Copy and Paste

A

apmeehan

Dear All,

is there any possible way to copy over the format of one cell onto
another without a simple copy and paste?

Example: in cell B2 I type in the formula '=A2*100'. That's easy
enough. But, what happens if cell A2 is in red bold numbers with a
left-side border, and I want to get that format over also into B2? But
- without copying and pasting???

Regards,

andym
 
D

Dave Peterson

Formulas only return values (with minor exceptions). I don't know a way of
getting the formats to copy except to copy|paste special|formats (or apply the
formatting itself).
 
M

Michael Raphael

I think if you do use the copy/paste special function you have several options that you can select from.
I actually had a situation where I used it to only copy the cell value because the cells had formulas based on other cells and when I copied them to a new area the referenced cell was wrong. Just copying the value worked great.

Mike
Formulas only return values (with minor exceptions). I don't know a way of
getting the formats to copy except to copy|paste special|formats (or apply the
formatting itself).
 
Top