Increment a Number in Spreadsheet

How to increment a number in OpenOffice spreadsheet?


In Openoffice, if you want to increment the numbers in continuous cells, then you can do it as per the below given steps,
Step 1:
Enter the number in the cell.
Step 2: Click on a cell and drag the little black handle in the lower right corner. You can drag the handle to left, right, up or down.
Increment a Number in Spreadsheet
Step 3: When you drag the handle, the number will increment by 1.
increment number1

Related Topics