Auto fill keeps adding 1 digit or 1 cell

  • Thread starter Thread starter Ricardo
  • Start date Start date
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?
 
Hi

Try draggin with the right mouse button. When you get to the end of your
range you get a list of fill options.
 
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
 
You must log in or register to reply here.

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

Auto Fill Format or Copying Formulas 1
Want to turnoff the Auto Fill Option 2
Autofiller Tool Help 3
Auto fill values with a blank row formatting between entries 7
Duplicate "Drag" feature 2
some excel fomulas don't update, even if I hit F9, auto calc = on 2
Auto Fill Cell Based on Data in a different cell 4
Why does blank cell assume value = 1? 2

Back
Top