Use `=COUNTA(A:A)` to count non-empty cells in column A
Use `=COUNT(A:A)` to count cells with numbers in column A
Use `=ROWS(A1:A100)` to count the total rows in a range
Select a range and look at the status bar for the count
Use `=SUBTOTAL(103,A:A)` to count visible non-empty cells in a filtered list
Use `=COUNTIF(A:A,”<>“)` to count non-blank cells in a column
Use a PivotTable to count rows by adding a field to Values
Use the row numbers on the left side of the sheet to estimate the total used rows
Use `Ctrl + Shift + End` to find the last used cell in the worksheet
Use `=MAX(ROW(A:A))` with care if you need the highest row number in a referenced range