help with columns

M

mike

i need to know how to make a column of cells increase in number from 1 - what
ever so i dont have to keep going from cell dropdown to next cell and so on.
 
G

Gord Dibben

Enter 1 in A1

Right-click on the fill handle and drag down as far as you wish.

Release button and "Fill Series"


Gord Dibben MS Excel MVP
 

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

Excel Copy cells from one worksheet to another workseet - increment row & do again 0
Excel VBA 1
Excel Columns moving up and down on their own in a worksheet. What Goes? 2
Add a new row in Named Table (Table1) and add data from txtboxes into last empty cells based on header named of the Table1 0
Delete a formula but leave the data. 2
Microsoft Exel 2013 Conditional Formatting 0
finding column 2
Subtracting figures in a column 3

Top