Showing posts with label tables. Show all posts
Showing posts with label tables. Show all posts

20090601

Freezing Tables Panes in Excel

Microsoft Excel 2007 Tips #5 -- Freezing Panes in Excel Table

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.
  1. Make sure you place the cursor on the first cell that you would NOT freeze.
  2. From the VIEW ribbon, select Freeze Panes dropdown.
  3. Then choose Freeze Panes.
More articles on ToyangQren's another blog.