What happen when a row is hidden?

  • Thread starter Thread starter Jo
  • Start date Start date
If you hide the row via data|filter|autofilter, take a look at =subtotal().

If you're running xl2003+ (IIRC), you can use =subtotal() for rows that are
hidden manually, too.

Look for the
=subtotal(1xx,...
instructions
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Exporting to text file in multiple lines 3
ODBC and Excel 1
Macro to copy previous row and insert two blank rows 1
Conditional Formatting with VBA 4
Loop and transpose sets of data 2
Unexplicable error 1
Sumif 8
Return Last 10 rows in reverse row order. 9

Back
Top