Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Numbered Lists!
This is probably easy to do but Im really new to this stuff!
Is it possible for Excel to make a numbered list without me having to type every number? i.e. 1 2 3 4 5 and so on€¦ Each number in the cell below! I may need to type 1 to 6000 and I dont fancy blisters on my fingers€¦hee hee! ;0) Thanks in advance Guys! |
#2
|
|||
|
|||
There a couple of ways to do this.
If you don't have too many numbers you want to list, you can enter a 1 in a cell. Notice that this cell, when selected, has a little square block in the bottom right corner of the cell. Hold the Ctrl key down and put the mouse cursor on that little block, hold the left mouse button down, and drag that cell as far down as you want. If you have a lot of numbers to list, do this. Enter a 1 in a cell. With that cell selected, click on Edit - Fill. Select Series. In the "Series in:" area, select Columns. In the "Type", select Linear. For "Step value:", put 1. For "Stop value:", put your ending number, say 6000. Click OK. Done. HTH Otto "Neil" wrote in message ... This is probably easy to do but I'm really new to this stuff! Is it possible for Excel to make a numbered list without me having to type every number? i.e. 1 2 3 4 5 and so on. Each number in the cell below! I may need to type 1 to 6000 and I don't fancy blisters on my fingers.hee hee! ;0) Thanks in advance Guys! |
#3
|
|||
|
|||
One way, put 1 in A1, press enter, select A1 again, type A1:A6000 in the
name box above A1 and press enter, do editfillseries and press enter -- Regards, Peo Sjoblom "Neil" wrote in message ... This is probably easy to do but I'm really new to this stuff! Is it possible for Excel to make a numbered list without me having to type every number? i.e. 1 2 3 4 5 and so on. Each number in the cell below! I may need to type 1 to 6000 and I don't fancy blisters on my fingers.hee hee! ;0) Thanks in advance Guys! |
#4
|
|||
|
|||
Type in the first few numbers in adjacent cells. Highlight those cells and
place your cursor at bottom right corner. Cursor changes from fat cross to thin cross. Click and hold down left mouse button and drag cursor in same direction to desired cell further down . Jock W "Neil" wrote: This is probably easy to do but Im really new to this stuff! Is it possible for Excel to make a numbered list without me having to type every number? i.e. 1 2 3 4 5 and so on€¦ Each number in the cell below! I may need to type 1 to 6000 and I dont fancy blisters on my fingers€¦hee hee! ;0) Thanks in advance Guys! |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Dropdown lists | Excel Discussion (Misc queries) | |||
Comparing 2 Customer Lists to Identify Shared Customers | Excel Worksheet Functions | |||
Why does my excel have numbered columns and rows | Excel Discussion (Misc queries) | |||
Data Validation Lists | Links and Linking in Excel | |||
How to delete duplicate records when I merge two lists (deleting . | Excel Worksheet Functions |