Autonumbering (not hidden cells) 2

[jimoblak]

If I want to autonumber a sequence of cells going down a column, all I need to do is drag the corner handle down the range of cells in that column.

If some of those rows are hidden, how do I autonumber only the visible cells? I do not want the autonumbering to fill the hidden cells.

 

[KenWright]

Assume you want to autonumber C1:C100 excluding hidden rows, in cell C1 put 1, and in cell C2 put 2, now select C3:C100 and do Edit / Go To / Special / Visible cells only.

Now type in =MAX($C$1:C2)+1 and hit CTRL+ENTER to enter it.

To hardwire them you just need to copy and paste special as values.

Assumes you have no numbers in the hidden cells in that range

Regards
Ken.......

----------------------------------------------------------------------------
It's easier to beg forgiveness than ask permission
----------------------------------------------------------------------------

 

[ilses]

Type the starting numbers in the first cells.
Select the range you want to fill.
Press Ctrl+G (GoTo).
Select special cells, Visible cells only.
Click Edit on the menu bar, point to Fill, and then click Series.

Ilses