How to locked selected range on Excel Sheet (Excel Tip-5)
Hi Guys,
There are mentioned steps, which need to be follow.
Step 1:- Select whole sheet
Step 2:- Press Ctrl+1
Step 3:- Go to protection tab
Step 4:- Unchecked Locked Options, Press Ok
Step 5:- Select Range, Where you want to protect range.
Step 6:- Again press Ctrl+1, Go to protection tab
Step 7:- Checked locked options, Press ok
Step 8:- Now, Go to Review Tab
Step 9:- Click on Protect Sheet option
Step 10:-Enter Password & Re-Enter Password, Press ok
Step 11:-Now Selected Range is locked...
File Link:-shorturl.at/nyGKM
#AdvanceExcel #MicrosoftExcel #Excel2019 #Excel365 #ExcelTraining, #ExcelTutorial #ExcelAutomation #ExcelBeginners #ExcelUser #beginners #tableaudesktop #tableauvisualization #tableaututorial #passwordchange #setpassword #passwordexcel #passwordinsheet #locksheet #lockworkbook #lockworksheet #protect #protection #sheetprotection
Thanks guys,
Please Like, Share & Subcribe my channel..