Microsoft Excel Home Tab

 

                          MS Excel

HOME:

Clipboard:

Cut: 

cut the section from the document and put it on the clipboard.

Copy: 

copy the section and put it on the clipboard.

Paste:

 Click here for more options such as pasting only the values or formatting.

Format painter:

 copy formatting from one place and apply it to another.

Font:

Font: change the font face.

Font size: 

change the font size.

Bold:

 make the selected text Bold.

Italic:

italicize the selected text.

Underline: 

under the line selected text.

Bottom border:

 apply border to the currently selected cells.

Fill color:

 color the background of selected cells.

Increase font:

 increase the font size.

Decrease font: 

decrease the font size.

Alignment:

Top:

 align text to the top of the cells.

Middle: 

align text so that it centered between the top and bottom of the cell.

Bottom:

 align text to the bottom of the cell.

Align text left: 

align text to the left.

Centre:

 centre text.

Align text right:

 align text to the right.

Orientation: 

rotate text to a diagonal angle or vertical orientation. This is often used for loading narrow columns.

Wrap text:

 make all content visible within a cell by displaying it on multiple lines.

Merge and centre: 

join the selected cells into one large cell and centre of the contents in the new cells.

Number:

Number format:

 choose how the values in a cell are displayed; as a percentage, as currency, as a date or time etc.

Accounting number format:

 choose an alternate currency format for the selected cell.

Percentage stlye:

 display the value of the cell as a percentage.

Comma style:

 display the value of the cell with a thousand separator.

Increase decimal:

 show more precise value by showing more decimal places.

Decrease decimal:

 show less precise value by  showing fewer decimal places.

Style:

Conditional formatting:

 highlight interesting cells, emphasize unusual value and visualize data using data bars color scales and icon sets based on criteria.

Format as table:

 quickly format a range of cells and convert it to a table by choosing a predefined table style.

Cells style:

 quickly format a cell by choosing form predefined styles.

Cells:

Insert: click here to insert cells, rows or column into the sheet or table or to add a sheet of the workbook.

Delete:

 delete rows and columns from the table or sheet change the row height or columns, width, organize sheet or protect or hide cells.

Editing:

Auto sum:

 display the sum of the selected cells directly after the selected cells.

Fill:

 continue a pattern into one or more adjacent cells.

Clear: 

delete everything from the cells, or selectively remove the formatting the contents, or the comments.

Sort and filter:

 arrange data so that it is easier to analyze. Find and select specific text, formatting or type of information with in the workbook.