MS Office Excel: Fix column width
In this practical tip we will show you how you can fix the column width in Excel. This is helpful if you do not want to have certain cell contents changed in the display.
Freeze column width in Excel
Note: These instructions refer to Excel 2013.
- Click on "File". Select the item "Information" in the column on the left.
- Then click "Protect Workbook" and select "Protect Current Table".
- In the small table, only select "Edit objects".
- You can also protect the worksheet with a password. You can enter this above and then have to confirm it. This is useful if you are not working on the Excel document alone.
- After you have made your selection, the column widths are fixed.