〽️ How to Record a Macro in Excel | Create a Highlight Shortcut
Want a highlight shortcut in Excel? While Excel doesn’t have a built-in shortcut to highlight cells, you can record a macro to make your own!
In this beginner-friendly tutorial, you’ll learn how to:
✅ Add the Developer tab in Excel
✅ Save as a Macro-Enabled Workbook
✅ Record your first Excel macro step by step
✅ Create a one-click shortcut to highlight cells any color you want
This is a great introduction to macros in Excel — helping you automate tasks and save time.
📖 What is a Macro?
“If you have tasks in Excel that you do repeatedly, you can record a macro to automate them. A macro is a set of actions that you can run as many times as you want.”
(Full guide: https://snip.ly/3cbgpe)
Timecodes:
0:00 - Intro
0:28 - Remove Highlight shortcut
0:46 - Highlighting
1:02 - How to Add the Developer Tab in the Ribbon
1:54 - Before you make a Macro
2:15 - Save As "Macro Enabled WorkBook"
2:46 - Recording a Macro
4:13 - Start Recording your Macro
5:36 - Test your Highlight Macro
📢 More Verdexes Excel Content
Compilation Video → • 2020 Compilation of Verdexes Video Clips |...
Instagram → / verdexes
Merch → https://teespring.com/stores/store-of...
#excel #exceltips #excelmacros #exceltutorial #excelpractice #spreadsheets #macro #excelshortcuts #excelhelp