Clipboard -:
1 Paste
2 Cut
3 Copy
4 Format Painter
Font -:
1 Font
2 Increase Font Size
3 Decrease Font Size
4 Bold (Clt+B)
5 Italic (Clt+I)
6 Underline(Clt+U)
7 Bottom Border
8 Fill Color
9 Font Color
Alignment -:
1 Top Align
2 Middle Align
3 Bottom Align
4 Align left
5 Align Center
6 Align Right
7 Orientation(Text Rotate)
8 Decrease Indent
9 Increase Indent
10 Wrap Text
11 Merge Center
Number -:
1 Number formate
2 Accounting Number Formate
3 Persent Style (Clt+shift+%)
4 Comma style
5 Increase Decimal
6 Decrease Decimal
Styles -:
1 Conditional Formatting
2 Format Table
3 Cell Styles
Cells -:
1 Insert
2 Delete
3 Format
Editing -:
1 AutoSum
2 Fill
3 Clear
4 Sort & Filter
5 Find & Select
Clipboard -: The Office Clipboard allows you to copy up to 24 items from Office documents or other programs and paste them into another Office document. For example, you can copy text from an email message, data from a workbook or datasheet, and a graphic from a presentation, and then paste them all into a document.
Clipboard -:
1 Paste
2 Cut
3 Copy
4 Format Painter
Font-: When you enter data in a worksheet, Excel automatically uses the Calibri font style in size11 but if you prefer a different font style or size, here's how you can change them: Select the cell or cell range that has the text or number you want to format.
Font
1 Font -: Pick a new font for your text.
2 Increase Font Size -: Change the size of your text increase.
3 Decrease Font Size -: Change the size of your text Decrease.
4 Bold (Clt+B) -: Make Your text Bold(Like Headline).
5 Italic (Clt+I) -: Italicize Your text.
6 Underline(Clt+U) -: You can your text In underline like Underline.
7 Bottom Border -: You can drow border on particular select cells.
8 Fill Color -: You can fill a color on a particular select cells.
9 Font Color -: You can fill a color on a particular select cells text.
Alignment-: To align your data horizontally, Microsoft Excel provides these options: Align Left - aligns the contents along the left edge of the cell. Center - puts the contents in the middle of the cell. Align Right - aligns the contents along the right edge of the cell
Alignment-:
1 Top Align -: Align the top of the element and its descendants with the top of the entire line.
2 Middle Align -: Align the bottom of the element and its descendants with the bottom of the entire line.
3 Bottom Align -: Aligns the middle of the element with the middle of lowercase letters in the parent.
4 Align left -: aligns the contents along the left edge of the cell.
5 Align Center -: puts the contents in the middle of the cell
6 Align Right -: aligns the contents along the right edge of the cell.
7 Orientation(Text Rotate) -: By default, Microsoft Excel prints worksheets in portrait orientation (taller than wide). You can change the page orientation to landscape on a worksheet-by-worksheet basis.
8 Decrease Indent -: Move Your Content Closer to the Cell Border
9 Increase Indent -: Move Your Content farther away From the Cell Border
10 Wrap Text -: "Wrapping text" means displaying the cell contents on multiple lines, rather than one long line
11 Merge Center -: Merge & Center is a feature in excel that combines multiple cells and centers the contents of the first cell.
Number -:
1 Number format -: You can use number formats to change the appearance of numbers, including dates and times, without changing the actual number.
2 Accounting Number Formate -: Accounting. Like the Currency format, the Accounting format is used for monetary values
3 Present Style (Clt+shift+%) -: Format as a Present
4 Comma style -: Comma is thousands separated
5 Increase Decimal -: Show more decimal places for a more precise value
6 Decrease Decimal -: Show fewer decimal places
Styles -:
1 Conditional Formatting -: Conditional formatting is a feature in many spreadsheet applications that allows you to apply specific formatting to cells that meet certain criteria. It is most often used as color-based formatting to highlight, emphasize, or differentiate among data and information stored in a spreadsheet.
2 Format Table -: When you use Format as Table, Excel automatically converts your data range to a table. If you don't want to work with your data in a table, you can convert the table back to a regular range while keeping the table style formatting that you applied.
3 Cell Styles -: A cell style is a defined set of formatting characteristics, such as fonts and font sizes, number formats, cell borders, and cell shading
Cells -:
1 Cell Insert -: Right-click the cell above which you want to insert a new cell.
Select Insert, and then select Cells & Shift Down.
2 Cell Delete -: If you want to remove cells from the worksheet and shift the surrounding cells to fill the space, you can select the cells and delete them. On the Home tab, in the Cells group, click the arrow next to Delete, and then click Delete Cells.
3 Cell Format -: Cell formats allow you to change the way cell data appears in the spreadsheet. It is important to keep in mind that it only alters the way the data is presented, and does not change the value of the data. ... Formatting also allows you to set font, background color, and borders for selected cells.
Editing -:
1 AutoSum -: When you click AutoSum, Excel automatically enters a formula (that uses the SUM function) to sum the numbers.
2 Fill -: Excel's Fill command lets you fill an adjacent group of cells with the same text or numbers, or with text or numbers that form a series. ... Both require you to first highlight a range of cells, starting will the cell containing the text or numbers you want copied to the other cells.
3 Clear -: If you click a cell and then press DELETE or BACKSPACE, you clear the cell contents without removing any cell formats or cell comments
4 Sort & Filter -: Filter data in a range or table. Excel is an amazing tool for analyzing data. And Sort and Filter are some of the most commonly used features to help you do this.
5 Find & Select -: Excel Find and Select is a feature that enables you to quickly find specific text, and to replace it with other text.
Post a Comment
If you have any doubts. Please Let me Know