Anyone who works with large Excel tables on a daily basis will have to do a lot of scrolling. Over time, this can become cumbersome. However, it’s not a huge problem, particularly because you can use functions like “Find” and “Go to” – both available as keyboard shortcuts – to quickly jump to certain entries. But the fact that thefirst rows or columns disappear as standard whenever you scroll down or right is more problematic. Important elements like the headings of rows and columns are then invisible, making it unnecessarily difficult to work with these kinds of tables.
The solution to this problem is offered by the Microsoft program itself, since you can freeze rows in Excel. This way, they always remain visible – no matter which part of the table you are currently viewing. We show you how you can activate this feature in your Excel tables.