Most old-time users of Microsoft Excel probably already know this one, but for everyone else, here is a nice, simple little tip. When you have a large amount of data, say historical data, in a spreadsheet that you just don’t need to have right in front of you, you can hide those rows easily. The alternative is that the data sits there and you have to scroll through all of it to get to your most recent data. To hide rows, simply select the rows you want to hide, then right-click on the row headers and choose “Hide”. To unhide them, simply select the range which includes the hidden data and check “Unhide”.
Couldn’t be simpler.
The PCMech.com weekly newsletter has been running strong for over 8 years. Sign up to get tech news, updates and exclusive content - right in your inbox. Also get (several) free gifts.