How to fill down without changing the format?

[T Bennett]

Does anyone know how to fill a cell's formula/value down without changing
the format (color, font, etc.)?

--
_________________________________________
Todd Bennett
Mechanical Designer

Celerity Group, Inc.
9660 SW Herman Rd
Tualatin, OR 97062

Phone: 888-724-3221
E-mail: (e-mail address removed)

 

[MeAgain]

Just drag it down.

 

[T Bennett]

Very nice, thanks.

1. Point to the Fill Handle, and press the RIGHT mouse button.
2. Drag down, then release the button.
3. From the shortcut menu, choose Fill Without Formatting