Fixed Column Width

  • Thread starter Thread starter Mark Keogh
  • Start date Start date
M

Mark Keogh

Hi,

I need to create, for want of a better word, a separator column in my
XLS. This column is supposed to be a fixed width, .3, and the user
shouldn't be able to make it bigger.

Any ideas on how I can get this to work?

Thanks!

Mark
 
Pick any column (or insert a column: Insert/Columns), then use
Format/Column/Width and make it .3. To prevent the user from changing the
width, you would need to protect the worksheet, using a password.
HTH
Bob Umlas
Excel MVP
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

modifying cell width within same column, but on different rows 2
Pivot tables and column widths 1
text to columns 1
freeze width of a column used by pivot table 4
Text to columns 2
having two separate column width controls on same worksheet 1
change zoom based on column width 2
Set Column Width to Inches? 0

Back
Top