These tips and tricks can help you more easily handle a huuuuuge spreadsheet.
You’ve created an Excel spreadsheet that stretches beyond what you can see on the screen, maybe one that encompasses hundreds of rows or columns. And now working with and navigating that spreadsheet has become slow and clumsy.
Do you need to pare down your spreadsheet? Nope, don’t change it. Instead, you can tap into various tools and features in Excel to use and move around your big spreadsheet. Here’s what you can do:
- Certain keyboard shortcuts can hop around your spreadsheet in the blink of an eye.
- You can also name cells or ranges of cells to move to them by name.
- You can filter the data in a row to see only certain content.
- You can freeze specific rows and columns, such as header rows, so they’re always visible.
- And you can split your spreadsheet to see more than one area. Let’s check out the different ways to work with large Excel spreadsheets.
I’m using Excel 2016 for the examples here, but you should be able to apply the same tricks in the past couple of versions of the program.
To start, load Excel and create or open a large spreadsheet. Your spreadsheet should have several rows and columns. For our purposes, it doesn’t matter what data is in your spreadsheet. You can just copy the same rows and columns over and over.