Home |
Search |
Today's Posts |
#1
![]() |
|||
|
|||
![]()
I would like to lock the column width, but still allow data to be entered in
the column. Is this possible? |
#2
![]() |
|||
|
|||
![]()
--Select the range of cells in which the user needs to be allowed to enter
data. Right clickProtection tabuncheck 'Locked --From menuToolsProtectionProtect sheet. From the list allow everything except 'format columns' and 'format rows' --Hit OK (If you need you can assign a password..) If this post helps click Yes --------------- Jacob Skaria "Nightshade" wrote: I would like to lock the column width, but still allow data to be entered in the column. Is this possible? |
#3
![]() |
|||
|
|||
![]()
Pada Kamis, 22 Oktober 2009 0:18:03 UTC+7, Nightshade menulis:
I would like to lock the column width, but still allow data to be entered in the column. Is this possible? thanx guys! verry helpful |
#4
![]() |
|||
|
|||
![]()
On Wednesday, October 21, 2009 6:24:01 PM UTC+1, Jacob Skaria wrote:
--Select the range of cells in which the user needs to be allowed to enter data. Right clickProtection tabuncheck 'Locked --From menuToolsProtectionProtect sheet. From the list allow everything except 'format columns' and 'format rows' --Hit OK (If you need you can assign a password..) If this post helps click Yes --------------- Jacob Skaria "Nightshade" wrote: I would like to lock the column width, but still allow data to be entered in the column. Is this possible? Thanks Jacob, you just saved me hours that would have been wasted on trial and error. |
#5
![]() |
|||
|
|||
![]()
On Wednesday, October 21, 2009 at 11:24:01 AM UTC-6, Jacob Skaria wrote:
--Select the range of cells in which the user needs to be allowed to enter data. Right clickProtection tabuncheck 'Locked --From menuToolsProtectionProtect sheet. From the list allow everything except 'format columns' and 'format rows' --Hit OK (If you need you can assign a password..) If this post helps click Yes --------------- Jacob Skaria "Nightshade" wrote: I would like to lock the column width, but still allow data to be entered in the column. Is this possible? This worked perfectly. Thanks bud! |
#6
![]() |
|||
|
|||
![]()
On Wednesday, October 21, 2009 at 10:48:03 PM UTC+5:30, Nightshade wrote:
I would like to lock the column width, but still allow data to be entered in the column. Is this possible? Thanks Jacob |
#7
![]() |
|||
|
|||
![]()
On Wednesday, October 21, 2009 at 6:24:01 PM UTC+1, Jacob Skaria wrote:
--Select the range of cells in which the user needs to be allowed to enter data. Right clickProtection tabuncheck 'Locked --From menuToolsProtectionProtect sheet. From the list allow everything except 'format columns' and 'format rows' --Hit OK (If you need you can assign a password..) If this post helps click Yes --------------- Jacob Skaria "Nightshade" wrote: I would like to lock the column width, but still allow data to be entered in the column. Is this possible? Brilliant. Thank you! |
#8
![]() |
|||
|
|||
![]()
Has something changed here in the UI? When I follow your path, I don't see an option to selectively choose what can or cannot be edited by other users...
|
#9
![]() |
|||
|
|||
![]()
On Monday, April 13, 2015 at 5:21:40 PM UTC+2, fn8tt0 wrote:
Has something changed here in the UI? When I follow your path, I don't see an option to selectively choose what can or cannot be edited by other users... What I mean: In Menu Tools Protect Sheet I get to an interface entitled "Protected Sheets and ranges", and if I click on "Set Permissions" I only see/am able to add/delete people, but I cannot finetune WHAT these people are allowed to edit or not.... any help would be much appreciated. I want to lock the column widths in my sheet, but nothing else (i.e. collaborators should be able to insert data into cells, but not change column widths) |
#10
![]() |
|||
|
|||
![]()
On Wednesday, October 21, 2009 at 7:18:03 PM UTC+2, Nightshade wrote:
I would like to lock the column width, but still allow data to be entered in the column. Is this possible? What I mean: In Menu Tools Protect Sheet I get to an interface entitled "Protected Sheets and ranges", and if I click on "Set Permissions" I only see/am able to add/delete people, but I cannot finetune WHAT these people are allowed to edit or not.... any help would be much appreciated. I want to lock the column widths in my sheet, but nothing else (i.e. collaborators should be able to insert data into cells, but not change column widths) |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
How do i lock the column width in Excel? | Excel Discussion (Misc queries) | |||
How to prevent the auto resizing of a column (ie, lock the width) | Excel Discussion (Misc queries) | |||
lock column width | Excel Discussion (Misc queries) | |||
How to lock column width? | New Users to Excel | |||
Is it possible to lock the height and width of a cell? | Excel Discussion (Misc queries) |