ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   column widths (https://www.excelbanter.com/excel-discussion-misc-queries/137525-column-widths.html)

eleeng

column widths
 
How do I set up Excel to not allow the column widths to be changed. I have my
widths and want it to always stay the same. I have some hidden columns I use
for not allowing to be seen when printed out. I also have the first 4 rows,
columns A to L formated to a certain text size I would like to keep as a
"template" to copy all the headers for the columns. This document is used as
a bill of materials.

Gord Dibben

column widths
 
ToolsProtectionProtect Worksheet.


Gord Dibben MS Excel MVP

On Mon, 2 Apr 2007 10:04:03 -0700, eleeng
wrote:

How do I set up Excel to not allow the column widths to be changed. I have my
widths and want it to always stay the same. I have some hidden columns I use
for not allowing to be seen when printed out. I also have the first 4 rows,
columns A to L formated to a certain text size I would like to keep as a
"template" to copy all the headers for the columns. This document is used as
a bill of materials.




All times are GMT +1. The time now is 02:19 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com