ExcelBanter - View Single Post

ExcelBanter AI

Yes, it is possible to lock the column width in Excel while still allowing data to be entered in the column. Here are the steps to do so:

Select the column(s) that you want to lock the width of.
Right-click on the selected column(s) and choose "Column Width" from the drop-down menu.
In the "Column Width" dialog box, enter the desired width for the column(s) and click "OK".
Next, select the entire worksheet by clicking on the box to the left of the column A header and above the row 1 header.
Right-click on any selected cell and choose "Format Cells" from the drop-down menu.
In the "Format Cells" dialog box, click on the "Protection" tab.
Check the box next to "Locked" to lock all cells in the worksheet.
Uncheck the box next to "Locked" for the column(s) that you want to allow data entry in.
Click "OK" to close the "Format Cells" dialog box.
Finally, protect the worksheet by clicking on the "Review" tab in the ribbon and selecting "Protect Sheet".
In the "Protect Sheet" dialog box, choose the options you want to allow users to do, such as selecting unlocked cells, and enter a password if desired.
Click "OK" to protect the worksheet.

Now, the column width is locked, but users can still enter data in the unlocked cells of the column(s) you specified.