Quick Links
Do you have an Excel sheet where you want thecolumns and rows at fixed sizes?
Maybe you have data that you want to display in a specific way.
For instance, you might expand a cell to accommodate a large font oran image.
This doesn’t prevent changes or edits until you use the sheet protection feature which we’ll describe below.
Go to the Protection tab and uncheck the box for Locked.
Then, click “OK” to apply the change.
Those are the only items locked.
Confirm the password and select “OK.”
Now, you might give your change a test.
You’ll notice that you no longer see the double-sided arrow between columns or rows.
Additionally, the resizing options in the shortcut menu are grayed out and unavailable.
Enter the password and click “OK.”
You’ll then see the double-sided arrow between columns and rows.
You also have the option to resize them in the shortcut menu.
For more, look at how tofreeze and unfreeze columns and rows.
