| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Putting row numbers in cells
I want to set up a column in which the entry in each row is simply the
row number, possibly with a constant offset. Thank for any help. |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Putting row numbers in cells
=ROW()
or =ROW()+16 16 could be anything, of course -- Kind regards, Niek Otten Microsoft MVP - Excel wrote in message ups.com... |I want to set up a column in which the entry in each row is simply the | row number, possibly with a constant offset. | | Thank for any help. | |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Putting row numbers in cells
You can use a formula
=ROW() -- Regards Ron de Bruin http://www.rondebruin.nl wrote in message ups.com... I want to set up a column in which the entry in each row is simply the row number, possibly with a constant offset. Thank for any help. |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Putting row numbers in cells
Niek Otten wrote: =ROW() or =ROW()+16 16 could be anything, of course thank you both. -- Kind regards, Niek Otten Microsoft MVP - Excel wrote in message ups.com... |I want to set up a column in which the entry in each row is simply the | row number, possibly with a constant offset. | | Thank for any help. | |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| summing cells with text and numbers | Excel Worksheet Functions | |||
| Sorting - cells containing numbers, numbers and letters | Excel Discussion (Misc queries) | |||
| Sum multiple cells with different numbers and text. | Excel Discussion (Misc queries) | |||
| checking that cells have a value before the workbook will close | Excel Worksheet Functions | |||
| How to alter data on HTML webpage into Excell cells as numbers? | New Users to Excel | |||
Linear Mode
