I know for a fact that as of one month ago my version of Excel (2016 MSO 32-bit) would skip hidden rows if I dragged down formatting or formulas. However, this morning I was working on a project and I dragged down a few formulas and the hidden rows were changed as well. Did Excel change something? Did I inadvertently change a setting? Thanks in advance for the help!
Bookmarks