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.
FILE:
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.
EDIT:
DOWN/RIGHT/UP/LEFT

Copies the contents and formats of the various sides.
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.
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/CONTENTS
Removes all cell contents and formatting, including comments and hyperlinks, from selected cells.
FORMATS
Removes only the cell formats from selected cells; cell contents and comments are unchanged.
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.
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.
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.
INSERT:
INSERT CELLS
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 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.
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.
PASTE FUNCTION
Displays a list of functions and their formats and allows you to set values for arguments.
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.
MAP
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.
FORMAT Cells
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.
Sheet
Rename

Renames the active 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.
Background
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.
Style
Defines or applies to the selection a combination of formats, called a style.
TOOLS
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.
Protection:
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.
Scenarios
Creates and saves scenarios, which are sets of data you can use to view the results of what-if analyses.
Auditing:
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.
Add-Ins
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.
DATA:
Sort
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.
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 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.
Consolidate
Summarizes the data from one or more source areas and displays it in a table.
Group and outline:
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 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.
Ungroup
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.
[ratings]

Related posts