| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Successive numbers
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? |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Successive numbers
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! -- ~Anne Troy www.OfficeArticles.com "Erin" wrote: 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? |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Successive numbers
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. "Erin" wrote: 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? |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Successive numbers
="Sheet "&ROW(A1)&" of 24"
-- David Biddulph "Erin" wrote in message ... 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? |
|
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Successive numbers
Erin
In A1 enter this and drag down to A24 ="Sheet " & ROW() & " of 24" Gord Dibben MS Excel MVP On Thu, 15 Mar 2007 13:25:28 -0700, Erin wrote: 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? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Pasting in successive cells | Excel Discussion (Misc queries) | |||
| I am not able to extend formulas to successive rows | Excel Worksheet Functions | |||
| formula to apply concatenation to successive rows of data | Excel Worksheet Functions | |||
| Recalc needed for successive years | Excel Discussion (Misc queries) | |||
| Is there a limit to number of successive IF-THEN statements? | Excel Discussion (Misc queries) | |||
Hybrid Mode
