Rows in Excel Nederlands: Meaning and the RIJEN Function

Formulas & functions · Updated November 18, 2026

In Dutch, Excel rows are called rijen; the English Excel function ROWS is named RIJEN in Dutch-language Excel. It counts how many rows a cell reference covers, while ROW—Dutch RIJ—returns a row number. So, if you searched for “Rows Excel Nederlands,” the translation depends on whether you mean worksheet rows or the function.

What rows mean in an Excel worksheet

A row is a horizontal line of cells across a worksheet. Excel labels rows with numbers down the left edge: 1, 2, 3, and so on. Columns run vertically and are labelled with letters, such as A, B, and C. The location of a cell combines its column letter and row number: B4 is in column B, row 4.

Rows commonly hold one record each in a list or table. For example, a sales sheet might have headings in row 1—Date, Product, and Amount—and one sale on each following row. Keeping one record per row makes it easier to sort, filter, count, and analyse the data. It also helps Excel recognise a contiguous range as a table.

Modern Excel worksheets have 1,048,576 rows and 16,384 columns. That is the grid’s maximum capacity, not a recommendation to put all your data on one sheet. A workbook with very large ranges, complex formulas, or many formats can become slower to calculate and manage.

Row, column, RIJ, and RIJEN

The Dutch words distinguish the worksheet feature from the two related functions:

  • Row: rij, one horizontal worksheet line.
  • Rows: rijen, multiple horizontal lines.
  • ROW: RIJ in Dutch Excel; returns the row number of a reference.
  • ROWS: RIJEN in Dutch Excel; counts the rows in a reference.

These last two functions are easy to mix up. If a reference points to cell D7, ROW reports 7 because that cell is on worksheet row 7. By contrast, ROWS counts the height of a reference. A reference spanning D7:D12 covers six rows, so ROWS returns 6; it does not return the number of the final row.

How the ROWS or RIJEN function works

In English-language Excel for Microsoft 365 on Windows, the syntax is ROWS(array). The argument is a cell reference or range. The function returns the number of rows in that reference, regardless of whether the cells contain values, formulas, or nothing at all. In Dutch-language Excel, the function name is RIJEN. The one-argument examples below work without any separator between arguments.

For example, with the range A1:A5, =ROWS(A1:A5) returns 5. In Dutch-language Excel, enter =RIJEN(A1:A5); it also returns 5. The range has five rows even though it has only one column. With A1:C5, the result is still 5, because the function counts rows, not every cell in the range.

A useful distinction is that ROWS(A1:C5) returns 5, whereas the number of cells in that rectangular range is 15. If you need the total number of cells, multiply the row count by the column count. With A1:C5 as the range, =ROWS(A1:C5)*COLUMNS(A1:C5) returns 15. The Dutch function names are RIJEN and KOLOMMEN; for the same calculation, Dutch Excel uses =RIJEN(A1:C5)*KOLOMMEN(A1:C5).

Practical examples for counting rows

Counting the rows in a fixed range is useful when you want to check a data block or build a calculation that depends on its size. For instance, with monthly dates in A2:A13, =ROWS(A2:A13) returns 12. It counts all 12 positions, including any blank cells. In Dutch Excel, use =RIJEN(A2:A13) for the same result.

That behaviour matters when a range contains gaps. Suppose A2:A6 contains four dates and one blank. =ROWS(A2:A6) returns 5, not 4, because it counts the range’s rows rather than nonblank entries. To count nonblank cells instead, a different function is needed: in English Excel, COUNTA counts cells that are not empty. Choose the function based on the question: “How tall is this range?” calls for ROWS; “How many cells contain something?” calls for a nonblank count.

ROWS is also handy when a formula needs a count that updates as a referenced range changes. However, a reference such as A2:A100 continues to include 99 rows even if some are blank. For lists that grow over time, an Excel Table can make formulas easier to maintain: select the data, then use Insert > Table or press Ctrl+T on Windows. On Mac, the shortcut is Command+T. Table references can expand as rows are added, though the exact formula depends on the calculation you want.

Adding, selecting, and resizing worksheet rows

To select a whole row, click its number in the row heading at the left of the sheet. To select a block of adjacent rows, select the first row heading and drag through the others, or select the first, hold Shift, and select the last. On Windows, Ctrl-click can be used to add nonadjacent rows to a selection; on Mac, use Command-click. When selecting cells rather than row headings, these actions select cells, not necessarily entire rows.

To add a row, right-click a row heading and choose Insert. Excel inserts the new row above the selected row. You can also select a row and use Home > Insert > Insert Sheet Rows. The equivalent Dutch labels vary with the installed language, but the command is the worksheet-row insertion command. To remove a row, select its heading and choose Delete, rather than simply pressing the keyboard’s Delete key, which normally clears cell contents without removing the row itself.

Change a row’s height by dragging the boundary below its row number. Double-click that boundary to AutoFit the height to the cell contents. This is useful when wrapped text is hidden, but a manually fixed height can prevent all lines from showing. If text still appears cut off, check both the row height and whether Wrap Text is enabled for the cell.

Rows in tables, sorting, and filtering

In a well-structured data table, the first row often contains a single set of column headings, with each subsequent row holding one complete record. Avoid inserting blank rows between records: a blank line can make it harder for Excel to identify the full data range when sorting, filtering, or creating a PivotTable. Also avoid merged cells inside a dataset, since they interfere with many ordinary table operations.

To filter a range, click in the data and choose Data > Filter. Excel adds dropdown arrows to the header cells, allowing you to show only rows that meet conditions—for example, sales from one region or orders above a chosen value. Sorting rearranges records by a chosen column. Select a cell in the dataset before sorting and confirm that Excel has identified the full range; sorting just one column can separate values from the other fields in their records.

For a more durable list, turn the range into an Excel Table with Insert > Table and confirm whether the data has headers. Tables provide filter controls and generally expand when data is added directly below them. Keep the headings distinct and avoid using a completely blank header cell. These practices make row-based data easier to read and less prone to accidental mis-sorting.

Common misunderstandings and formula issues

The most frequent confusion is between ROW and ROWS. ROW(A10) returns 10, the worksheet row number; ROWS(A10:A15) returns 6, the number of rows in the reference. In Dutch Excel, these names appear as RIJ and RIJEN. Adding the final “S” changes the task the function performs.

Another common mistake is assuming that a row count means a count of populated records. It does not: ROWS counts the range’s dimensions, including empty cells. If a list has a heading in row 1 and records in rows 2 through 20, the range A1:A20 has 20 rows, while the data section beneath the heading has 19. Define the range carefully so the heading is included only when that is what you intend.

Function names and argument separators can depend on Excel’s language and regional settings. English-language examples commonly use English function names and commas when a function has multiple arguments. Dutch-language Excel uses localized names, and its list separator is often a semicolon, depending on regional settings. The examples here use one-argument ROWS/RIJEN formulas where possible to avoid that separator issue. If a formula copied from an English tutorial is rejected, check the function name and the separator expected by your installation rather than changing the range itself.

Excel in Dutch versus English

Changing Excel’s display language can change ribbon labels, function names shown while editing formulas, and help text. It does not change the underlying idea of a row or alter the data stored in the worksheet. A workbook made in one language can generally be opened in another, though a formula may be displayed with localized function names in the recipient’s Excel.

In Microsoft 365 for Windows, language preferences are managed through Office language settings; the exact options depend on the installed language pack and account configuration. Excel for Mac has its own language and regional settings, and interface details may differ. Excel for the web also reflects available account or browser language settings. Regardless of platform, the key translation remains: a worksheet row is a rij, plural rijen, and the localized function that counts rows is RIJEN.

If you are following instructions written in English while using Dutch Excel, translate function names where needed but keep the underlying reference intact. For example, the English function =ROWS(B2:B8) and Dutch =RIJEN(B2:B8) both count seven rows. The range starts on row 2 and ends on row 8, so the inclusive count is 8 − 2 + 1 = 7.

Frequently Asked Questions

What is rows in Excel called in Dutch?
A worksheet row is rij in Dutch, and rows in the plural are rijen. The Excel function named ROWS in English is called RIJEN in Dutch-language Excel.

What is the Dutch Excel formula for ROWS?
Use =RIJEN(A1:A5) to count the rows in A1:A5. It returns 5. If your Excel is set to English, the equivalent is =ROWS(A1:A5).

What is the difference between RIJ and RIJEN?
RIJ corresponds to ROW and returns a row number for a reference. RIJEN corresponds to ROWS and returns how many rows a reference covers. For example, a reference to A7 has row number 7, while A7:A9 spans 3 rows.

Does ROWS count blank rows?
Yes. ROWS counts the number of rows in the range, whether those cells are filled or blank. Use a suitable count function instead if you need to count nonblank entries.

Why does my Excel formula use semicolons instead of commas?
Excel’s argument separator depends on language and regional settings. Dutch installations commonly use semicolons in formulas with multiple arguments, while English examples often show commas. A one-argument formula such as RIJEN(A1:A5) has no argument separator to change.

How many rows can an Excel worksheet have?
A modern Excel worksheet has up to 1,048,576 rows. This is a worksheet limit; it does not mean a workbook will perform well if every row contains complex calculations or extensive formatting.

Related

Try it: the Formula Explainer: paste any formula and see each function and reference in plain English.

More in Formulas & functions

Sources: Function behaviour and menu paths: Microsoft Support documentation for Excel. Method & sources

Spotted an error in this guide? Let us know.