1. As shown in the figure, the most common report card is taken as an example. There is a lot of data. I hope that when viewing the data, the first row header and the first column name remain unchanged.
#2. Click the position to be fixed and drop the first cell with data. Observe carefully that B2 is selected in the picture, and then click Freeze Window in the Data menu.
#3. You will see two more thin solid lines on the screen. The arrow points to. That's the sign of lockdown.
#4. Try to view other data sent and you will see it. The first row and first column will be displayed in the locked state.
Note: If you need to cancel the lock, click on the data menu. As shown in the figure, click to unfreeze the window.
Recommended related articles and tutorials: excel tutorial
The above is the detailed content of Excel locked cell scrolling remains unchanged. For more information, please follow other related articles on the PHP Chinese website!