Monday, September 26, 2011

How to Lock Column Width in Excel 2007


1. Open Excel 2007 and click the 'Office' button. Select 'Open.' Browse the files and locate the workbook. Click the workbook and select 'Open.'
2. Select the worksheet in the workbook where the locked column width will occur. Right click the column header and select the 'Protection' tab. Make sure 'Locked' is selected. Click 'Ok.'
3. Click the 'Review' tab and select 'Protect Sheet.' Make sure the 'Protect worksheet and contents of locked cells' is selected. De-select the option to 'Select Locked Cell.' Click 'Ok.'
4. Right click the column and notice the option to adjust the column width is grayed out and not available.

Blogger news