Home tab

The Home tab opens by default when you open a spreadsheet. It allows you to format cells and data in them, apply filters, insert functions, etc. Some other options are also available here, such as color schemes, Format as table template feature and so on.

Figure. Home tab.

Using this tab, you can:

• Set the font type, size, style, and colors

• Align data in cells

• Add cell borders and merge cells

• Insert functions and create named ranges

• Sort and filter data

• Change the number format

• Add or remove cells, rows, columns

• Copy/clear the cell formatting

• Apply a table template to the selected cell range