Is it possible lock the column width

L

lmlau10

New Member
Joined
Apr 12, 2005
Messages
7
Is there any way to lock the column width, i had tried Format > Column > Standard Width but couldn't seem to work, please help
 

Excel Facts

How to total the visible cells?
From the first blank cell below a filtered data set, press Alt+=. Instead of SUM, you will get SUBTOTAL(9,)
Sort by date Sort by votes
You could protect the entire sheet? Is that what you mean?
 
Upvote 0
Not the worksheet, i just want the column width to be fixed at a number, can this be done?

i had tried Format > Column > Standard Width but couldn't seem to work.
 
Upvote 0
Hi there

Without protection, if you increase the font size the column is likely to increase in width to fit it. You might try selecting all cells and formatting them (Alignment tab) so that text will shrink to fit.

regards
Derek
 
Upvote 0
You must log in or register to reply here.

Similar threads

H
  • Question
How to hide some columns while allowing users to 'Format Columns'
Replies
2
Views
254
hcgood
H
N
  • Question
Locking a row after info entered
Replies
1
Views
449
RustamMika
R
N
  • Solved
Password protect column with unlock button
Replies
4
Views
387
DanteAmor
DanteAmor
sparky2205
  • Question
Maintain formats while copying rows in protected sheet
Replies
0
Views
303
sparky2205
sparky2205
T
  • Question
Insert/Delete not available on Protected Sheet
Replies
0
Views
359
tlrowe9065
T

Forum statistics

Threads
1,214,627
Messages
6,120,610
Members
448,973
Latest member
ChristineC

Share this page

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top