Inside Microsoft Excel


Stop hidden rows from fouling up your formulas

Inside Microsoft Excel

by Stephen Nebel

If you hide a row in a financial spreadsheet without realizing that the row contains a non-zero value, (maybe far to the right in column BF, for example), this number gets picked up and printed in theĀ SUMĀ formulas for the bottom line. Then you have that embarrassing moment in the final review meeting when someone helpfully points out, “Hey! These numbers don’t add up!”

There are two opportunities for automation in this scenario. First,[…]

 

Subscribe to Inside Microsoft Excel

(get full access to archives and more)