Template to automatically add row numbers to sortable tables. The row numbers will not be sorted when columns of data are sorted. A possible note to add above a table: {{noprint|'''''Row numbers''' are static. Other columns are sortable. This allows ranking of any column.''}}

These templates work together and make table formatting fast:

Some are used together here: List of U.S. states and territories by incarceration and correctional supervision rate

Usage with wikitable and sortable

mali niŋ

Place template before table where the automatic row numbers are required. Add class static-row-numbers to the table wikitext, as in the following example. It adds an unsorted column of row numbers.

With wikitable and sortable
Name Number Another Number
A 10 1000
B 50 800
C 100 150
D 20 700
E 70 350
{{Static row numbers}}
{| class="wikitable sortable static-row-numbers"
! Name !! Number !! Another Number
|-
| A || 10 || 1000
|-
| B || 50 || 800
|-
| C || 100 || 150
|-
| D || 20 || 700
|-
| E || 70 || 350
|}

Usage with sortable

mali niŋ
With sortable
Name Number Another Number
A 10 1000
B 50 800
C 100 150
D 20 700
E 70 350
{{Static row numbers}}
{| class="sortable static-row-numbers"
! Name !! Number !! Another Number
|-
| A || 10 || 1000
|-
| B || 50 || 800
|-
| C || 100 || 150
|-
| D || 20 || 700
|-
| E || 70 || 350
|}

Usage with no other classes

mali niŋ

While designed to provide a static row number for sortable tables, it can be used just to add an automatic row number to plain tables.

With no other classes
Name Number Another Number
A 10 1000
B 50 800
C 100 150
D 20 700
E 70 350
{{Static row numbers}}
{| class="static-row-numbers"
! Name !! Number !! Another Number
|-
| A || 10 || 1000
|-
| B || 50 || 800
|-
| C || 100 || 150
|-
| D || 20 || 700
|-
| E || 70 || 350
|}

Using static-row-header-text to add a "No." column header

mali niŋ

This adds a "No." as the row number column header. Add class=static-row-header-text to the top line of the table wikitext. It does not work with {{Static row numbers table}}.

With static-row-header-text to add a column header
Name Number Another Number
A 10 1000
B 50 800
C 100 150
D 20 700
E 70 350
{{Static row numbers}}
{| class="wikitable sortable static-row-numbers static-row-header-text"
! Name !! Number !! Another Number
|-
| A || 10 || 1000
|-
| B || 50 || 800
|-
| C || 100 || 150
|-
| D || 20 || 700
|-
| E || 70 || 350
|}

Using static-row-header-hash to add a hash ("#") column header

mali niŋ

This adds a hash ("#") as the row number column header.

With static-row-header-hash to add a column header
Name Number Another Number
A 10 1000
B 50 800
C 100 150
D 20 700
E 70 350
{{Static row numbers}}
{| class="wikitable sortable static-row-numbers static-row-header-hash"
! Name !! Number !! Another Number
|-
| A || 10 || 1000
|-
| B || 50 || 800
|-
| C || 100 || 150
|-
| D || 20 || 700
|-
| E || 70 || 350
|}
mali niŋ

The class static-row-header is added to additional header rows (other than the first one). It prevents those header rows from having row numbers. It also prevents them from being sorted. It is important to add this class for consistent appearance in different Wikipedia skins and views. It is necessary for correct numbering in the minerva skin on mobile view which renders HTML tables differently.

Marking additional header and footer rows with static-row-header
Name Number Another Number
(unit) (per capita)
A 10 1000
B 50 800
C 100 150
D 20 700
E 70 350
Totals 250 3000
{{Static row numbers}}
{| class="wikitable sortable static-row-numbers"
! Name !! Number !! Another Number
|- class="static-row-header"
!  !! (unit) !! (per capita)
|-
| A || 10 || 1000
|-
| B || 50 || 800
|-
| C || 100 || 150
|-
| D || 20 || 700
|-
| E || 70 || 350
|- class="static-row-header"
! Totals !! 250 !! 3000
|}
mali niŋ

To prevent them from sorting class=sorttop or class=sortbottom must also be added. For an example of header rows like this see this version of the 2021 table in this list article.

Marking footer or header rows that also contain data cells (non-header cells)
Name Number Another Number
(unit) (per capita)
A 10 1000
B 50 800
C 100 150
D 20 700
E 70 350
Totals 250 3000
{{Static row numbers}}
{| class="wikitable sortable static-row-numbers"
! Name !! Number !! Another Number
|- class="static-row-header"
!  !! (unit) !! (per capita)
|-
| A || 10 || 1000
|-
| B || 50 || 800
|-
| C || 100 || 150
|-
| D || 20 || 700
|-
| E || 70 || 350
|- class="sortbottom static-row-header"
! Totals 
|| 250 || 3000
|}

This works whether or not there is a header cell in the "totals" row. The row will not sort. The row will not have a row number. The row can be placed on the top or bottom. Use sorttop or sortbottom

White background for data cells

mali niŋ

Add class=srn-white-background to the top line of the table wikitext. It can be used on tables with inline cell or row background colors. Neither are affected by this class.

This class is unnecessary if you are using this:

The class is incorporated into that template.

White background for data cells
1 2 3
1-1 2-1 3-1
1-2 2-2 3-2
{{Static row numbers}}
{| class="wikitable sortable static-row-numbers srn-white-background"
|-
! 1 !! 2 !! 3
|-
| 1-1 || 2-1 || 3-1
|-
| 1-2 || 2-2 || 3-2
|}

See also

mali niŋ