Have you ever been in a large spreadsheet and you can’t do one of the following two things:
- Use your scroll wheel to navigate?
- Use the “Find” tool and then have Excel jump to the desired cell that has the search query?
If this sounds like you, this means you likely have a portion of your screen frozen caused by “Freeze Panes”. You can run into this problem if you’re using filters and you don’t realize you’re freezing a large portion of your unfiltered spreadsheet.
Easiest fix is to just disable the freeze panes function, un filter all your rows and then do a freeze panes on the A2 cell.
Hope we’ve reduced some MS Excel frustration!