Thankfully, Excel makes it easy to hide or unhide rows and columns ... Alternatively, you can quickly unhide a row or column by double-clicking the thin double line. If you have multiple hidden ...

Excel's AGGREGATE function lets you perform calculations whilst ignoring hidden rows, errors, or other functions that appear ...