When creating a table with massive data is what you smoetimes (I have to do tables for my lab report), then keeping the headers/panes of the table visible is something you would want to see when you are scrolling down the data. Using Excel, this can be done simply.
Consider the table I have made in the video below, what you need to do, is to follow these steps.
- Make sure you place the cursor on the first cell that you would NOT freeze.
- From the VIEW ribbon, select Freeze Panes dropdown.
- Then choose Freeze Panes.
More articles on ToyangQren's another blog.