Auto fill keeps adding 1 digit or 1 cell

R

Ricardo

When I try to drag a formula or value down or across the
spreadsheet in Excel 2002 (Win XP Professional)it
automatically adds 1 didgit to the value or references
the cell next door to calculate the formula. How can I
make the drag and autofill more accurate?
 
A

Andy B

Hi

Try draggin with the right mouse button. When you get to the end of your
range you get a list of fill options.
 
G

Gord Dibben

Ricardo

Check out the Help section on Absolute and Relative cell references.

Add dollar signs($) to change the references to what you want.

You can cycle through the choices if you highlight the references in the
formula bar and hit F4 to cycle.

Gord Dibben Excel MVP
 
Top