How do I have calc create a sequence of numbers down a column in 1/8 inch increments? (Ex. 1/8, 1/4, 3/8, 1/2, 5/8, 3/4, 7/8, 1, 1 1/8...) [closed]

I am trying to create a table that counts up in 1/8 increments. I would like one value in each cell and just increase in 1/8 increments. Also I would prefer that it use 1/2 vs 4/8 on such values.

edit retag reopen merge delete

Closed for the following reason the question is answered, right answer was accepted by Alex Kemp close date 2016-03-05 19:03:56.649818

Sort by » oldest newest most voted

format cells using the fraction format

a1 = .125

a2 = a1 +.125

copy as needed to subsequent cells

more

An alternative to the simple and effective explanation of @ObrienDave is the usage of the "Fill" function in the edit menu.

• Write in two cell beneath (or aside of) each other 0.125 and 0.250
• Select these 2 cells
• Open: Edit > Fill > Series
• Fill the end values an click OK

Note: The "Series" function only becomes visible if you have selected 2 cells. I feel that this is a bug and hope someone with knowledge on this condition leaves a comment in respect to bug or not.

more

@ROSt52
I see no Sense in a "Series"-funktion with one cell as Target

( 2014-10-31 10:02:52 +0200 )edit

You don't have to use the Fill function. Just enter the first 2 cell, highlight them, click and hold on the little black square in the bottom right corner of the cell and pull with the mouse. It shows you the value in a little window.

( 2014-11-01 22:17:26 +0200 )edit

@horst - thanks for this hint. Have to keep in mind!

( 2014-11-03 10:56:41 +0200 )edit

Easy to create the table for the numbers is of the digital analogues and now to catalogues of the conditions and knowledge. It the page you want help to asking the questions like that in the college paper help with intension of the beneath and functions of the more explicit.

( 2018-07-17 08:48:55 +0200 )edit