Home Excel Content

How to Lock a Row or Columns in Excel

Tips 2022-05-24 15:05:57 Excel 169

1.To lock rows, select the row below where you want the split to appear.

To lock columns, select the column to the right of where you want the split to appear.

To lock both rows and columns, click the cell below and to the right of where you want the split to appear.

2.On the Window menu, click Split.

3.To remove the split, click Remove Split on the Window menu.

How to Lock a Row or Columns in Excel1

When the pointer changes to a split pointer Split pointer or Resize pointer (double-headed arrow), drag the split box down or to the left to the position you want.

1.To lock rows, select the row below where you want the split to appear.

To lock columns, select the column to the right of where you want the split to appear.

To lock both rows and columns, click the cell below and to the right of where you want the split to appear.

2.On the Window menu, click Freeze Panes.

3.To unlock rows, click Unfreeze Panes on the Window menu.