Excel Quick Tip: The Go To Special - Find Blanks Rows and Delete Them 🔲🚣♀️❌
Excel Quick Tip: The Go To Special - Find Blanks Rows and Delete Them 🔲🚣♀️❌
REGISTER FOR FREE SHORTCUTS COURSE: https://bit.ly/GETTIPS
Learn how to use shortcuts to find blank rows in Excel and delete them via a little-known tool in Excel called the, Go To Special. You will also learn how to use Excel shortcuts to find a specific word, and delete the rows containing that word in your Excel worksheets.
0:00 Start
00:43 Intro
01:39 Go to Special
02:23 Launches Go to Special
03:55 Select Blank Rows
04:45 Delete Rows
05:04 Insert Blank Rows
05:20 Sorting Details
06:55 Finding words and Remove
09:40 Shortcut of Find and Remove
FREE COURSE
🔥Learn Excel Shortcuts, Tips, and Tricks that will make you money. I call them "money moves!"
🔥What would it be like to create a chart by pressing one button?
🔥What would it be like to easily create a slicer-controlled pivot table with a chart in just minutes?
🔥Conditional Formatting, PivotTable Tips, Data Validation, Keyboard Shortcuts.
🔥And much more!🔥
REGISTER FOR FREE SHORTCUTS COURSE: https://bit.ly/GETTIPS
Let's keep on learning!
💪😃🌴
************************************************************
About Billy Wigley:
As a Microsoft Certified Trainer, Billy “Mr. Aloha” Wigley is a Microsoft Office Expert in Excel. After 5 years of actively traveling throughout the USA and other countries, leading public seminars teaching Excel skills to more than 65,000 professionals in over 100 cities, Billy became an online Premium Instructor in order to help even more Excel learners. With over 25 years of leadership experience, and from having resided in various cities worldwide, Billy Wigley is well-known around the world. With his strong USA and Colombian heritage, and many years residing in Hawaii, Billy Wigley takes pride in his multi-cultural background and being able to reach English, and Spanish speakers around the globe to share his Excel Aloha!
--Billy Wigley always says: "Don't Get Mad…Get Skills!"
************************************************************
#dontgetmadgetskills #clearformat #formatting #formattool