Hi,
Can someone help me in making a particular column or "n"number of columns/rows read only in a worksheet.
Regards,
Lavina
Hi,
Can someone help me in making a particular column or "n"number of columns/rows read only in a worksheet.
Regards,
Lavina
take follwing steps
select worksheet
right click and select format cell and in protection tab uncheck "Locked"
then select required column
right click and select format cell and in protection tab check "Locked"
then in protect sheet check "select unlocked cells" and unselect all other options
Azam
If you want to say Thank you to a member, click the reputation icon (Star) in the left bottom of the post.
For prompt answer, be descriptive, concise, short, direct, and to-the-point.
your could locked any row(s) and column(s) or cells seperatly or jointly and locked cells will be read only after protection
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks