Lock Up Table Of Contents Lease For Free

Freeze columns and rows Select the cell below the rows and to the right of the columns you want to keep visible when you scroll. Select View > Freeze Panes > Freeze Panes.

Freezing a Table Select the cells you want to "freeze." (If you want to affect the entire table, select the entire table.) Choose the Cell Height and Width option from the Table menu. ... Change the height specification from Auto to Exactly. ... In the At field, enter the height you want for your rows, in points.

How to Simultaneously Freeze Rows and Columns in Excel - YouTube YouTube Start of suggested clip End of suggested clip Now at the same time I want to freeze. This row. As well containing the column heading so I'm stillMoreNow at the same time I want to freeze. This row. As well containing the column heading so I'm still going to click in a cell beneath that.

5 Answers. Click on the cell just to the right of the column, and just below the row you want to freeze, and then select View ? Window ? Freeze Panes ? Freeze Panes . So, if you want to freeze row 1 and the column A , click on B2 and select View ? Window ? Freeze Panes ? Freeze Panes .

Freeze as many rows or columns as you want To freeze multiple columns, select the column to the right of the last column you want frozen and click Freeze Panes. Say you want to freeze the top four rows and leftmost three columns. You'd select cell D5, and then on the View tab, click Freeze Panes.

The TOC field may have been locked. Try selecting the Table of Contents and then press CTRL+SHIFT+F11 (unlock field) and see if you can then update the Table of Contents. Another possibility is that the Table of Contents has been unlinked from the data in the document.

On the View tab, in the Window group, click the arrow below Freeze Panes. time, click Freeze Panes. Unfreeze Panes so that you can unlock any frozen rows or columns.