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

Pivot Table Drill Down
Double-click any number in a pivot table to create a new report showing all detail rows that make up that number
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
268
hcgood
H
N
  • Question
Locking a row after info entered
Replies
1
Views
458
RustamMika
R
N
  • Solved
Password protect column with unlock button
Replies
4
Views
393
DanteAmor
DanteAmor
sparky2205
  • Question
Maintain formats while copying rows in protected sheet
Replies
0
Views
306
sparky2205
sparky2205
T
  • Question
Insert/Delete not available on Protected Sheet
Replies
0
Views
364
tlrowe9065
T

Forum statistics

Threads
1,214,864
Messages
6,121,984
Members
449,058
Latest member
oculus

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