How to set locked cells in excel table without scrolling

How to set locked cells in excel table without scrolling

1. Open the table that needs to be modified, and in the table Find the view option above on the main page and click on it to enter the view page.

Recommendation: "excel tutorial"

2. Find the freeze pane option on the view page and click it option to go to the Freeze Panes page.

#3. Find the Freeze First Row option on the Freeze Pane page to fix the first row of cells in the table.

#4. Find the Freeze First Column option on the Freeze Pane page to fix the first column of cells in the table.

#5. If you want to fix other cells, drag the left mouse button to select the cells that need to be fixed.

#6. After selecting, find the Freeze Split Cells option on the Freeze Panes page. Click this option to freeze the selected cells.

The above is the detailed content of How to set locked cells in excel table without scrolling. For more information, please follow other related articles on the PHP Chinese website!