| Home |
| Search |
| Today's Posts |
|
#1
October 21st 09, 06:18 PM
posted to microsoft.public.excel.misc
|
|||
|
|||
Can you lock the column width?
I would like to lock the column width, but still allow data to be entered in
the column. Is this possible? |
|
#2
October 21st 09, 06:24 PM
posted to microsoft.public.excel.misc
|
|||
|
|||
|
Can you lock the column width?
--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
October 2nd 13, 04:33 AM
posted to microsoft.public.excel.misc
|
|||
|
|||
|
Can you lock the column width?
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
November 27th 14, 12:11 PM
posted to microsoft.public.excel.misc
|
|||
|
|||
|
Can you lock the column width?
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
January 30th 15, 06:38 PM
posted to microsoft.public.excel.misc
|
|||
|
|||
|
Can you lock the column width?
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
March 20th 15, 07:22 AM
posted to microsoft.public.excel.misc
|
|||
|
|||
|
Can you lock the column width?
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
April 13th 15, 03:48 PM
posted to microsoft.public.excel.misc
|
|||
|
|||
|
Can you lock the column width?
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
April 13th 15, 04:21 PM
posted to microsoft.public.excel.misc
|
|||
|
|||
|
Can you lock the column width?
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
April 13th 15, 04:36 PM
posted to microsoft.public.excel.misc
|
|||
|
|||
|
Can you lock the column width?
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
April 13th 15, 04:48 PM
posted to microsoft.public.excel.misc
|
|||
|
|||
|
Can you lock the column width?
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 | |
|
|
Similar Threads
|
||||
| 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) | |||
Linear Mode
