how to reference/copy cell format ???

L

life.learning

Given A1 has some value plus formatting (color, bold, etc). How do I
set A2 (for example) to equal to A1, including all of the formatting of
A1? Is this even possible?

Appreciate any help.
 
D

Dave Peterson

It's not possible using formulas.

Given A1 has some value plus formatting (color, bold, etc). How do I
set A2 (for example) to equal to A1, including all of the formatting of
A1? Is this even possible?

Appreciate any help.
Click to expand...
 
G

Gary''s Student

1. select cell A2 and enter:
=A1

2. select cell A1 and pull-down:
Edit > Copy

3. select cell A2 and pull-down:
Edit > Paste Special and check format
 
L

life.learning

I'm looking for more of an automated way. I'm aware of the paste
special but it won't work for what I'm trying to accomplish.
Appreciate the suggestion.
 
Top