Add row numbers and skip blanks
exceljet.net
Add row numbers and skip blanks
To add sequential row numbers to a list of data, skipping cells that are blank, you can use a formula based on COUNTA, ISBLANK, and IF. In the example shown, the formula in B5 is: =IF(ISBLANK(C5),"",COUNTA($C$5:C5)) As the formula is copied down the column, rows where there is a value are numbered and empty rows are skipped.
Oct 26, 2022
Excel Tips and Tricks
Top 20 Microsoft Excel Tips & Tricks
25:38
Top 20 Microsoft Excel Tips & Tricks
YouTubeKevin Stratvert
871.2K viewsOct 23, 2020
30 Essential Excel Tips and Tricks for 2024 - Excel Productivity Tutorial
2:07:11
30 Essential Excel Tips and Tricks for 2024 - Excel Productivity Tutorial
YouTubeSimon Sez IT
100.1K viewsJan 9, 2024
50 Ultimate Excel Tips and Tricks for 2020
50:17
50 Ultimate Excel Tips and Tricks for 2020
YouTubeSele Training
1.9M viewsMar 17, 2020
Top videos
Insert or delete rows and columns
0:43
Insert or delete rows and columns
Microsoft
Oct 28, 2014
How to Insert a Row in Excel Using Keyboard Shortcuts Quick & Easy Guide#excel #viral #exceltricks
0:17
How to Insert a Row in Excel Using Keyboard Shortcuts Quick & Easy Guide#excel #viral #exceltricks
YouTubeOffice Master Classroom
1.5K views2 weeks ago
Robert Barone on Instagram: "Insert Rows/Columns in Excel for the Web - Excel Tips and Tricks Learn how to insert row and columns in Excel for web. Insert Rows/Columns in Excel for the Web,How do you insert a row in Excel for Web?,How do I insert multiple rows in Excel Web?,How do you insert a row below in Excel Web?,How do I insert rows and columns in Excel?, Check out my complete suite of Microsoft Excel Tips and Tricks. https://www.youtube.com/@RabiGurungXybernetics/shorts https://www.tiktok.
0:45
Robert Barone on Instagram: "Insert Rows/Columns in Excel for the Web - Excel Tips and Tricks Learn how to insert row and columns in Excel for web. Insert Rows/Columns in Excel for the Web,How do you insert a row in Excel for Web?,How do I insert multiple rows in Excel Web?,How do you insert a row below in Excel Web?,How do I insert rows and columns in Excel?, Check out my complete suite of Microsoft Excel Tips and Tricks. https://www.youtube.com/@RabiGurungXybernetics/shorts https://www.tiktok.
Instagrambobbybb247
1.9K views2 weeks ago
Excel Formulas Tutorial
Excel Formulas and Functions Tutorial
12:29
Excel Formulas and Functions Tutorial
YouTubeKevin Stratvert
4M viewsJul 13, 2019
Excel Formulas Tutorial for Beginners - Learn How to Use Basic Formulas & Functions Microsoft Excel
9:51
Excel Formulas Tutorial for Beginners - Learn How to Use Basic Formulas & Functions Microsoft Excel
YouTubeSubjectmoney
12.4K viewsDec 30, 2012
TOP 25 Basic Excel Formulas for Beginners (2025) | Step-by-Step Excel Guide
19:39
TOP 25 Basic Excel Formulas for Beginners (2025) | Step-by-Step Excel Guide
YouTubeSheetSkill
11K views5 months ago
Insert or delete rows and columns
0:43
Insert or delete rows and columns
Oct 28, 2014
Microsoft
How to Insert a Row in Excel Using Keyboard Shortcuts Quick & Easy Guide#excel #viral #exceltricks
0:17
How to Insert a Row in Excel Using Keyboard Shortcuts Quick & Eas…
1.5K views2 weeks ago
YouTubeOffice Master Classroom
Robert Barone on Instagram: "Insert Rows/Columns in Excel for the Web - Excel Tips and Tricks Learn how to insert row and columns in Excel for web. Insert Rows/Columns in Excel for the Web,How do you insert a row in Excel for Web?,How do I insert multiple rows in Excel Web?,How do you insert a row below in Excel Web?,How do I insert rows and columns in Excel?, Check out my complete suite of Microsoft Excel Tips and Tricks. https://www.youtube.com/@RabiGurungXybernetics/shorts https://www.tiktok.
0:45
Robert Barone on Instagram: "Insert Rows/Columns in Excel for the We…
1.9K views2 weeks ago
Instagrambobbybb247
Quickly Insert Multiple Rows in Excel
Quickly Insert Multiple Rows in Excel
418.2K viewsJul 12, 2010
YouTubeContextures Inc.
Microsoft Word - Adding Line Numbers
4:15
Microsoft Word - Adding Line Numbers
220K viewsDec 8, 2015
YouTubeSandor Rethy
Google Sheets - Insert Columns, Rows & Cells
2:28
Google Sheets - Insert Columns, Rows & Cells
45.9K viewsJul 9, 2019
YouTubeDigital Egghead
Numbering Rows in a Word Table
1:33
Numbering Rows in a Word Table
40.2K viewsMay 8, 2016
YouTubeMise En Place - Business & Professional Organ…
2:41
How to Add Numbers in Excel (Basic way)
406.9K viewsMay 15, 2019
YouTubeExcel Tutorials by EasyClick Academy
5:22
Excel: Insert Row at Sum Formula
13.3K viewsNov 9, 2014
YouTubeExcel Plus
2:38
How to Insert Row in Excel
682.7K viewsJul 1, 2019
YouTubeExcel Tutorials by EasyClick Academy
5:33
Insert Rows in Excel using VBA
17.1K viewsDec 2, 2018
YouTubeChat-Chuckles
0:40
Add numbers in Excel - Quick tutorial
5K viewsJan 2, 2021
YouTubeQuickerBits
5:57
Insert Multiple ROWS based on cell value (Advance - Part 2) - 2 Simpl…
6.6K viewsJun 21, 2021
YouTubeEXCEL PATHSHALA
0:31
Excel Number Rows Automatically (2020) - 1 MINUTE
9.6K viewsNov 26, 2020
YouTubeLeon Renner
4:55
How To Insert A Blank Row At Each Change In A Column In Excel
78.2K viewsNov 6, 2017
YouTubeExcel Bytes
1:56
How to Move Rows in Excel (The Easiest Way)
579.9K viewsJan 28, 2020
YouTubeExcel Tutorials by EasyClick Academy
1:04
How to automatically number rows in Microsoft Excel
2M viewsMar 11, 2021
YouTubeMicrosoft 365
2:04
How To Insert Space Between Each Row In Excel
81K viewsNov 23, 2020
YouTubeTech Library TV
5:24
Create a Table and Add Rows and Columns in Powerpoint
90.2K viewsApr 30, 2020
YouTubeLearn Point Tutorials
4:00
Excel 2016 - Add Rows and Columns - How to Insert a Row & …
327.7K viewsAug 6, 2019
YouTubeProfessor Adam Morgan
4:49
Insert Calculations and Formulas into Word | Microsoft Word Tutorials
238.6K viewsDec 10, 2020
YouTubeLisa Doe
0:32
How to Number Rows Using the Row Function in Excel
5.2K viewsJun 18, 2020
YouTubeBSuite365
2:33
Inserting A New Column Or Row In Excel 2010
1.5M viewsJul 5, 2011
YouTubeHelpDeskTV
17:53
Google Sheets - Row Number - Automatic Line Number Formula
81K viewsJun 8, 2020
YouTubeLearn Google Sheets & Excel Spreadsheets
1:57
Insert Multiple Rows in Between Every Row in Excel
19.2K viewsJun 21, 2020
YouTubeThe Akshay
1:39
How to Increment Row Numbers Using Formula in Microsoft Excel
20.7K viewsJun 9, 2018
YouTubeTech Howdy
1:00
Excel Quick Tip: Add a New Row with a Shortcut
71.2K viewsApr 3, 2018
YouTubeLearnFree
0:54
How to insert or delete rows and columns in Microsoft Excel
474.2K viewsFeb 25, 2021
YouTubeMicrosoft 365
1:53
How to Add Rows in Apple Numbers
24.4K viewsNov 25, 2020
YouTubeTech Talk
See more videos
Static thumbnail place holder