Format cell for consecuritve numbers

  • Thread starter Thread starter Monique Linder
  • Start date Start date
M

Monique Linder

How do I format cells so that when I click and drag a cell with the
figure "1".. then consecutive numbers appear (as oppose to lots of 1s)
 
press the 'Control' button when you drag and it will increment it.

HTH,
katherine
 
Hold the Ctrl key as you drag the fill handle.

Monique said:
How do I format cells so that when I click and drag a cell with the
figure "1".. then consecutive numbers appear (as oppose to lots of 1s)
Click to expand...
 
It works on the new spread shhet I created but not on my colleagues
pre-established sheet... could this be a formatting thing?
 
Any chance that 1 in the existing workbook was formatted as Text?

Try formatting it as general, retype the 1 and then ctrl-drag.

(I like to rightclick and drag--I get a bunch of options that I can choose
from--including "fill series". And it means I don't have to remember another
shortcut--but I'm old.)
 
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

Countif Problem 4
Excel Conditional Formatting 1
Continuous Invoice Nos. 3
COPYING CONDITIONAL FORMATTING WHEN COPYING CELLS OVER 2
Numbers showing Up Centered in Cell ? 1
Data Bars are the wrong length for data in cell 2
How do I copy text formatting using a formula? 2
Changing Text To Numbers ? 1

Back
Top