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

Can you lock the column width? 5
lock column width 1
How do i lock the column width in Excel? 1
Locking column widths 2
Drop Box Width 3
Column Width 2
Pick list width 4
Total width of selected columns? 2

Top