N Nightshade Oct 22, 2009 #1 Is it possible to lock the width of a column, but still allow data to be entered in that columns cells?
Is it possible to lock the width of a column, but still allow data to be entered in that columns cells?
M Mike H Oct 22, 2009 #2 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
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 Oct 22, 2009 #3 See the reply to your previous thread, which was entitled: "Can you lock the column width?"