Look Who it Was Random video

Excel - Master the Mini Toolbar in Excel | Excel Tutorial - Episode 413

214 views · Published 29 September 2009 · 2:28 · Indexed 20 September 2026

Channel: MrExcel.com · 2009 · Education

Watch on YouTube

Microsoft Excel Tutorial:  Master the Mini Toolbar in Excel | Excel Tutorial.

Welcome to the first MrExcel netcast of 2007! This year is going to be an exciting one for Excel fans, with the release of Excel 2007 on January 30th. As always, I'll be sharing new Excel tricks every Tuesday and Thursday, and today we're diving into the Mini Toolbar.

The Mini Toolbar is a handy feature that can be found in Word, PowerPoint, and Excel. However, it can be a bit tricky to get it to work in Excel. Whenever you select data in Excel, the Mini Toolbar is available, but it starts off completely invisible. To make it appear, you have to select the text and then move your mouse pointer up and to the right.

This can be frustrating for those of us who have learned to select text from the end and drag to the left. In this case, the Mini Toolbar never shows up. But fear not, there is a solution! After selecting the text, simply move your mouse up and to the right to reveal the Mini Toolbar. This toolbar contains all the formatting options that used to be found on the formatting toolbar, making it quick and easy to change the color, font, size, and more.

Just remember, if you move too far away from the selected text, the Mini Toolbar will fade away. But don't worry, you can always bring it back by moving your mouse back towards the text. And if you select a cell and right-click, the Mini Toolbar will also appear, allowing you to format the entire cell. This feature may be more commonly used in Word and PowerPoint, but it can still be a useful tool in Excel, especially when working with charts.

Thanks for tuning in to today's netcast, and be sure to join me tomorrow for another Excel tip from MrExcel. Don't forget to subscribe to our channel for more helpful Excel tutorials. See you next time!

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) Today's topic: Mini Toolbar in Excel
(00:21) Mini Toolbar available in Word, PowerPoint, and Excel
(00:31) Steps to access Mini Toolbar
(00:41) Mini Toolbar starts out invisible
(00:51) Annoyance with selecting text and Mini Toolbar not appearing
(01:02) Solution to make Mini Toolbar appear
(01:12) Features available on Mini Toolbar
(01:30) Mini Toolbar disappears after moving away from text
(01:46) Mini Toolbar also available by right-clicking on cell
(02:07) 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:
Changing color, font, and size with the Mini Toolbar
Excel 2007 tricks
Formatting cells with the Mini Toolbar
Formatting options in the Mini Toolbar
Making the Mini Toolbar visible
Mini Toolbar in charts
Mini Toolbar in Word, PowerPoint, and Excel
Moving the mouse pointer up and to the right
Re-selecting text to bring back the Mini Toolbar
Selecting text in Excel
Using the format painter with the Mini Toolbar

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



Get quick access to all of the text formatting commands by moving your mouse towards the completely invisible mini toolbar! (Who at Microsoft comes up with this stuff?) Episode 413 shows you how to get the shy mini toolbar to appear.

This blog is the video netcast companion to the upcoming book, Excel 2007 Miracles Made Easy. Download a new two minute video every Tuesday and Thursday to learn one of the tips from the book!

More from this channel