Fix Columns Article For Free

Click the View tab in the Ribbon and then click Freeze Panes. In the drop-down menu, select Freeze Panes. The column and row headings will now be locked into place.

If you want the row and column headers always visible when you scroll through your worksheet, you can lock the top row and/or first column. Tap View > Freeze Panes, and then tap the option you need.

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.

If you want the row and column headers always visible when you scroll through your worksheet, you can lock the top row and/or first column. Tap View > Freeze Panes, and then tap the option you need.

To autofit multiple columns, select them, and double click any boundary between two column headers in the selection. To force all columns on the sheet to automatically fit their contents, press Ctrl + A or click the Select All button, and then double click a boundary of any column header.

Excel Tricks - Freeze the Column Headings - YouTube YouTube Start of suggested clip End of suggested clip Now select the freeze panes drop down menu. There are several choices but we'll select freeze topMoreNow select the freeze panes drop down menu. There are several choices but we'll select freeze top row. Now when scrolling through the document the top row stays in view.

To lock multiple rows (starting with row 1), select the row below the last row you want frozen, choose the View tab, and then click Freeze Panes. To lock multiple columns, select the column to the right of the last column you want frozen, choose the View tab, and then click Freeze Panes.