Microsoft Excel

FILE MENU

New (File menu)

Creates a new, blank file.

Open (File menu)

Opens or finds a file.

Close (File menu)

Closes the active file without exiting the program. If the file contains any unsaved changes, you will be prompted to save the file before closing. In Microsoft Word and Microsoft Excel, you can close all open files by holding down SHIFT and clicking Close All on the File menu.

Save (File menu)

Saves the active file with its current file name, location, and file format.

Save As (File menu)

Saves the active file with a different file name, location, or file format. In Microsoft Access, Microsoft Excel, and Word, you can also use this command to save a file with a password or to protect a file so that others cannot change its contents.

Save As Web Page (File menu)

Saves the file in HTML format (a Web page), so that it can be viewed in a Web browser, and sets other options such as the Web page title and location where the file will be saved.

Save Workspace

Saves a list of the open workbooks, their sizes, and their positions on the screen to a workspace file so that the screen will look the same the next time you open the workspace file.

Search

Finds files, Web pages, and Outlook items based on the search criteria you enter.

Web Page Preview

Allows you to preview the current file as a Web page in your browser so that you can see how it will look before publishing it.

Page Setup (File menu)

Sets margins, paper source, paper size, page orientation, and other layout options for the active file.

Set Print Area

Defines the selected range as the print area, which is the only portion of the worksheet that will be printed.

Clear/Reset Print Area

Deletes the print area in the active sheet.

Print Preview (File menu)

Shows how a file will look when you print it.

Print (File menu)

Prints the active file or selected items. To select print options, on the File menu, click Print.

Properties (File menu)

Displays the property sheet for the active file.

Exit (File menu)

Closes this program after prompting you to save any unsaved files.

EDIT MENU

Undo (Edit menu)

Reverses the last command or deletes the last entry you typed. To reverse more than one action at a time, click the arrow next the Undo button, and then click the actions you want to undo. The command name changes to Can't Undo if you cannot reverse the last action.

Redo

Reverses the action of the Undo command. To redo more than one action at a time, click the arrow next the Redo button, and then click the actions you want to redo.

Cut (Edit menu)

Removes the selection from the active document and places it on the Clipboard.

Copy

Copies the selection to the Clipboard.

Paste (Edit menu)

Inserts the contents of the Clipboard at the insertion point, and replaces any selection. This command is available only if you have cut or copied an object, text, or contents of a cell.  For special paste options, click the down arrow next to the button.

Paste Special (Edit menu) 

Pastes, links, or embeds the Clipboa

rd contents in the current file in the format you specify.

Paste as Hyperlink

Inserts the contents of the Clipboard as a hyperlink at the insertion point, replacing any selection. This command is available only if you have cut or copied the contents of a cell or data from another program.

FIL ---- Down

Copies the contents and formats of the topmost cells of a selected range into the cells below. To fill a selected range up instead of down, click Down on the Fill submenu of the Edit menu.

FIL ---- Right

Copies the contents and formats of the leftmost cell or cells of a selected range into the cells to the right. To fill the selection to the left instead of the right, click Right on the Fill submenu of the Edit menu.

FIL ---- Up

Copies the contents and formats of the bottom cell or cells of a selected range into the upper cells of the range. Copied contents and formats replace existing contents and formats.

FIL ---- Left

Copies the contents and formats of the rightmost cell or cells of a selected range into the cells to the left. Copied contents and formats replace existing contents and formats.

FIL ---- Series

Fills the selected range of cells with one or more series of numbers or dates. The contents of the first cell or cells in each row or column of the selection are used as the starting values for the series.

FIL ---- Justify

Redistributes the text contents of cells to fill the selected range. Numbers or formulas cannot be filled and justified. Except for the left column, cells in the range should be blank.

Clear All (Edit menu)

Removes all cell contents and formatting, including comments and hyperlinks, from selected cells.

Clear  Formats

Removes only the formatting from your selection; the content and comments are unchanged.

Clear  Contents

Removes the cell contents (data and formulas) from selected cells without affecting cell formats or comments.

Clear  Comments

Removes only the comments attached to selected cells; cell contents and formats are unchanged.

Delete

Removes the selected object. In Outlook, removes the selected item from the view and moves it to the Deleted Items folder.

Delete Sheet

Deletes the selected sheets from the workbook. You cannot undo this command.

Move or Copy Sheet

Moves or copies the selected sheets to another workbook or to a different location within the same workbook.

Find (Edit menu)

Searches selected cells or sheets for the characters you specify, and selects the first cell that contains those characters.

Replace

Searches for and replaces the specified text and formatting.

Go To (Edit menu)

In Microsoft Excel, scrolls through the worksheet and selects the cell, range, or cells with special characteristics you specify.

In Microsoft Word, moves the insertion point to the item you want to go to. You can move to a page number, comment, footnote, bookmark, or other location.

Links (Edit menu)

Displays or changes information for each link in the current file, including the name and location of the source file, the item, the type, and whether the link is updated automatically or manually. This command is unavailable if the current file contains no links to other files.

Edit Object

Activates the application in which the selected object was created so you can edit the object in place.

VIEW MENU

Normal

Switches to normal view, which is the default view for most tasks in Microsoft Excel, such as entering data, filtering, charting, and formatting.

Page Break Preview

Switches the active worksheet to page break preview, which is an editing view that displays your worksheet as it will print. In page break preview, you can move page breaks by dragging them left, right, up, or down. Microsoft Excel automatically scales the worksheet to fit the columns and rows to the page.

Formula Bar

Displays or hides the formula bar.

Status Bar

Shows or hides the status bar.

Header and Footer (View menu)

Adds or changes the text that appears at the top and bottom of every page or slide.

Comments (View menu)

In Word, displays all comments ¾ made by all reviewers ¾ in the comment pane.

In Microsoft Excel, turns display of comments on the worksheet on or off.

Custom Views

Creates different views of a worksheet. A view provides an easy way to see your data with different display options. You can display, print, and store different views without saving them as separate sheets.

Full Screen (View menu)

Hides most screen elements so that you can view more of your document. To switch back to your previous view, click  Full Screen or press ESC.

Zoom (View menu)

Controls how large or small the current file appears on the screen.

INSERT MENU

Insert Cells

Inserts cells starting at the insertion point. You can choose to shift other cells in the table to the right or down. You can also insert an entire row or column.

Insert Rows

Inserts the number of cells, rows, or columns you select. In Word, this command is available only when you've selected one or more end-of-cell marks.

Insert Columns (Table command)

Inserts the number of cells, rows, or columns you select. In Word, this command is available only when you've selected one or more end-of-cell marks.

Worksheet

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

Chart Wizard

Starts the Chart Wizard, which guides you through the steps for creating an embedded chart on a worksheet or modifying an existing chart.

Symbol (Insert menu)

Inserts symbols and special characters from the fonts that are installed on your computer.

Page Break

Inserts a page break above a selected cell. This command changes to Remove Page Break if you have a cell selected that is adjacent to a manually inserted page break.

Define

Creates a name for a cell, range, or constant or computed value that you can use to refer to the cell, range, or value.

Paste

Inserts the selected name into the formula bar. If the formula bar is active and you begin a formula by typing an equal sign (=), clicking Paste pastes the selected name at the insertion point. If the formula bar is not active, double-clicking a name in the Paste Name box pastes an equal sign (=) followed by the selected name into the formula bar.

Create

Creates names by using labels in a selected range.

Apply

Searches formulas in the selected cells and replaces references with names defined for them, if they exist.

Label

Uses predefined label ranges so that Microsoft Excel can automatically apply text labels to your formulas.

Comment

Inserts a comment at the insertion point.

Clip Art

Opens the Clip Gallery where you can select the clip art image you want to insert in your file or update your clip art collection. In PowerPoint, this command is available only in slide and notes views.

Picture From File (Insert menu)

Inserts an existing picture in the active file at the insertion point.

From Scanner or Camera

Loads an image by using a scanner or digital camera and then inserts the resulting picture at the insertion point.

AutoShapes Menu

Displays the AutoShape categories you can insert. Click an AutoShape category, click the AutoShape you want, and then click or drag in the active window where you want to insert the AutoShape. To draw an AutoShape that retains its default height-to-width ratio, hold down SHIFT while you drag.

Insert WordArt

Creates text effects by inserting a Microsoft Office drawing object.

Object (Insert menu) 

Inserts an object ¾ such as a drawing, WordArt text effect, or an equation ¾ at the insertion point.

Hyperlink

Inserts a new hyperlink or edits the selected hyperlink.

FORMAT MENU

Cells

Applies formats to the selected cells. This command might not available if the sheet is protected.

Row Height

Changes the height of the selected rows. You need to select only one cell in a row to change the height for the entire row. In Microsoft Excel, this command is not available if the worksheet is protected.

Row  AutoFit

Adjusts the row height to the minimum necessary to display the height of the tallest cell in the selection. If you change the  cell contents later, you must fit the selection again. This 

 command may not be available if the sheet is protected.

Row Hide

Hides the selected rows or columns. Hiding rows or columns

does not delete them from the worksheet.

Row Unhide

Displays rows or columns in the current selection that were previously hidden.

Column Width

Changes the width of the selected columns. You need to

select only one cell in a column to change the width for the entire column. In Microsoft Excel, this command is not

available if the worksheet is protected.

Column AutoFit Selection

Adjusts the column width to the minimum necessary to display the contents of the selected cells. If you change the cell

contents later, you must fit the selection again. This command might not be available if the sheet is protected.

Column  Hide

Hides the selected rows or columns. Hiding rows or columns does not delete them from the worksheet.

Column Unhide

Displays rows or columns in the current selection that were previously hidden.

Column Standard Width

Changes the standard width of columns on a worksheet. This command is not available if the sheet is protected.

Sheet Rename

Renames the active sheet.

Sheet Hide

Hides the active sheet. The sheet remains open and accessible to other sheets, but it is not visible

. You can't hide the only visible sheet in a workbook.

Sheet Unhide

Displays any hidden sheets.

Sheet Background

Inserts a tiled graphic image in the worksheet background, based on the bitmap you select.

AutoFormat (Format menu)

Applies a built-in combination of formats, called an autoformat, to a cell range or a PivotTable report. If a single cell is selected, Microsoft Excel automatically selects the range surrounded by blank cells and applies the autoformat to that range. If the selection is part of a PivotTable report, the entire table, except for the page fields, is selected and formatted. This command is not available if the sheet is protected.

Conditional Formatting

Applies formats to selected cells that meet specific criteria based on values or formulas you specify.

Style (Format menu)

Defines or applies to the selection a combination of formats, called a style.

Tools menu

Spelling (Tools menu)

Checks spelling in the active document, file, workbook, or item.

Speech (Tools menu)

Sets up and customizes speech recognition for dictating text, as well as selecting menu, toolbar, and dialog box items.

Shared Workbooks

Switches to shared workbook mode, which allows you and other users on your network to edit and save changes to the same workbook.

Highlight Changes

Highlights changes to cell contents in a shared workbook, including moved and pasted contents and inserted and deleted rows and columns.

Track Changes Accept or Reject Changes (Tools menu)

Finds and selects each tracked change in a document so that you can review, accept, or reject the change.

Merge Workbooks

Combines changes from multiple copies of a shared workbook into one workbook.

Protect Sheet

Prevents changes to cells on worksheets, items in a chart, graphic objects on a worksheet or chart sheet, or code in a Visual Basic Editor form.

Protect Workbook

Protects a workbook's structure and windows. You can prevent changes to the structure of a workbook so that sheets can't be deleted, moved, hidden, unhidden, or renamed, and new sheets can't be inserted. You can also protect windows from being moved or resized.

When the active document is protected, the command name changes to Unprotect Workbook.

Protect for Sharing

Protects the sharing and change history tracking in a shared workbook so the features can't be turned off. If you select this check box and click OK when the workbook isn't a shared workbook, you're asked if you want to save it as a shared workbook. In a workbook that's already shared, you can turn on protection for sharing and the change history, but you can't assign a password for this protection. To assign a password, you must first remove the workbook from shared use.

When the active shared workbook is protected, the command name changes to Unprotect for Sharing.

Goal Seek

Adjusts the value in a specified cell until a formula that is dependent on that cell reaches a target value.

Scenarios

Creates and saves scenarios, which are sets of data you can use to view the results of what-if analyses.

Trace Precedents

Draws tracer arrows from the cells that supply values directly to the formula in the active cell (precedents). To trace the cells that supply values indirectly to the formula in the active cell, click the Trace Precedents button again.

Trace Dependents

Draws a tracer arrow to the active cell from formulas that depend on the value in the active cell. To add additional levels of indirect dependents, click the Trace Dependents button again.

Remove All Arrows

Removes all tracer arrows from the worksheet.

Record New Macro

Records a series of actions as a macro that you can later "play back."

Macros

Opens the Macros dialog box, where you can run, edit, or delete a macro. Use Record New Macro     to record a series of actions as a macro, or click Visual Basic Editor to write a macro.

Add-Ins

Specifies which add-ins are automatically available when you start Microsoft Office. You can load or unload add-ins that come with Microsoft Office as well as add-in programs that you create.

AutoCorrect Options (Tools menu)

Sets the options used to correct text automatically as you type, or to store and reuse text and other items you use frequently.

Customize

Customizes toolbar buttons, menu commands, and shortcut key assignments.

Options (Tools menu)

Modifies settings for Microsoft Office programs such as screen appearance, printing, editing, spelling, and other options.

Data

Sort

Arranges the information in selected rows or lists alphabetically, numerically, or by date.

AutoFilter

The quickest way to select only those items you want to display in a list.

Advanced Filter

Filters data in a list so that only the rows that meet a condition you specify by using a criteria range are displayed.

Form

Displays a data form in a dialog box. You can use the data form to see, change, add, delete, and find records in a list or database.

Subtotals

Calculates subtotal and grand total values for the labeled columns you select. Microsoft Excel automatically inserts and labels the total rows and outlines the list.

Validation

Defines what data is valid for individual cells or cell ranges; restricts the data entry to a particular type, such as whole numbers, decimal numbers, or text; and sets limits on the valid entries.

Table

Creates a data table based on input values and formulas you define. Data tables can be used to show the results of changing values in your formulas.

Convert Text to Table

Converts the selected text to a table.                    

Consolidate

Summarizes the data from one or more source areas and displays it in a table.

Group

Defines the selected rows or columns of detail data as a group in an outline, so you can summarize the data. If you have not created an outline, this command creates one for you.

In a PivotTable or PivotChart report, this command groups items in a field to create a single item from multiple items; for example, you can group days, weeks, months, or other dates into quarters.

Ungroup

Removes selected rows or columns from a group on an outlined worksheet.

In a PivotTable or PivotChart report, this command separates each instance of a group into the items contained in the group; for example, it separates quarters into the original individual dates.

PivotTable and PivotChart Report

Starts the PivotTable and PivotChart Wizard, which guides you through creating or modifying a PivotTable or PivotChart report.

Window menu

New Window (Window menu)

Opens a new window with the same contents as the active window so you can view different parts of a file at the same time.

Arrange (Window menu)

Displays all open files in separate windows on the screen. The Arrange command makes it easier to drag between files.

Hide

Hides the active workbook window. A hidden window remains open.

Unhide

Displays hidden workbook windows.

Split (Window menu)

Splits the active window into panes, or removes the split from the active window.

Freeze Panes

Freezes the top pane, the left pane, or both on the active worksheet. Use the Freeze Panes button to keep column or row titles in view while you're scrolling through a worksheet. Freezing titles on a worksheet does not affect printing.

Help

Office Assistant

The Office Assistant provides Help topics and tips to help you accomplish your tasks.

Show or hide the Office Assistant

Displays or removes the Office Assistant from view.

What’s this

About Microsoft Program

Displays the version number of this Microsoft program; copyright, legal, and licensing notices; the user and organization name; the software serial number; and information about your computer and your operating system.

The END of MS EXCEL