Microsoft Excel All Options Full Explained

In MS-Excel, the files are called Spreadsheets. We can open multiple sheets at time. The options are stored in MENUS. When you click on a particular menu, it gives a drop – down list box of menu options.

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

Copies the contents and formats of the various sides.
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.
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.
Removes all cell contents and formatting, including comments and hyperlinks, from selected cells.
Removes only the cell formats from selected cells; cell contents and comments are unchanged.
Removes only the comments attached to selected cells; cell contents and formats are unchanged.
Removes the selected object. In Outlook, removes the selected item from the view and moves it to the Deleted Items folder.
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.
Switches to normal view, which is the default view for most tasks in Microsoft Excel, such as entering data, filtering, charting, and formatting.
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.
Displays or hides the formula bar.
Shows or hides the status bar.
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.
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.
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.
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.
Inserts a new worksheet to the left of the selected sheet.
Starts the Chart Wizard, which guides you through the steps for creating an embedded chart on a worksheet or modifying an existing chart.
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.
Displays a list of functions and their formats and allows you to set values for arguments.
Creates a name for a cell, range, or constant or computed value that you can use to refer to the cell, range, or value.
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.
Creates a map based on the selected data. The data should contain geographic references, such as abbreviations of countries or states. To set the location and size of the map on your worksheet, drag the cross hair.
Object (Insert menu)
Inserts an object ¾ such as a drawing, Word Art text effect, or an equation ¾ at the insertion point.
Insert / Edit Hyperlink
Inserts or edits the hyperlink you specify.
Applies formats to the selected cells. This command might not available if the sheet is protected.
Row / Column
To auto fit, increase or decrease the size of the row / column.

Renames the active sheet.

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.
Inserts a tiled graphic image in the worksheet background, based on the bitmap you select.
Auto Format
Applies a built-in combination of formats, called an auto format, to a cell range or a Pivot Table If a single cell is selected, Microsoft Excel automatically selects the range surrounded by blank cells and applies the auto format to that range. If the selection is part of a Pivot Table 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.
Defines or applies to the selection a combination of formats, called a style.
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.
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 re-sized.
When the active document is protected, the command name changes to Unprotected 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.
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.
Specifies which add-ins are available automatically when you start Microsoft Excel. You can load or unload add-ins that come with Microsoft Excel as well as add-in programs that you create.
Arranges the information in selected rows or lists alphabetically, numerically, or by date.
Auto Filter
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.
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.
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.
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.
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 Columns (Data Menu)
Separates text in one cell on a worksheet into columns by using the Convert Text to Columns Wizard. The Convert Text to Columns Wizard helps you specify how you want the text divided into columns using a separator or delimiter, such as tabs or commas.
Summarizes the data from one or more source areas and displays it in a table.
Group and outline:
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 Pivot Table this command groups items by category to create a single item from multiple items; for example, you can group days, weeks, months, or other dates into quarters for analysis, charting, or printing.
Removes selected rows or columns from a group on an outlined worksheet.
In a Pivot Table 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.
Pivot Table Report
Starts the Pivot Table Wizard, which guides you through creating or modifying a Pivot Table.

Hope this data is useful for all. So, help us by sharing it.
Rate this post below.

Related posts