Excel 2016 - Home Tab

7 groups of Home Tab

1) Clipboard 2) Font 3) Alignment 4) Number 5) Styles 6) Cells 7) Editing

Home Tab

Contains the most frequently used options such as cut-copy-paste, font formatting, alignment, Number, Conditional formatting, etc. All the options are used to format the data.

Styles group

In this group, we have Conditional Formatting, Format as Table and Cell Styles.

Clipboard group

This group contains frequently used commands: Cut, Copy, Paste and Format painter.

Editing group

This group has the AutoSum feature as a shortcut to popular functions, the fill series command (AutoFill) to copy cell contents right, left, up and down, the Clear format button to remove cell content, comments and hyperlinks. Also, there is the sort and filter commands for tables, and the find and select button to navigate to specific cells.

Number group

We use this group to change the formatting into General, Percentage, Currency, Date, Time, Fraction etc. We can increase and decrease the decimal and convert the data into accounting style.

Alignment group

We use this group to change the position of cell's text to the right, left and middle. Also, we can subject the text to top, bottom, and middle. In this group, we have Wrap text option to adjust and make the text visible within a cell, and we can also merge 2 or more cells, using merge option.

Font group

We use this group to change the text style and text-size. We can make it bold, italic and underline. Also, this group contains border styles, fill color, font color.

Cells group

We use this group to insert or delete cells, rows, columns and sheets. Also, we have format option to adjust the height, width of cells or range. Using this option, we can hide or unhide the range, protect the workbook, rename the sheet name, fill the tab color, move or copy to sheets, lock the cells.