Click & drag Borders in Autofill

R

Rick_B

I've set up some pre-defined columns with vertical borders outlinin
major areas (say, every 5 columns wide).
When I use the fill-handle function to drag formulas across the widt
of the column, my border get's erased and changed to a different cel
format.

I know that I can click on the little pop-up square and correct th
change by selecting the "Fill without formatting" bullet. Doing thi
repeatedly is a bit of a hassle.

Is there any way to set that option to ALWAYS fill without formattin
when I pull a formula across a cell with borders?

--Ric
 
D

Dave Peterson

This is just a little shorter:

rightclick and drag.
when you let go, you'll see a list of options.
You can choose "fill formulas" (in xl2k)
(or "Fill without formatting" in xl2002)

(I thought it says "fill formulas" in xl2k--but I may be misremembering.)
 
Top