2 Answers

Click on the Home tab and click to expand the Fontsection. Select the Protection tab and make sure that the Locked box isticked. Click on the Review tab and then Protect sheet. Click on the OK button.

Also Know, how do you AutoFit rows in Excel? To AutoFit column width, select one, several orall columns on the sheet, go to the Home tab > Cells group, andclick Format > AutoFit Column Width. To AutoFitrow height, select the row(s) of interest, go to theHome tab > Cells group, and click Format > AutoFit RowHeight.

Additionally, how do I lock row width in Excel?

If you want to lock the cell width androw height, you have to select Protect Sheet fromthe Format menu. Place a checkmark next to everything exceptFormat Columns and Format Rows, then clickOK.

How do I make Excel cells expand to fit text?

Wrap text automatically

In a worksheet, select the cells that you want to format. On the Home tab, in the Alignment group, click Wrap Text .Notes: Data in the cell wraps to fit the column width, so if youchange the column width, data wrapping adjusts automatically.