Rocky 8.x LibreOffice Calc Rows auto-number

Home > Rocky Linux or CentOS > Rocky Linux 8.x > Desktop tools or applications > LibreOffice Calc > Rows auto-number

In case of rows requiring numbering such as Serial No with values 1,2,3,4, etc. instead of typing the numeric value if we use formula

=Row(A2)-1

For second row, 1st column to have number 1. Then if we copy this formula to other rows, they will automatically have correct serial no.

Refer:

• https://support.microsoft.com/en-us/office/automatically-number-rows-76ce49e3-d8d2-459b-bd85-ee1d3973e6e6

Home > Rocky Linux or CentOS > Rocky Linux 8.x > Desktop tools or applications > LibreOffice Calc > Rows auto-number