| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
how to drag the cell to assign numbers by skipping one row each ti
Try this
in cell a1 key in 1, at A2 leave blank, at A3 key in2 select cells from A1 to A4 and then at the bottom right corner of the box, the cursor will turn to a cross. Drag down till you have the number of rows that you need. "Paran" wrote: 1 skip 2 skip 3 skip 4 and so on... |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| reference row on another sheet skipping zeros but not skipping li. | Excel Discussion (Misc queries) | |||
| how do i assign a range of numbers to a cell in excel | Excel Discussion (Misc queries) | |||
| assign numbers a value, then get percentage | Excel Worksheet Functions | |||
| Lookup numbers in sheet and assign it's cell reference | Excel Discussion (Misc queries) | |||
| how can i assign i set of numbers (1-16) without repeating them? | Excel Worksheet Functions | |||
Hybrid Mode
