Can you lock column width in excel

In your Excel worksheets, you can also auto fit columns so that they get wider or narrower to fit the largest value in the column. When preparing a worksheet for printing, you may want to fix the column width in inches, centimeters or millimeters. Select one, several or all columns on the sheet, and drag the right boundary of any of the selected column headings until you set the required width. As you drag the boundary, Excel will display the column width in inches like shown in the screenshot below:.

With the width fixed, you can exit the Page Layout view by clicking the Normal button on the View tab, in the Workbook Views group. You already know how to make several or all columns on the sheet the same width by dragging the column border.

If you have already resized one column the way you want, then you can simply copy that width to other columns. To have it done, please follow the steps outlined below. The same technique can be used when you create a new sheet and want to make its column widths the same as those in an existing worksheet. To change the default width for all columns on a worksheet or the entire workbook, just do the following:.

Users should now be able to edit the specified cells, but not format rows and columns. Here three 3 examples, two 2 of them with VBA and one where you click "Edit Opjects" in your procedure. Products 75 Special Topics 42 Video Hub Most Active Hubs Microsoft Teams. Security, Compliance and Identity. Microsoft Edge Insider. Azure Databases. Project Bonsai. Education Sector. Microsoft Localization. If you want to protect multiple worksheets with same password at the same time, here recommend the Protect Worksheet utilities of Kutools for Excel.

With this feature, you can easily protect multiple or all worksheets in current workbook at a time as the below screenshot shown. Download and try it now! Note: The other languages of the website are Google-translated. Back to English. Log in. Remember Me Forgot your password? Password Reset. Report message as abuse. Show original message. Either email addresses are anonymous for this group or you need the view member email addresses permission to view the original message. I would like to lock the column width, but still allow data to be entered in the column.

Is this possible?