ExcelBanter - help with columns

ExcelBanter (https://www.excelbanter.com/)

- New Users to Excel (https://www.excelbanter.com/new-users-excel/)

- - help with columns (https://www.excelbanter.com/new-users-excel/243545-help-columns.html)

Mike

help with columns

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.

Gord Dibben

help with columns

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

On Wed, 23 Sep 2009 15:25:02 -0700, mike
wrote:

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.

All times are GMT +1. The time now is 08:32 AM.