
The drop-down consists of the following commands: The Merger & Centre feature concatenates the selected cells and puts the contents in a new cell in the centre position. The drop-down consists of the following commands:Ĩ. Accounting Number Format(Drop-Down)- The Accounting Number feature incorporates the ' default' number format to the selected cells. Comma Style- With the help of the Percent Style feature, you can incorporate the comma style number format into the selected cells.ħ. NOTE: The shortcut key to perform percent style in Excel is Ctrl + Shift + %.Ħ. Percent Style- With the help of the Percent Style feature, you can incorporate the percent number format into the selected cells. Decrease Font Size- This feature allows the Excel users to quickly decrease the font size of the selected cell to the previous smaller font size.ĥ. Increase Font Size- This feature allows Excel users to quickly increase the font size of the selected cell to the next larger font size.Ĥ. With the help of Font Size, you can quickly adjust the size of the text.ģ. The user can quickly select or change the font of the cell as per their choices.Ģ. Font Type(Drop-Down) - The Font feature shows the list of fonts available in Excel. The mini toolbar contains the most commonly used tools of the Home Tab.
You will notice that the Mini Toolbar disappears if you press any key from your keyboard or scroll the wheel of your mouse. If you take your mouse pointer away from the Mini Toolbar, it disappears. If you bring your mouse pointer towards the Mini Toolbar, it freezes and immediately becomes active. However, the toolbar commands are pre-defined and cannot be customized to include different other functions. The user can even turn off this feature if it is not required. In that case, they can turn it off (we will learn the steps to turn off Mini Toolbar later in this tutorial).įACT: Do you know that the Mini Toolbar feature is only available in the 20 versions of Word, Excel, PowerPoint, and Outlook. Sometimes the Excel users may find it annoying as it keeps getting in the way. If you hover your mouse pointer over it, it immediately converts to its solid and usable form. When you select any text or right-click on it, a faded, partially transparent pop window emerges on the top of your selected text. The Mini Toolbar is also available in other office applications such as Word and PowerPoint. The mini toolbar was introduced as a quick-access version so the Excel users can easily access the Font group, border, and few extra buttons on the Home tab. It is a small version of the full toolbar that displays commonly used formatting commands like Bold, Italics, Font Size and Font Color. The Mini Toolbar is a floating toolbar that appears above the shortcut menu when you right-click a cell or other objects like a shape or chart.