Worlds best microsoft office tutorials content. Find anything about microsoft office tutorials needs on this site.
Freeze Panes To Lock Rows And Columns. Besides locking columns and rows separately Microsoft Excel lets you freeze both rows and columns at the same time. To keep an area of a worksheet visible while you scroll to another area of the worksheet go to the View tab where you can Freeze Panes to lock specific row.
Freeze Rows And Columns In Google Sheets Illustration 4 Google Sheets Column The Row from br.pinterest.com
On the Excel Ribbon click the View tab To see the Freeze Pane options click the arrow on the Freeze Panes button. A command that enables you to select one or more rows or columns and lock them into place. How to lock multiple Excel rows.
On scrolling down frozen rows will stay fixed.
On the View tab in the Window group click the arrow below Freeze Panes. If you want to freeze the first two columns what you can do is to select the third column. Freeze Panes To Lock Rows And Columns Column The Row Excel. How to Freeze Rows in Excel.
