Excel Tips Monster

Lost your columns in the abyss?

From time to time, I break a very long and complicated formula into several simpler ones with intermediate results in additional columns.

This is all nice until I want to give the sheet to someone, and I don’t want them to get confused, so I hide the extra columns.

But then sometimes I have to change the formulas in those hidden columns, so I select a range of columns that includes the hidden ones, and click Un-hide.

But what if I hide the first column (A)? What then?

Here’s the answer on how to un-hide rows and columns in Excel, there’s even a video