I am creating a spreadsheet with student phone numbers. Some
households have more than 1 student, so I want to Autofill the phone
numbers. However, Excel adds one to each number as I drag down. For
example, if John Smith's phone number is 555-0000, his brother Ted's
number becomes 555-0001, and sister Susie is 555-0002.

I tried turning the cells to text format, but it still has this
problem.

Any way of disabling this feature in specific columns? Holding CTRL
everytime is pretty annoying.

Press and hold down the Control Key while you do what you do

"Cytorak" wrote:

I am creating a spreadsheet with student phone numbers. Some
households have more than 1 student, so I want to Autofill the phone
numbers. However, Excel adds one to each number as I drag down. For
example, if John Smith's phone number is 555-0000, his brother Ted's
number becomes 555-0001, and sister Susie is 555-0002.

I tried turning the cells to text format, but it still has this
problem.

Any way of disabling this feature in specific columns? Holding CTRL
everytime is pretty annoying.

Right-click and drag.

Release and "Copy Cells"


Gord Dibben MS Excel MVP

On Wed, 24 Sep 2008 08:19:10 -0700 (PDT), Cytorak
wrote:

I am creating a spreadsheet with student phone numbers. Some
households have more than 1 student, so I want to Autofill the phone
numbers. However, Excel adds one to each number as I drag down. For
example, if John Smith's phone number is 555-0000, his brother Ted's
number becomes 555-0001, and sister Susie is 555-0002.

I tried turning the cells to text format, but it still has this
problem.

Any way of disabling this feature in specific columns? Holding CTRL
everytime is pretty annoying.