Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How do I number cells vertically in succession? Example: (1 2 3)
How do I number cells vertically in succession?
Example: 1 2 3 Thank you. |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How do I number cells vertically in succession? Example: (1 2 3)
One way ..
Enter the 1st number in the starting cell, eg enter in A2: 1. Then right-click on the fill handle of A2, drag it down as far as required. When you release, choose "Fill Series" from the pop up menu. -- Max Singapore http://savefile.com/projects/236895 xdemechanik --- "rsmith844" wrote: How do I number cells vertically in succession? Example: 1 2 3 Thank you. |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How do I number cells vertically in succession? Example: (1 2 3)
There are many way, put 1 in a cell, copy it down using the right button and
when you release the button select fill series. You can also us editfillseries, you can put 1 in the first cell and 2 in the second, grab both cells and copy down. You can put 1 in a cell, hold down ctrl and copy down -- Regards, Peo Sjoblom "rsmith844" wrote in message ... How do I number cells vertically in succession? Example: 1 2 3 Thank you. |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How do I number cells vertically in succession? Example: (1 2 3)
Another way - put the formula:
=ROW(A1) in your first cell and copy down. Hope this helps. Pete On Oct 2, 4:24 am, rsmith844 wrote: How do I number cells vertically in succession? Example: 1 2 3 Thank you. |
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How do I number cells vertically in succession? Example: (1 2 3)
to add another method to the mix...
1. Enter the first few cells (1,2,3) 2. Highlight the cells you filled. 3. Left Click and Drag the "square" at the bottom right of the selection as far down as you need. "rsmith844" wrote: How do I number cells vertically in succession? Example: 1 2 3 Thank you. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Merge vertically ? | Excel Discussion (Misc queries) | |||
How do I get Clipboard/Help to display vertically on the right? | Setting up and Configuration of Excel | |||
How do I link horizontal cells vertically? | Excel Discussion (Misc queries) | |||
How do I print vertically? (example A-T) | Excel Worksheet Functions | |||
Move cells vertically to horizontally | Excel Discussion (Misc queries) |