Successive numbers

E

Erin

I have a cell that says "Sheet 1 of 24". The cell underneath that says
"Sheet 2 of 24" and so on. Does anyone know a formula that can be dragged
down that will update the next cell in succession for the rest of the sheets?
 
A

Anne Troy

Custom format using Format-->Cells, Choose Custom on the Number tab, then
type this into the box at right:
"Sheet" # "of 24"
Type in the first 3 (1,2,3), select them, and drag down.

Hope it helps!
 
J

JLatham

This involves a little math, but at a simple level.

Assuming your cell with "Sheet 1 of 24" is in it is in row one, no math
involved. Put this formula in its place:
="Sheet " & Row() & " of 24"
but if it starts further down the sheet, then you have to do a little math:
Row() returns the row number of what ever row it shows up in, so for row 1 it
returns 1, row 2; returns 2, etc. Lets say your entries start down at row 5,
then the formula becomes:
="Sheet " & Row()-4 & " of 24"
fiill down the sheet as far as makes sense.
 
G

Gord Dibben

Erin

In A1 enter this and drag down to A24

="Sheet " & ROW() & " of 24"


Gord Dibben MS Excel MVP
 
Top