Uneditable selected Columns/Rows/Cells Excel

Solved/Closed

AD - Jun 25, 2010 at 10:53 AM
AD - Jun 30, 2010 at 07:14 AM

Hello,

Kindly teach me how to keep the slected [Column or Rows or set of Cells] in Uneditable Mode in Excel, so that users can not change the information on any specific area.

If there is Macro needs to be written, then the Macro should also be protected.

Kindly help.

Uneditable selected Columns/Rows/Cells Excel
How to take screenshot of selected area in excel - Guide
Excel date format dd.mm.yyyy - Guide
Excel free download - Download - Spreadsheets
Clear only the formatting from the selected cell (leaving the content) - Guide
Number to words in excel - Guide

2 responses

Answer 1 / 2

AD
Jun 30, 2010 at 07:14 AM

We appreciate the help provided.

Answer 2 / 2

rizvisa1 Posts 4478 Registration date Thursday January 28, 2010 Status Contributor Last seen May 5, 2022 766
Jun 25, 2010 at 03:31 PM

You have to use sheet protection. Read excel help on sheet protection.

Similar discussions

How to use conditional format based on text?

How to calculate positions (1st,2nd,3rd...) in Excel

help me to add particular cells

Similar discussions

Subscribe To Our Newsletter!