Topics

Mar 3, 2011

Show or hide the mini toolbar in Excel 2007

If you select some text in a cell then by default a mini toolbar appears that allows you to change the font, font size, color of text, apply the bold, italic or underline style within the worksheet area. If you feel this is an annoying feature then you can turn off the mini toolbar. Also, you can turn it on again. Perform the following steps to show or hide the mini toolbar:
1. Open Microsoft Excel.
2. Click the Microsoft Office Button and click Excel Options.
3. From the Excel Options dialog box, click Popular from the left pane.
4. From the right pane, under Top options for working with Excel, do one of the following:
  • To hide the mini toolbar, click to remove the checkmark besides Show Mini Toolbar on selection.
  • To show the mini toolbar, click to place a checkmark besides Show Mini Toolbar on selection.
5. Click OK.

Note:
If the Show Mini Toolbar on selection option is turned on or off, the mini toolbar will still appear if you right click on a cell or on the selected text.

0 comments:

Post a Comment