Look Who it Was Random video

Excel - Boost Your Excel Workflow with Tear-Off Palettes | Learn Excel Tips & Tricks - Episode 371

329 views · Published 29 October 2009 · 1:47 · Indexed 20 September 2026

Channel: MrExcel.com · 2009 · Education

Watch on YouTube

Microsoft Excel Tutorial: Boost Your Excel Workflow with Tear-Off Palettes | Learn Excel Tips & Tricks.

Welcome to another episode of MrExcel's Learn Excel series. In today's video, we're going to talk about a cool trick that has been around for a while but is often overlooked. It's called tear-off palettes and it's available on many of the toolbars in Excel.
If you open up a drop-down menu, such as the Font Color drop-down, you'll notice a row of dots at the top. By clicking on these dots, you can tear off the palette and float it above your spreadsheet. This allows you to have quick and easy access to the palette without having to constantly open and close it.
There are dozens and dozens of palettes that you can tear off, including the Fill Color palette. This is especially useful if you need to quickly change the fill color of multiple cells. Just tear off the palette, float it above your spreadsheet, and you can easily select a cell and change its color.
But it's not just limited to color palettes. All of the AutoShapes palettes are also tear-off palettes. This means you can float them above your spreadsheet and easily select and draw different shapes without having to constantly open and close the palette.
When you're done using the palette, simply click the X and it will disappear. This is a great time-saving trick that can make your Excel experience even more efficient. Thanks for watching and be sure to tune in for more helpful tips and tricks in our next netcast from MrExcel!"

Buy Bill Jelen's latest Excel book: https://www.mrexcel.com/products/latest/

You can help my channel by clicking Like or commenting below: https://www.mrexcel.com/like-mrexcel-on-youtube/


Table of Contents:
(00:00) Cool trick available on toolbars
(00:23) How to open and use drop-down menus
(00:33) Tearing off and floating palettes above spreadsheet
(00:43) Example with Fill Color palette
(00:56) Many different tear-off palettes available
(01:11) Great for creating or changing multiple AutoShapes
(01:21) How to use tear-off palettes effectively
(01:31) Clicking Like really helps the algorithm

#excel #microsoft #microsoftexcel #exceltutorial #exceltips #exceltricks #excelmvp #freeclass #freecourse #freeclasses #excelclasses #microsoftmvp #walkthrough #evergreen #spreadsheetskills #analytics #analysis #dataanalysis #dataanalytics #mrexcel #spreadsheets #spreadsheet #excelhelp #accounting #tutorial


This video answers these common search terms:
Easily select colors in Excel using tear-off palettes
Enhance your Excel workflow with tear-off palettes
Excel tip: Tear-off palettes for easy access to colors
Excel toolbar trick for tear-off palettes
Excel tutorial: Tear-off palettes for AutoShapes and fill colors
How to create and use tear-off AutoShapes palettes in Excel
How to float color palettes in Excel
Improve Excel efficiency with tear-off AutoShapes palettes
Increase productivity with tear-off palettes in Excel
MrExcel netcast tutorial on tear-off palettes in Excel
Save time in Excel with floating color palettes
YouTube video tutorial on floating palettes in Excel


Join the MrExcel Message Board discussion about this video at https://www.mrexcel.com/board/threads/1152711/


A little known trick in Office - how to force the dropdown pallettes from the toolbars to stay visible. Episode 371 shows you how.

This blog is the video podcast companion to the book, Learn Excel from MrExcel. Download a new two minute video every workday to learn one of the 277 tips from the book!

More from this channel