HOME MENU IN EXCEL
Paste (Ctrl + V): This option is used to paste the last cut or copied text and object.
Cut (Ctrl + X): This option is used to cut selected text and object.
Paste Special (Ctrl + Alt + V): This option is used to paste only one content from a cell which contained multiple elements such as (Value, Format, Formula, Comment, etc.)
Borders: This tool is used to insert outline border in the selected cells.
Merge & Center: This tool is used to combine two or more cells in one cell and in this cells, by default text-align in the center.
Wrap Text: This option is used to adjust selected text size according to column size by increasing row size.
Conditional Formatting: This tool is used to highlight selected cells with help of different types of Color Scales, Data Bars, and Icon Sets that based on given criteria.
Format as Table: This tool is used to quickly format a range of selected cells and convert it to a table by choosing a pre-defined table style.
Cell Styles: This tool is used to insert a predefined format in selected cells.
Insert (Ctrl + (+): This option is used to insert Cell, Row, Column, and Worksheet.
Delete (Ctrl + (-): This option is used to delete a selected Cell, Row, Column or Worksheet.
Format: This tool is used to change the height of Row and Column, change default width of all column in selected worksheet, hide & unhide Row, Column, Sheet, change selected worksheet name, move or copy selected worksheet in another excel's book, change tab colour of selected worksheet, protect selected worksheet with desired password.
Clear: This tool is used to delete all contents from the selected cell or delete only content, format, comment, hyperlink from selected cells.
Sort: Sorting is a method that is used to arrange selected data items in ascending and descending order.
0 Comments