હિમાંશુ પરભુભાઇ મિસ્ત્રી | Himanshu Mistry

July 30, 2008

How to lock a column/row/cell in MS Excel

Filed under: how to,Useful Links — Himanshubhai Mistry @ 9:31 pm

How to Lock a column MS Excel

some time we need to lock a column from the end user protecting from accidental changes.

scenario:

   A           B 
1 data1      =fun(A1)
2 data2      =fun(A2)
3 data3      =fun(A3)

We want the user to allow key in data in column ‘A’
Function given in column ‘B’ will produce result and user will be able to view the result.
we don’t want the user to select/edit the cells of column ‘B’

steps how to achieve this:
[1] Select the columns (or rows/cells) the user should be able to to TYPE data into.
[2] Format menu / Cells / protection tab
[3] Remove the tick-mark from ‘locked’
[4] Tools menu / protection / protect sheet and apply protection

You will find that you can only type data in the cells that you selected and then removed the ‘locked’ tick-mark from.

This is applicable for cells, columns or rows..

Leave a Comment »

No comments yet.

RSS feed for comments on this post. TrackBack URI

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

Blog at WordPress.com.

%d bloggers like this: