See all Microsoft Excel tipsStrategy:
1) Choose View – Toolbars – Customize. From the Toolbars tab, select New…, as shown in Fig. 119
2) Give the new toolbar a name, as shown in Fig. 120. You should probably only use Steve-O if your name is actually Steve.
3) As shown in Fig. 121, a new toolbar will appear without any icons. In the Customize dialog, choose the Commands tab. Drag any icon(s) you use regularly from the Commands tab to the new bar.
Additional Information: Consider some of these unusual but useful icons:
If you routinely paste formulas as values, the Paste Values icon (located in the Edit category) will speed up the process for you. See Fig. 122 below.
The Select Visible Cells icon will gather just the total lines when your subtotals are in Group mode. This icon will save you from choosing Edit – Go To – Special – Visible Cells only. It is located near the end of the Edit category, as shown in Fig. 123.
As shown in Fig. 124, selecting the Cycle Font Color icon will change the font to a different color with each click. If you just need your cells to be different colors but don’t want the burden of selecting the color, this is for you. This icon is located near the top of the Format category.
Choose Symbol from the Insert category if you routinely have to use unusual symbols. The icon provides a shortcut to the Symbol dialog. See Fig. 125.
As shown in Fig. 126, select Pivot Labels if you do a lot of pivot tables. This icon will select just the label areas of a pivot table for easy formatting. The icon is located halfway through the Data category.
Additional Information: Do you find it hard to remember the meanings of these icons? You can have descriptive text appear with any icon. While you are in Customize mode, right-click any icon in any toolbar. In the right-click menu, choose to always display Image and Text, as shown in Fig. 127.
The icon will appear with its text in the toolbar, as shown in Fig. 128. You can add text to any toolbar button using this method.
Additional Details: If you would like to send your custom toolbar along with the workbook, you can attach it to the workbook. On the Customize dialog, choose the Toolbars tab. Select the Steve-O toolbar and choose the Attach button, as shown in Fig. 129.
You can choose which custom toolbars should be attached to this workbook,
as shown in Fig. 130.
Summary: To create a tool bar that has the icons you use most, choose View – Toolbars – Customize.
Commands Discussed: View – Toolbars – Customize
