> ## Knowledge Base Index
> Fetch the complete knowledge base index at: https://help.datachamp.io/sitemap.xml
> Use this file to discover available pages before exploring further.
> Pure-Markdown content can be obtained by appending a '.md' suffix to the content URLs listed in the sitemap (without the trailing slash).

# Can I Add Consecutive Row Numbers in Excel?

Yes you can!

1. Add a custom column
2. Give it a name e.g. consecutive numbering
3. Insert the value: `=ROW()-1` 
![](https://storage.crisp.chat/users/helpdesk/website/-/d/0/0/f/d00f55635133d800/add-custom-c_711c7e.png)
4. Set "Lines" in "Export Mode" to "Fill"
![](https://storage.crisp.chat/users/helpdesk/website/-/d/0/0/f/d00f55635133d800/export-mode-fill_boreb9.png)
5. The "File Type" must be "Excel"
![](https://storage.crisp.chat/users/helpdesk/website/-/d/0/0/f/d00f55635133d800/file-type-excel_obpamp.png)

If the calculated value of the Excel formula is not displayed in the Preview:
1. Click “Save”
2. Then click “Run”
3. Download the report

In the downloaded Excel file, the formula results will be displayed correctly

![](https://storage.crisp.chat/users/helpdesk/website/-/d/0/0/f/d00f55635133d800/scr-20260203-isrq_ozwh59.png)