My First Post      My Facebook Profile      My MeOnShow Profile      W3LC Facebook Page      Learners Consortium Group      Job Portal      Shopping


Thursday, June 2, 2022

Freeze rows or columns in MS Excel or Office 365 Sheets

 Freeze rows or columns

Sometimes you want to freeze certain rows or columns or even an area in Excel sheet that you do not want to move while scrolling the sheet on left, right, up or down. Here is what you need to do - The Freeze Pane feature!

Freeze the first column

  • Select View Freeze Panes > Freeze First Column.

            The faint line that appears between Column A and B shows that the first column is frozen.

Freeze the first two columns

  1. Select the third column.

  2. Select View > Freeze Panes > Freeze Panes.

Freeze columns and rows

  1. Select the cell below the rows and to the right of the columns you want to keep visible when you scroll.

  2. Select View Freeze Panes > Freeze Panes.

No comments:

Post a Comment