Built-in Buttons

The following table lists the built-in buttons alphabetically. The face of each button is shown along with its default action, the category from which the button is selected, and its identifying number for use with Visual Basic. For more information about a built-in button, display the toolbar on which it appears, click the Help button on the Standard toolbar, and then click the toolbar button.

Button

Action

Category

Number

3-D Area Chart AutoFormat

Creates a 3-D area chart with 3-D markers.

Charting

109

3-D Bar Chart AutoFormat

Creates a bar chart with 3-D markers.

Charting

110

3-D Column Chart AutoFormat

Creates a column chart with 3-D markers.

Charting

111

3-D Line Chart AutoFormat

Creates a 3-D line or ribbon chart.

Charting

113

3-D Perspective Column Chart AutoFormat

Creates a 3-D column chart with a 3-D plot area.

Charting

112

3-D Pie Chart AutoFormat

Creates a 3-D pie chart with value labels expressed as percentages.

Charting

114

3-D Surface Chart AutoFormat

Creates a 3-D surface chart.

Charting

116

Align Left

Aligns the cell, text box, button contents, or selected text in a chart to the left.

Text Formatting

Align Right

Aligns the cell, text box, button contents, or selected text in a chart to the right.

Text Formatting

Arc

Displays a cross-hair pointer you use to draw an arc, or a segment of a circle.

Drawing

Area Chart AutoFormat

Creates a simple area chart.

Charting

103

Arrow

Displays a cross-hair pointer you use to draw an arrow on the active worksheet or adds an arrow to the active chart document.

Drawing

Attach Note

Adds a note to the current selection.

Auditing

154

AutoFilter

Displays only those rows that match the value contained in the active cell and inserts drop-down arrows next to each column label in your list.

Data

168

AutoFormat

Applies the last table format you set.

Formatting

AutoSum

Inserts the SUM function and a proposed sum range based on the data above or to the left of the active cell.

Utility

Bar Chart AutoFormat

Creates a simple bar chart.

Charting

104

Bold

Applies bold formatting to the selected cells or objects.

Text Formatting

Borders

Displays the Borders palette so that you can apply borders to the selection.

Formatting

198

Bottom Border

Adds or removes a border along the lower edge of cells.

Formatting

Bottom Double Border

Adds or removes a double border below cells.

Formatting

Bring To Front

Places the selected objects in front of all other objects.

Drawing

Calculate Now

Calculates the formulas in all the open documents or the formula in the formula bar.

Utility

126

Camera

Copies a picture of the selected range of cells. Click on the worksheet to paste the picture and link the picture to the source cells.

Utility

125

Center

Centers the cell, text box, button contents, or selected text in a chart.

Text Formatting

Center Across Columns

Centers the text from one cell horizontally across the selected columns.

Text Formatting

Chart Type

Displays the Chart Type palette so that you can change a chart's type.

Charting

234

ChartWizard

Starts the ChartWizard so that you can edit the selected chart or create an embedded chart.

Charting

121

Check Box

Creates a check box control.

Forms

140

Clear Contents

Removes only the formulas or values from the selected cells or deletes the selected objects.

Edit

Clear Formats

Removes only the formats from the selected cells or objects.

Edit

Colon

Inserts a colon in the formula bar.

Formula

Color

Displays the color palette you use to assign a color to the selected object.

Drawing

233

Column Chart AutoFormat

Creates a simple column chart.

Charting

105

Combination Drop-Down Edit

Creates a combination drop-down edit control.

Forms

197

Combination List-Edit

Creates a list box control linked to an edit control.

Forms

188

Comma

Inserts a comma in the formula bar.

Formula

Comma Style

Applies a comma style to the selected cells.

Formatting

Constrain Numeric

Constrains pen recognition to digits and punctuation.

Formula

Control Properties

Changes control properties.

Forms

238

Copy

Copies the selection to the Clipboard.

Edit

Create Button

Displays a cross-hair pointer you use to draw a button to which you assign a procedure or a Microsoft Excel 4.0 macro.

Drawing, Utility

Currency Style

Applies a currency style to the selected cells.

Formatting

Cut

Cuts the selection and places it on the Clipboard.

Edit

Cycle Font Color

Changes the color of fonts in selected objects.

Text Formatting

Dark Shading

Applies dark shading to selected cells or objects.

Drawing

Decrease Decimal

Removes one decimal place from a number format.

Formatting

Decrease Font Size

Decreases the font size of the selected text to the next smaller size in the Font Size box.

Text Formatting

Default Chart

Creates a chart using the default chart type set on the Chart tab in the Options dialog box.

Charting

120

Delete

Removes the selected cells or objects. If you delete cells, using the Delete button shifts the surrounding cells to fill in the space.

Edit

Delete Column

Deletes the selected column.

Edit

Delete Row

Deletes the selected row.

Edit

Division Sign

Inserts a slash in the formula bar.

Formula

Dollar Sign

Inserts a dollar sign in the formula bar.

Formula

Double Underline

Applies double underlining to the selected cells or objects.

Text Formatting

176

Doughnut Chart AutoFormat

Creates a doughnut chart.

Charting

145

Drawing

Displays or hides the Drawing toolbar.

Drawing

240

Drawing Selection

Displays a cross-hair pointer you use to select drawing objects.

Drawing

184

Drop Shadow

Adds a shadowed rectangle around the selected cells or adds a shadow to the border of the selected objects.

Drawing

Drop-Down

Creates a drop-down control.

Forms

182

Edit Box

Creates an edit control.

Forms

142

Edit Code

Goes to an object macro, or creates a new macro if none exists.

Forms

244

Ellipse

Displays a cross-hair pointer you use to draw an ellipse or a circle.

Drawing

Equal Sign

Inserts an equal sign in the formula bar.

Formula

Exponentiation Sign

Inserts an exponent sign in the formula bar.

Formula

Fill Down

Copies the values, formulas, and formats of the cells in the top row of the selection into the cells below. To copy from the bottom row upward, hold down SHIFT and click this button.

Edit

Fill Right

Copies the values, formulas, and formats of the cells in the left column of the selection into the cells to the right. To copy from the right column to the left, hold down SHIFT and click this button.

Edit

Filled Arc

Displays a cross-hair pointer you use to draw an arc or a circle segment filled with the window background pattern and color.

Drawing

Filled Ellipse

Displays a cross-hair pointer you use to draw an ellipse or a circle filled with the window background pattern and color.

Drawing

Filled Freeform

Displays a cross-hair pointer you use to draw a polygon that's a combination of freehand and straight lines filled with the window background pattern and color.

Drawing

Filled Polygon

Displays a cross-hair pointer you use to draw a polygon filled with the window background pattern and color.

Drawing

Filled Rectangle

Displays a cross-hair pointer you use to draw a rectangle or square filled with the window background pattern and color.

Drawing

Find File

Displays the Find File dialog box so that you can search for files by attribute.

File

177

Font

Lists the available fonts. Select the font you want to apply to the current selection.

Text Formatting

Font Color

Displays a palette of colors you can use to change the font color in selected cells or the font color of selected text.

Text Formatting

236

Font Size

Lists the available sizes for the font shown in the Font box. Select the size you want to apply to the current selection.

Text Formatting

Format Painter

Copies formats from one selection to another.

Edit

185

Freeform

Displays a cross-hair pointer you use to draw a shape that's a combination of freehand and straight lines.

Drawing

Freehand

Displays a cross-hair pointer you use to draw a continuous freehand line.

Drawing

Freeze Panes

Freezes or unfreezes the split in the active window; if no split exists, splits the window above and to the left of the active cell and freezes the panes.

Utility

137

Full Screen

Toggles full-screen display.

Utility

241

Function Wizard

Displays the Function Wizard so that you can insert a function into the selected cells.

Macro, Utility

Group

Defines the selected detail rows or columns as a group. In a PivotTable, groups items by category to create a single item from multiple items.

Data

130

Group Box

Creates a group box control.

Forms

181

Group Objects

Joins the selected graphic objects together as a single graphic object.

Drawing

Help

Adds a question mark to the mouse pointer. When you choose a command or click a screen region, a Help topic on that item is displayed. Click this button again to cancel the question mark. Double-click this button to display Help Topics dialog box.

Utility

128

Hide Detail

Hides details of the selection.

Data

175

Horizontal Gridlines

Adds or deletes major gridlines for the value axis.

Charting

122

Increase Decimal

Adds one decimal place to a number format.

Formatting

Increase Font Size

Increases the font size of the selected text to the next larger size in the Font Size box.

Text Formatting

Insert

Inserts blank cells in place of the current selection.

Edit

Insert Chart Sheet

Inserts a new chart sheet into the active workbook.

File

Insert Column

Inserts entire columns in the location of the current selection.

Edit

Insert Dialog

Inserts a new dialog sheet to the left of the selected sheet.

File

245

Insert Module

Inserts a new module into the active workbook.

File, Macro

190

Insert MS Excel 4.0 Macro

Inserts a new Microsoft Excel 4.0 macro sheet into the active workbook.

File

Insert Row

Inserts entire rows in the location of the current selection.

Edit

Insert Worksheet

Inserts a new worksheet into the active workbook.

File

Instant Watch

Displays the value of the selected expression.

Macro

194

Italic

Applies italic formatting to the selected cells or objects.

Text Formatting

Justify Align

Increases word spacing in a text box, button, or cell with wrapped text to fill each line.

Text Formatting

Label

Creates a dialog label.

Forms

199

Left Border

Adds or removes a border along the left edge of the selection.

Formatting

Left Parenthesis

Inserts an opening parenthesis in the formula bar.

Formula

Legend

Adds or deletes a chart legend.

Charting

124

Light Shading

Applies light shading to selected cells or objects.

Drawing

Line

Displays a cross-hair pointer you use to draw a straight line.

Drawing

Line Chart AutoFormat

Creates a line chart with markers.

Charting

107

Line/Column Chart AutoFormat

Creates a combination chart with a column chart overlaid by a line chart.

Charting

118

List Box

Creates a list box control.

Forms

144

Lock Cell

Formats the selected cells or objects as locked so that no changes can be made to them when the document is protected.

Utility

136

Menu Editor

Displays the Menu Editor dialog box so that you can change menu bars and commands.

Macro

192

Microsoft Access

Starts Microsoft Access, or switches to it if it's already running.

Utility

216

Microsoft FoxPro

Starts Microsoft FoxPro, or switches to it if it's already running.

Utility

160

Microsoft Mail

Starts Microsoft Mail, or switches to it if it's already running.

Utility

203

Microsoft PowerPoint

Starts Microsoft PowerPoint, or switches to it if it's already running.

Utility

204

Microsoft Project

Starts Microsoft Project, or switches to it if it's already running.

Utility

205

Microsoft Schedule+

Starts Microsoft Schedule+, or switches to it if it's already running.

Utility

227

Microsoft Word

Starts Microsoft Word, or switches to it if it's already running.

Utility

202

Minus Sign

Inserts a minus sign in the formula bar.

Formula

Multiplication Sign

Insers an asterisk in the formula bar.

Formula

New Workbook

Creates a new workbook.

File

Object Browser

Displays procedures, objects, methods, and properties.

Macro

191

Open

Displays the Open dialog box so that you can open an existing document.

File

Option Button

Creates an option button control.

Forms

141

Outline Border

Adds a border around the outer edge of the selected cells.

Formatting

Paste

Pastes the contents of the Clipboard.

Edit

Paste Formats

Pastes only the formats from the copied cells into the selected cells.

Edit

Paste Names

Displays the Paste Names dialog box so that you can paste worksheet names into the selected cells.

Macro, Utility

Paste Values

Pastes only the values from the copied cells into the selected cells.

Edit

Pattern

Displays a palette of patterns and pattern colors you can apply to filled objects.

Drawing

232

Percent Sign

Inserts a percent sign in the formula bar.

Formula

Percent Syle

Applies a percent style to the selected cells.

Formatting

Pie Chart AutoFormat

Creates a pie chart with value labels expressed as percentages.

Charting

108

PivotTable Field

Inserts a subtotal for a row field or column field in an existing PivotTable. If you select a cell in the data area, clicking this button defines the summary functions used in the selected data field.

Data

171

PivotTable Wizard

Starts the PivotTable Wizard, which guides you through all the steps needed to create or modify a PivotTable.

Data

167

Plus Sign

Inserts a plus sign in the formula bar.

Formula

Polygon

Displays a cross-hair pointer you use to draw a polygon.

Drawing

Prints the active sheet according to the current page setup and print settings.

File

Print Preview

Displays the active sheet in print preview.

File

Radar Chart AutoFormat

Creates a radar chart with markers.

Charting

117

Record Macro

Records actions to create a procedure.

Macro

Rectangle

Displays a cross-hair pointer you use to draw a rectangle or square.

Drawing

Refresh Data

Updates the data in a PivotTable after the source data is changed.

Data

170

Remove All Arrows

Removes all arrows used in auditing.

Auditing

153

Remove Dependent Arrows

Removes one level of arrows tracing dependent cells.

Auditing

147

Remove Precedent Arrows

Removes one level of arrows tracing precedent cells.

Auditing

149

Repeat

Repeats the last action or command.

Edit

Reshape

Changes the shape of a polygon.

Drawing

Resume Macro

Resumes running a paused procedure.

Macro

102

Right Border

Adds or removes a border along the right edge of the selection.

Formatting

Right Parenthesis

Inserts a closing parenthesis in the formula bar.

Formula

Rotate Text Down

Rotates text sideways so that it reads from top to bottom.

Text Formatting

Rotate Text Up

Rotates text sideways so that it reads from bottom to top.

Text Formatting

Routing Slip

Adds a routing slip to the current workbook.

Workgroup

162

Run Dialog

Runs the current dialog box.

Forms

187

Run Macro

Runs the procedure you're editing, starting at the insertion point.

Macro

100

Save

Saves changes made to the active workbook.

File

Scenarios

Adds, displays, or edits scenarios.

Utility

166

Scroll Bar

Creates a scroll bar control.

Forms

143

Select Current Region

Selects a rectangular range of cells around the active cell that's bounded by blank rows and columns.

Utility

133

Select Visible Cells

Selects only the visible cells in a selection and none of the hidden rows or columns.

Utility

132

Selection

Selects graphic objects by drawing a selection rectangle around them.

Drawing

Send Mail

Sends mail using the mail system you're connected to.

Workgroup

163

Send To Back

Places the selected objects behind all other objects.

Drawing

Set Print Area

Sets the selected cells as the area to print.

File

Shape

Displays a palette of drawing shapes.

Drawing

235

Show Detail

Shows details of the selection.

Data

173

Show Info Window

Displays the Info window.

Auditing

243

Show Outline Symbols

Displays or hides the outlining symbols on a worksheet containing an outline; if no outline exists, displays a message asking whetheryou want to create one.

Utility

131

Show Pages

Copies each page of a page field to a new worksheet in the current workbook.

Data

172

Sort Ascending

Sorts the current list in order from the lowest value to the highest value, using the column that contains the active cell.

Data, Utility

134

Sort Descending

Sorts the current list in order from the highest value to the lowest value, using the column that contains the active cell.

Data, Utility

135

Spelling

Starts checking the spelling of the active document or the text in the formula bar.

Utility

127

Spinner

Creates a spinner control.

Forms

183

Stacked Column Chart AutoFormat

Creates a stacked column chart.

Charting

106

Step Into

Executes the next statement by stepping into the procedure.

Macro

195

Step Macro

Runs the procedure you're editing one statement at a time, starting at the insertion point.

Macro

101

Step Over

Runs the next statement by stepping over the procedure.

Macro

196

Stop Macro

Stops the currently running procedure. If the macro recorder is running, clicking this button stops the macro recorder.

Macro

Strikethrough

Applies strikethrough formatting to the selected cells or objects.

Text Formatting

Style

Lists the defined cell styles. Select the style you want to apply to the current selection.

Text Formatting

Tab Order

Changes the tab order of controls.

Forms

186

Text Box

Displays a cross-hair pointer you use to draw a text box, in which you can type text.

Drawing, Utility

TipWizard

Indicates when a tip is available and displays the TipWizard toolbar.

TipWizard

179

TipWizard box

Displays the current tip. Using this box, you can scroll through a list of tips.

TipWizard

178

Toggle Breakpoint

Sets or clears breakpoints.

Macro

193

Toggle Grid

Toggles gridlines on and off.

Forms

239

Toggle Read Only

Switches between read-only and read-write status.

Workgroup

165

Top Border

Adds or removes a border along the upper edge of cells.

Formatting

Trace Dependents

Shows the cells that depend on the current cell.

Auditing

148

Trace Error

Shows the cell or cells that are causing the error in the current cell.

Auditing

174

Trace Precedents

Shows the cells that the current cell depends on.

Auditing

242

Underline

Applies underlining to the selected cells or objects.

Text Formatting

Undo

Undoes the last action or command.

Edit

Ungroup

Removes selected rows or columns from their group. In a PivotTable, separates a combined group of items, replacing each instance of the group with all the items it contained.

Data

129

Ungroup Objects