Excel Guides

Counting Displayed Cells in Excel

To count the number of cells that contain data in an Excel worksheet, you can use the COUNT function. This function counts the number of cells that contain numbers, text, or errors. It does not count empty cells or cells that contain formulas that return empty text ("").

To count the number of cells that contain data in a range, you can use the COUNTA function. This function counts the number of cells that are not empty. It does not count empty cells or cells that contain formulas that return empty text ("").

Note: The COUNT and COUNTA functions will count cells containing text values such as "Yes" or "No". To exclude these types of values from the count, you can use the COUNTIF function with a criterion such as "<>". For more information, see Count cells by their color.

To count the total number of cells in a worksheet:

  1. Select any cell in the worksheet.

  2. On the Home tab, in the Editing group, click Find & Select (or press Ctrl+F3).

  3. Click Go To Special.

  4. In the Go To Special dialog box, click Current region.

  5. >Click OK.

  6. >The current region is now selected (highlighted). This is typically all of=the data on your worksheet plus any blank rows or columns surrounding it.
        }

  7. > On =the Home tab , in=20the Editing group , click Copy (or press Ctrl + C ). < li >< p =style=3D" margin :0 in ; padding - left : 30 . 45 pt ; " >< span =style=3D" font - size :11 pt ; " >< strong > Note : < / strong > If you want to copy only visible cells , be sure to remove any filters before copying . For more information about how to do this , see < a href =" https :// support . office . com / en - us / article / Filter - data - in - a - range - or - table " target =" _blank " rel =" noopener noreferrer " > Filter data in a range or table . < li >< p =style=3D" margin :0 in ; padding - left : 30 . 45 pt ; " >< span =style=3D" font - size :11 pt ; " >< strong > Tip : < / strong > You can also select all of the data on a worksheet by pressing Ctrl + A . However , if there are blank rows or columns within your data set , those will also be selected when using this shortcut . If you only want to select your data set and not blank rows or columns , it 's best to use one of the methods described above.

Move beyond 

Excel

Get started with Causal today.
Build models effortlessly, connect them directly to your data, and share them with interactive dashboards and beautiful visuals.