Sometime after we create some pattern in Excel Data, we don’t want other people who open the data will change or modify our data, Because of that we want to hide and protect the data.
Follow the instruction below tips to hide and protect pattern in Excel:
1. For Example we have data in Excel such us below
2. - Press Ctrl + A on the keyboard to select all data
- Right Click then select Format Cell->Protection
- Make sure to Clear Check box Locked and Hidden
- Click Ok
3. Select the data which is we want o hide it
below Example we want to hide data F,A,C in cell (B9:B11)
- Select the data in cell (B9:B11)
- Right Click then select Format Cell->Protection
- Tick mark Check box Locked and Hidden
- Click Ok
4. - Select Cell data (B9:B11)
- In tab Review, Click Protect Sheet
- Type the password
- Click Ok
5. Done, Please see the result below
Related Topics:
How to Hide and Protect Pattern / Formula in Microsoft Excel 2007
How to Paste your data from Notepad to the Excel Columns
How to change Text color in the cell that contains negative numbers in Excel 2007
Time Count/Calculation using Excel
Microsoft Excel 2007: How to take limit value to the cell
Sir, this is good to protect the whole sheet. if I want to protect and hide only the formula cell then what should I do is there any hepl. please
ReplyDelete