КАК сделать ВЫПАДАЮЩИЙ список в Google Таблицах за 5 минут
In this video, I'll show you how to create drop-down lists in Google Sheets. You'll learn where to find the Data Validation tool, how to manually enter options or pull them from a separate range, and how to automatically update the list with new values using the UNIQUE function. These techniques will help you avoid typos, simplify data entry, and improve reporting accuracy. Subscribe to the channel ➡️ https://clck.ru/375eV3 🔻 More case studies here: ➡️ https://click.tgtrack.ru/6619736b4e49 🔻 You can read about the services here: https://clck.ru/39ETMM ⏰ Timestamps: 00:00 – Introduction: Why do you need a drop-down list in a table? 00:21 – Creating a new Google Sheets and defining a drop-down list 00:43 – Where is "Data Validation"? 02:27 – Assigning colors to the first and last elements of a list 03:01 – Settings for entering a value outside the list ("Show warning" or "Prohibit input") 03:20 – Display options: chip, arrow, or plain text 05:10 – Copying a rule to other cells 05:32 – Option 2: Drop-down list List from a range on a subsheet 06:18 – Setting up data validation 06:44 – Demonstration of automatic range expansion 08:24 – Editing existing data validation rules and updating a range 09:56 – Option 3: Drop-down list from a dynamic range using UNIQUE 10:23 – Demonstration of the UNIQUE function: collecting unique manager names from the main table 12:06 – Recommendations for practice: When is a drop-down list useful? 12:33 PM – Summary Digitalize your business – https://clck.ru/36ybYV Finzametki Telegram channel: https://clck.ru/375eV3 ✅ COURSES AND MASTER CLASSES: 🆓 2-day intensive course on financial models: https://clck.ru/34phmK 🎓 Financial models from scratch: https://clck.ru/34pf4s 🎓 Management 2.0: https://clck.ru/34pf7U 🎓 EXCELMANIA: https://clck.ru/34pf8E ✅ Submit a consultation request here https://clck.ru/39ETMM I wish you precision in business!

Базовый УРОК по Гугл таблицам — Как работать с Google таблицами от А до Я

Зависимые выпадающие списки

This Excel Feature Will Eliminate Data Entry Errors Forever! 🤯 | Data Validation Tutorial

Ex-Google Recruiter Explains Why "Lying" Gets You Hired

Создаем УМНЫЙ Выпадающий Список в Excel (для Дашбордов и Отчетов)

Which neural network is best at analyzing tables? 5 AI Test

Многоуровневые выпадающие списки в гугл таблицах
![PURPLE & PINK GRADIENT IN HD [3 HOURS]](https://i.ytimg.com/vi/dqAfan20GZY/hqdefault.jpg?sqp=-oaymwE9CNACELwBSFryq4qpAy8IARUAAAAAGAElAADIQj0AgKJDeAHwAQH4Af4JgALQBYoCDAgAEAEYVyATKH8wDw==&rs=AOn4CLDBcG_UH91ZCfKzvBHiddxVMTtcWw)
PURPLE & PINK GRADIENT IN HD [3 HOURS]

How to create linked drop-down lists in Excel with one formula

МЕЛОДРАМА КОТОРУЮ НЕВОЗМОЖНО ЗАБЫТЬ! ЛУЧШЕЕ КИНО НА ВЕЧЕР! «Катькино поле» СЕРИАЛ 2026

I gave Claude the financial statements. The results were surprising.

DeepSeek и Excel ➤ Используем Искусственный Интеллект для создания формул

Google Таблицы. Урок 37. Зависимые выпадающие списки. Функция indirect - ДВССЫЛ

9 Google Sheets Tools Everyone Should Know How to Use

Интерстеллар, центр за $1 000 000 000, мегалазер / вДудь

Как моделировать когорты в Excel? Простой вариант

Выпадающий список с пополнением

10 Images | Coastal Citrus Floral Summer Paintings Screensaver l Frame TV ART |

BEST Way to Organize Gmail Inbox

