Загрузка страницы
Все видеоНовые видеоПопулярные видеоКатегории видео

Excel - Conditionally Lock Cells Based on Other Values

You can prevent users from accessing certain cells in a spreadsheet based on the values in specified ranges. Learn how to do this with three different examples. Then, we will discuss an alternative.

🕒 Timestamps:
0:00 Intro and setup
0:56 Based on One Other Column
2:42 More than One Column
3:58 Controlled by One Cell's Value
5:38 No Validation (Filter)

Learn Modern Tech from Prolific Oaktree
🎓Courses - https://training.prolificoaktree.com
📣 Social - @ProlificOaktree (FB and Twitter)
📰 Articles - https://www.prolificoaktree.com

#excel #spreadsheet #microsoft

Видео Excel - Conditionally Lock Cells Based on Other Values канала Prolific Oaktree
Показать
Комментарии отсутствуют
Введите заголовок:

Введите адрес ссылки:

Введите адрес видео с YouTube:

Зарегистрируйтесь или войдите с
Информация о видео
6 декабря 2020 г. 18:06:03
00:06:21
Prolific Oaktree
Теги
Правообладателям
Жалоба
Комментарии
Другие видео канала
Google Sheets - Conditionally Lock Cells Based on Other ValuesGoogle Sheets - Conditionally Lock Cells Based on Other ValuesCreate SMART Drop Down Lists in Excel (with Data Validation)Create SMART Drop Down Lists in Excel (with Data Validation)Google Drive - Organize Your Files and FoldersGoogle Drive - Organize Your Files and FoldersPreventing Access to a Cell and Greying out if another cell has a certain valuePreventing Access to a Cell and Greying out if another cell has a certain valueGoogle Sheets Tutorial - Create Your First SpreadsheetGoogle Sheets Tutorial - Create Your First SpreadsheetGoogle Sheets - Combining Data -|- Multiple Worksheets and FilesGoogle Sheets - Combining Data -|- Multiple Worksheets and FilesGoogle Sheets - Create an Interactive Task List with TimestampsGoogle Sheets - Create an Interactive Task List with Timestamps50 Ultimate Excel Tips and Tricks for 202050 Ultimate Excel Tips and Tricks for 2020Excel CONCATENATE Using IF and COUNTAExcel CONCATENATE Using IF and COUNTAHighlight Locked or Unlocked Cells in Excel using Conditional FormattingHighlight Locked or Unlocked Cells in Excel using Conditional FormattingExcel - Use Conditional Formatting on a Cell Based on Another Cell's ValueExcel - Use Conditional Formatting on a Cell Based on Another Cell's ValueFIND() LEN() LEFT() RIGHT() Functions Extract Text From Cells in Excel Advanced P.1FIND() LEN() LEFT() RIGHT() Functions Extract Text From Cells in Excel Advanced P.1Most Useful Excel Keyboard ShortcutsMost Useful Excel Keyboard ShortcutsExcel VBA Introduction Part 5 - Selecting Cells (Range, Cells, Activecell, End, Offset)Excel VBA Introduction Part 5 - Selecting Cells (Range, Cells, Activecell, End, Offset)Excel Hack: Copy Formula Without Changing Cell References (or Without File References)Excel Hack: Copy Formula Without Changing Cell References (or Without File References)Google Sheets - Build Your Own Search BoxGoogle Sheets - Build Your Own Search BoxLock Cells & Protect Excel Worksheet - EVEN by Cell Color!Lock Cells & Protect Excel Worksheet - EVEN by Cell Color!How to Combine 2 Excel Workbooks Using VLOOKUPHow to Combine 2 Excel Workbooks Using VLOOKUPHow to Create Drop Down Lists in Cells - The Complete Excel GuideHow to Create Drop Down Lists in Cells - The Complete Excel Guide
Статистика портала
Яндекс.Метрика
© 2008-2024 «Информационно-развлекательный портал города Верхняя Салда»
| Карта портала | Реклама | Контакты | Сообщить об ошибке | Соглашения
salda.ws salda.ws@mail.ru
Сейчас на сайте: 512 Статистика портала