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.
format cells using the fraction format
a1 = .125
a2 = a1 +.125
copy as needed to subsequent cells
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
- Now you see that Calc detects already your intention
- 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.
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.