Something as shown below: In such cases, it’s a good idea to freeze the top row so that the headers are always visible to the user. In this section, you’ll learn how to: • How to Freeze the top row. • How to Freeze more than one row. • How to Unfreeze rows.

Tips: • If you are working with Excel tables rather than ranges, you do not really need to lock the first row, because the table header always stays fixed at the top, no matter how many rows down you scroll in a table. • If you are going to print out your table and want to repeat header rows on every page, you may find this tutorial helpful -.

• On the View tab, click Freeze Panes > Freeze Panes. Yep, it's that easy:) For example, to freeze top row and first column in a single step, select cell B2 and click Freeze Panes: This way, the header row and leftmost column of your table will always be viewable as you scroll down and to the right: In the same fashion, you can freeze as many rows and columns as you want as long as you start with the top row and leftmost column.

Office home & student 2016 for pc. Collaborate for free with online versions of Microsoft Word, PowerPoint, Excel, and OneNote. Save documents, spreadsheets, and presentations online, in OneDrive.

Your screen should look something like this. Microsoft office for mac home and student 2008.

• In the Freeze Panes drop-down, select Freeze Panes. • This will freeze all the rows above the selected cell. You would notice that a gray line now appears right below the rows that have been freezed. Now when you scroll down, all the header rows would always be visible. Something as shown below: Unfreeze Rows in Excel To unfreeze row(s): • Go to View –> Zoom –> Freeze Panes.

From time to time i receive or develop Excel spreadsheets which contains huge data tables. One of the challenges in this case is how to ensure that the first rows and columns stay visible when you scroll through the table, so it’s easier to correlate the data itself with the row/column heading.