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.