Can you lock the width of a column?

N

Nightshade

Is it possible to lock the width of a column, but still allow data to be
entered in that columns cells?
 
M

Mike H

Hi,

Select cells in which the user is to be allowed to enter data.
Right click - Format cells - Protection tab -uncheck 'Locked'

Tools - Protection Protect sheet. check everything except 'format columns'
and 'format rows'
OK

Mike
 
D

David Biddulph

See the reply to your previous thread, which was entitled:
"Can you lock the column width?"
 

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

Format column widths from one table to a separate table on same page 1
Can you lock the column width? 3
Access Lock File .LACCDB / Now shows as a notepad file 0
Excel Column Width in XLSX 0
Table Preferred width is changed when pasting 1
Table Column Widths Fixing Size in Word 2010 4
Locking column widths 2
In-Cell Graph Using REPT But Proportional to Cell Width? 0

Top