What is the use of Home Tab in Microsoft Excel?

Home Tab in Microsoft Excel

Home Tab in Microsoft Excel is the default tab for editing and formatting a worksheet or workbook. The ribbon of Home Tab is divided in to multiple sections with the name Clipboard, Font, Alignment, Number, Styles, Cells and Editing. Detailed explanation about Home Tab in Microsoft Excel is given below.

Clipboard

• Cut (ctrl+x) – This option is use to cut the selected data.
• Copy (ctrl+c) – This option is use to copy the selected data.
• Paste (ctrl+v) – Basically this option is use to paste the cut or copied data, But this option contain many other options to paste data in various form, some of them given below.
  1. Paste Special (alt+ctrl+v) – This option is use to paste the data by creating a link from source data, and allow to recovering the changement between source and target data.
  2. Transpose – Using this option we can paste a data range by converting row into column and column into row.
  3. As Picture – This option paste the copied data in the form of picture.
  4. Paste as Hyperlink – This option is use to create hyperlink of copied data with a text matter.
• Format Painter – This option is use to copy and paste formatting.

Font

• Font (ctrl+d) – This option is use to choose and select the different fonts for the selected text.
• Font Size– This option is use to change the size of the selected text.
• Grow Font – This option is use to increase the font size of the selected text.
• Shrink Font – This option is use to decrease the font size of the selected text.
• Bold (ctrl+b) – This option makes selected text bold.
• Italic (ctrl+i) – This option makes selected text italic.
• Underline (ctrl+u) – This option draw a line under the selected text.
• Border – This option apply the border of line to the selected cells.
• Fill Color – This option fills the color to the background of the selected cells.
• Font Color – This option is use to change the text color.

Alignment

• Align Left (ctrl+l) – This option move the text left side in the selected cell.
• Align Center (ctrl+e) – This option move the text center in the selected cell.
• Align Right (ctrl+r) – This option move the text right in the selected cell.
• Top Align – This option move the text top in the selected cell.
• Middle Align – This option move the text middle in selected cell.
• Bottom Align – This option move the text bottom in the selected cell.
• Orientation – This option rotate the text to a diagonal angel or vertical orientation.
• Decrease Indent – This option decrease the margin between the left border and text in cell.
• Increase Indent – This option increase the margin between the left border and the text in cell.
• Wrap Text – This option wrap the long text in a cell into multiple lines.
• Merge and center – This option merge the multiple cells into one cell.

Number

• Number Format – This option allows to select a data format to the cell, there are multiple data formats as General, Number, Text, Date, Time, Percentage etc. Default data format of the cell is General.
• Accounting Number format – This option display the accounting value in a cell with a currency symbol.
• Percentage Style (Ctrl+Shift+%) – This option is use to display the value as percentage.
• Comma Style – This option display the values with separators.
• Increase Decimal – This option show more precise value by showing more decimal places.
• Decrease Decimal – This option show less precise value by showing less decimal place.

Styles

• Conditional Formatting – This option is use to format the cell or a range of data with condition rules, cells can be format with colors, styles and other formatting option by comparison the values or text etc.
• Format as Table – This option is use to format a range of cells with predefined table styles.
• Cells Styles – This option is use to format a range of cells with predefined cell styles.

Cells

• Insert – This option is use to insert the cells, rows, columns, and sheets.
• Delete –This option is use to delete the cells, rows, columns, and sheets.
• Format –This option is use to adjust the rows height and columns width, hide or unhide the row, column and sheets. This option also use for move or copy sheet, protect sheet with password, lock and format cells etc.

Editing

• AutoSum – This option contain a list of formulas for calculating one or more range of values in a worksheet, We can calculate values and find answers such as – total of values, big value, small value, average of values and count values etc.
• Fill – This option fills the series of values as up, down, right, left. We can create series of step values, date, month or days etc.
• Clear – This option is use to clear the content, comments, formats of the selected data.
• Sort & Filter – This option is use to sort the values or a range of data with ascending or descending order. This option also arrange, analyze and filter the data according to user conditions. 
• Find (ctrl +f) –This option is use to find any text or value in spreadsheet or whole workbook.
• Replace (ctrl +h) – This option is use to replace any matter with new matter. For example user wants to replace the name “UP” that used in spreadsheet too many times and can replace with “Uttar Pradesh” at a time in whole Workbook.
• Go To (ctrl +g) – This option is use to navigate formulas, bookmarks, footnotes, comments, blank cells or last cell etc.
• Select Object – This option activate the selection mode for selecting one or more objects in the spreadsheet.