[Solved] Making a Sequential List of Numbers in a Column

Discuss the spreadsheet application

[Solved] Making a Sequential List of Numbers in a Column

Postby Cacique » Wed Dec 19, 2007 6:37 pm

Hi everyone,

I'm not sure if I'm using the right terminology, but I what i'd like to do is to create a sequential list of numbers in a column, say from 1 to 100, or whatever, without having to type the numbers myself. I'd like the program to complete the list for me.

for example:

1
2
3
4
5
6
7
8
9
10
11
...
and so on....until
100


Is there a quick and easy way to do this? I couldn't find this in the menus or in the help. I'm using Windows XP with OO v.2.3.0

Thanks in advance.
Cacique
Last edited by Cacique on Sat Dec 22, 2007 6:07 pm, edited 1 time in total.
Cacique
 
Posts: 5
Joined: Wed Dec 19, 2007 6:22 pm

Re: Making a Sequential List of Numbers in a Column

Postby acknak » Wed Dec 19, 2007 8:32 pm

The simple method for a few cells:
1) Enter the first number ("1") in a cell, then click on that cell, so it has the black outline.
2) Click on the little black blob in the lower right corner of the outline, hold and drag down. You will see a tooltip appear with first "2", then "3"... counting up as you drag the outline to cover more cells.
3) Keep dragging downward until the number reads "100". Just drag off the window at the bottom, and Calc will scroll to follow the mouse. The tooltip numbers will keep counting up. When the number gets near 100, move the mouse back into the window and the scrolling will stop. Move the mouse up or down until the tooltip number reads exactly "100".
4) Release the mouse and Calc will fill in the numbers 1-100 for you.

An alternative method, easier for large number of cells:
1) Click on the cell where you entered "1".
2) Type Ctrl+Shift+Down (arrow); many cells are selected (black).
3) Menu: Edit > Fill > Series. The Start value should already be "1", enter "100" for the End value, then click "OK".
4) Type Ctrl+Up (arrow) twice to move the cursor back to the start of your numbers

You can use either of these techniques to fill cells with almost any series of numbers.
AOO4/LO5 • Linux • Fedora 23
User avatar
acknak
Moderator
 
Posts: 22756
Joined: Mon Oct 08, 2007 1:25 am
Location: USA:NJ:E3

Re: Making a Sequential List of Numbers in a Column

Postby Cacique » Fri Dec 21, 2007 9:05 pm

Hi,

Thanks a lot! I tried both methods and they both work a trick.

BTW, what is the right term for this kind of function? Because I couldn't find it in the help but I didn't really know what to search for either, lol.
Cacique
 
Posts: 5
Joined: Wed Dec 19, 2007 6:22 pm

Re: Making a Sequential List of Numbers in a Column

Postby acknak » Sat Dec 22, 2007 4:06 am

The Calc help refers to this as "Auto fill"; you can read about it in the help under "auto filling cells" in the Index tab.
AOO4/LO5 • Linux • Fedora 23
User avatar
acknak
Moderator
 
Posts: 22756
Joined: Mon Oct 08, 2007 1:25 am
Location: USA:NJ:E3


Return to Calc

Who is online

Users browsing this forum: No registered users and 19 guests