| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
format to to automatically get page of consecutive numers 1 2 3
|
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
format to to automatically get page of consecutive numers 1 2 3
Hi
Not sure exactly what you are after, but if you type in cell A1 =ROW() and copy down as far as you wish, you will get 1, 2, 3 etc. -- Regards Roger Govier "gineen" wrote in message ... |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
format to to automatically get page of consecutive numers 1 2
Exactly what I was trying to remember. Thanks.
Just found that the same can be achieved just by putting 1 in cell A1, 2 in cell A2, selecting both cells and dragging the fill handle. Cheers "Roger Govier" wrote: Hi Not sure exactly what you are after, but if you type in cell A1 =ROW() and copy down as far as you wish, you will get 1, 2, 3 etc. -- Regards Roger Govier "gineen" wrote in message ... |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Copy page format into an entire workbook | Excel Worksheet Functions | |||
| How do you format a sheet to fill the entire page to print? | Excel Discussion (Misc queries) | |||
| In excel, can I format a cell to automatically take the curser to. | Excel Worksheet Functions | |||
| prevent 4/5 in a cell automatically transfer to a date format | Excel Discussion (Misc queries) | |||
| Protected cells -automatically format to a different color | Excel Discussion (Misc queries) | |||
Linear Mode
