How to fill down without changing the format?

T

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)
 
T

T Bennett

Very nice, thanks.



Debra Dalgleish said:
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
Click to expand...
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Fill down without formatting macro 7
how to change color gradients in a bar chart 0
How to fill in form with diff. color font. without word changing c 1
how to change to other format ? 2
Formating changing when files opened in PPT 03 3
how do I keep rows' formats when copying a formula? 4
Force recalcualte on cell format change 3
Fill and Font Color Drop Downs Mostly White with Random Colors 2

Top