Загрузка...

⚡Instantly Capitalize All Letters in Excel in 60 Seconds! (Must-See Trick) 🚀

FULL SIZE HORIZONTAL VIDEO: https://www.youtube.com/watch?v=Uxnz-Th-Tk0&pp=0gcJCYcKAYcqIYzv

Learn how to instantly convert lowercase text to ALL CAPS in Excel using the UPPER formula — no manual retyping needed!

In this video you'll learn:
✅ How to use the UPPER() function in Excel
✅ How to auto-fill the formula for all rows
✅ How to make the data static (not dynamic) using Paste as Values
✅ How to clean up your sheet when done

Works in Excel 365, 2021, 2019, 2016 and Google Sheets!

---
⏱️ TIMESTAMPS
0:00 – The problem: names stuck in lowercase
0:05 – Typing the UPPER formula in column B
0:12 – Hitting Enter and seeing it work
0:17 – Auto-filling the formula for all rows
0:25 – How dynamic data updates work
0:35 – Making data static with Paste as Values
0:48 – Deleting column B and you're done!

---
🔔 If this saved you time, like & subscribe for more quick Excel tips!

#Excel #ExcelTips #MicrosoftExcel #ExcelShorts #SpreadsheetTips #ExcelFormula #UPPER #ExcelForBeginners #Shorts #TechTips

Видео ⚡Instantly Capitalize All Letters in Excel in 60 Seconds! (Must-See Trick) 🚀 канала Electronixzone
Яндекс.Метрика
Все заметки Новая заметка Страницу в заметки
Страницу в закладки Мои закладки
На информационно-развлекательном портале SALDA.WS применяются cookie-файлы. Нажимая кнопку Принять, вы подтверждаете свое согласие на их использование.
О CookiesНапомнить позжеПринять