Lock Cells & Protect Worksheet - By Cell Color or Formatting-(V047)
Hello Friends,
By default, protecting a worksheet locks all cells so none of them are editable. To enable some cell editing, while leaving other cells locked, it's possible to unlock all the cells. You can lock only specific cells and ranges before you protect the worksheet and, optionally, enable specific users to edit only in specific ranges of a protected sheet.
how to do that lets Learn together.
We have explained Excel tricks and tactics in detail in each video.
Please do visit our channel and given links below.
1) Visit Our Channel : / @excelexperthat
2) Our Short Video: • Excel-Short Trick Series (English)
3) Look-up Series : • Excel Lookup Formulas Series (English)
4) Excel Introduction: • Excel Introduction (English)
5) Excel Charts Series: • Excel Charts Series (English)
6) Excel Formula & Learning Series: • Excel Formula & Learning Series (English)
Our Long Videos:
1) Using Slicers in Excel to Filter Data
• Using Slicers in Excel to Filter Data (V007)
2) Excel Gantt Chart with Pivot Table
• Excel Gantt Chart with Pivot Table (V006)
3) Progress Bar in Excel Cells & Conditional Formatting
• Progress Bar in Excel Cells & Conditional ...
4) Excel Workday function: Find end date & exclude weekends & holidays
• Excel Workday function: Find end date & ex...
5) Project Plan in Excel with Gantt Chart (Plan, Actual & Progress, Work Priority)
• Ultimate Excel Gantt Chart Tutorial ( OnTr...
6) Remove author from the file properties – Excel
• Remove author from the file properties - E...
7) Excel Pivot Tables EXPLAINED in 15 Minutes (Productivity, Slicer tips included!)
• Excel Pivot Tables EXPLAINED in 15 Minutes...
8) How to Use SUM, SUMIF, SUMSQ, SUMIFS, SUMXMY2, SUMX2PY2, SUMX2MY2, SUMPRODUCT Formula in Excel
• How to Use SUM, SUMIF, SUMSQ, SUMIFS, SUMX...
9) Excel VLOOKUP - Basics of VLOOKUP and HLOOKUP explained with examples
• Excel VLOOKUP - Basics of VLOOKUP and HLOO...
10) How to use Excel Index Match (the Easiest way)
• Video
11) Advanced Excel Index Match (Most Effective Formulas for Multiple Criteria)
• Advanced Excel Index Match (Most Effective...
12) Work with Lookup within Boundaries: SUMIFS, SUMPRODUCT & INDEX
• Video
13) Excel most useful shortcut keys you SHOULD know!
• Video
14) Excel Charts & Graphs, Learn the Basics Quick Start
• Video
15) Excel Tutorial for Beginners-1 | Become an Expert in Excel
• Excel Tutorial for Beginners-1 | Become an...
16) Excel Tutorial for Beginners-2 | Become an Expert in Excel
• Excel Tutorial for Beginners-2 | Become an...
17) Excel Tutorial for Beginners-3 | Become an Expert in Excel
• Excel Tutorial for Beginners-3 | Become an...
18) Excel Tutorial for Beginners-4 | Become an Expert in Excel
• Excel Tutorial for Beginners-4 | Become an...
19) Excel Tutorial for Beginners-5 | Become an Expert in Excel
• Excel Tutorial for Beginners-5 | Become an...
20) Excel Header & Footer (& How to Copy to other Sheets)
• Excel Header & Footer (& How to Copy to ot...
Our Short Video:
1) Your Tab in Excel...Very Simple
• Your Own Tab in Excel...Very Simple (V018)
2) How to Show Excel Formulas in Cells with FORMULATEXT Function
• How to Show Excel Formulas in Cells with F...
3) Unit Converter in Excel
• Unit Converter in Excel (V021)
4) How to find Duplicated in List – Excel
• How to find Duplicated in List - Excel (V023)
5) You can now Hide and UNHIDE All Excel Sheets in ONE GO!
• You can now Hide and UNHIDE All Excel Shee...
6) Sort out Unique Items in the list
• Sort out Unique Items in the List - MS Exc...
7) How to Count Duplicates with the Help of Pivot Table - In MS Excel
• How to Count Duplicates with the Help of P...