Row hieght formula

  • Thread starter Thread starter funktastic
  • Start date Start date
F

funktastic

I was wondering if there is a formula for row height. I have a lon
list, and I want each row that returns a 0 to collapse automatically.
Anyone know how to do that
 
You should hide them. I'm not too keen on Visual Basic, but that's where
you'd need to go to automate it. If you'd like to do it manually you can
filter the cells.

HTH,
Kevin M
 
The filtering is the easiest. If you want your totals to change
you will have to use SUBTOTAL(9, ....)

For how to filter go to Debra Dalgleish's site
http://www.contextures.com
look for Excel tips or developer tips for the index.
 
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

Formatting excel 2
Excel Help to copy information from one row at a time to another sheet 1
Formula for row height in Excel 1
VLOOKUP????? 2
Collapsing rows via command button 2
Row Hieght/Coulmn Width 3
Rows Still M.I.A. 3
Sheet Row Heights 3

Back
Top