Rocky 8.x LibreOffice Calc Rows auto-number

From Notes_Wiki
Revision as of 07:50, 10 May 2023 by Saurabh (talk | contribs) (Created page with "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 <pre> =Row(A2)-1 </pre> For second row, 1st column to have number 1. Then if...")
(diff) ← Older revision | Latest revision (diff) | Newer revision → (diff)

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:


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

Retrieved from "http://www.sbarjatiya.com/notes_wiki/index.php?title=Rocky_8.x_LibreOffice_Calc_Rows_auto-number&oldid=7849"