Trying to navigate an Excel spreadsheet is like going through a corn maze, so let's get you up to speed on some of the tips and tricks to running your Excel spreadsheet.
If you're wondering how to show or unhide rows or columns in Excel, it's easier than it looks, and I know it can be quite a pain to find something that doesn't necessarily look like it's there, so let's get started.
Here's how to show or unhide rows or columns in Excel.
How to show or unhide rows or columns in Excel
1. Select adjacent rows or columns
What you want to do in order to reveal those hidden rows or columns is actually select the adjacent rows or columns first.
2. Right-click > Unhide
Now you'll want to right-click the selected columns, and then select Unhide. And all will be revealed!
3. Or double-click the double line
If you already know where the hidden rows or columns are, you can simply double-click the double line between the two rows or columns where hidden rows or columns exist. This will instantly reveal what's there.
It's just that easy. If you're looking for some more Excel tutorials, check out our guide on how to use Microsoft Excel like a pro, which offers a list of tips, including how to Freeze Rows and Columns in Excel, Build a Forecast Chart in Excel, and Create a Funnel Chart in Excel.