Everything about excel home tab

Let's understand the excel sheets:

The excel sheet contain row and column. The columns number are represented by letters like A, B, C, D, E, etc and the row numbers are represented by numbers like 1, 2, 3, 10, 122, etc.

First column number is A, second is B, third is C, fourth is D and so on and first row number is 1, second is 2, third is 3 and so on. So A1 means first column(A) first row(1), A2 means first column(A) second row(2). Similarly B2 means second column(B) second row.
Similarly E100 means 100 number row of fifth column(E). This way you can find position of a specific cell.

Black marked area:

Cut:
This option is used to cut anything from one place and paste it to another place. First, select the area or cells and click on cut. After selecting, you can also do a right-click. There you will also see this cut option.
To select multiple cells select the first cell and then drag the cursor to the endpoint.

Copy:
This option is used to copy anything from one place and paste it to another place. First, select the area or cells and click on copy. After selecting, you can also do a right click. There you will also have this copy option. To select multiple cells select the first cell and then drag the cursor to the endpoint.

Paste:
After cutting or copying go to that place where you want to paste. So after going there click on the paste option. You can also do a written click. There you also have this option.

Format printer:
To copy any format this option is used. The copy and cut option only copy the data not the format. But format printers don't copy the data it's only copying the format.

For example: Suppose You have created a table. You did a good decoration on the table. In the table, you used different text commands, used different formulas in different columns. Now you want another table which should have the same decoration as the first table. In this case, if you select the table and click on format printer then you can copy the format. Now to paste select a cell by clicking on the cell. If you do this then automatically the format will be pasted.

To select multiple cells select the first cell and then drag the cursor to the endpoint.

Green marked area

These tools are used for text-decoration like text size, text color, cell color, text font, give under(U) line, making the text italic(I), making the text bold(B), and giving border to a single cell or multiple cells. To apply if the text is already written then at first select the text and then click options from here which you want to use and if there is no text then at first select the cell and then click options from here which you want to use.

How to give border?
For one cell, select the cell and for multiple cells, select all the cells first. After selecting the cell go to an option beside under(U) option. If you take the cursor there and click on that option you will see the border on the selected cell. Now there is a lot of border option. To get a different border, click on the drop-down button. There you will see a lot of options for giving different types of borders. There you will also see an option for changing the color, line style of the border, and also erasing the given border. To use these options first select the cells and go to that option which you want to apply and then click that option. To use these options first select the cells and go to that option which you want to apply and then click on that option.

Red marked area:

This area is used for text alignment. First, select the cells and then click on the options which you want to use.

There is an option ab with an arrow sign. If you click on the drop-down button there you will see a lot of options for rotate, vertical, clockwise, etc alignment. Apply these options by clicking on the option.

Here another option is warp. If you have a big sentence then we use this option. This option creates newlines inside a cell when the cell is ended but the text is remaining.

To merge multiple cells and also want the text in the center, then use this option. You will see some more options by clicking on the dropdown button. To remove merge click on unmerged cells.

Blue marked area:

How to change data type in excel?

This area is used for changing the type or format of a column. Suppose you have a column where you have some numbers. At first, all the column data types or formats are general. You will see an option in this area named general. To perform a mathematical operation we have to convert these column types or formats into a number. To change the data type into number format click on the drop-down button given beside general. There you will see the "Number" option. Click on that and then the column type or format will be changed into a number.There are a lot of options like currency, accounting, date, short date, time, percentage ,etc. By these option names, you can understand what type of format or data types are those. So before doing any work change the type or format of the column into the correct format according to the need and then you are ready to perform other work. To change the type, you have to select the column top to bottom. In the end of the drop-down menu, you have an option named "More number format".If you click on that then a new dialog box will open. There you can do customization, like if you have decimal numbers how many numbers you want after dot, or if you have currency or accounting column then you can change the symbol of currency, or you can change date(long date, short date, date with time, etc) and time(time with AM/PM, etc) format.

Brown marked area:

How to do Conditional formatting in excel?

This option highlight cells according to the given condition. If you go to this option then You will see some more options:

1. Highlight cells rule:Here you will be able to see a lot of options. Suppose after selection of the cells or column click on greater than option. This will highlight the cells which are greater than the given value.
After clicking this option a dialog box will open and there you have to write the greater number. You can also change the cell color. To change color there is a drop-down menu in the dialog box. Other options work similarly. First, select the cells or column then go to the options click on the option then pass the value and click ok.

2.Top/Bottom rules: After selection the cells or column, go to these options and select one option. Suppose you have click on 10 items option, then this option will highlight the top 10 cells. You can change the cell number and cell color.

3.Data bars:This option will show a bar on each selected cell according to the value.

4.Color sheets:This option will give color to all the selected cells according to the value. For example, those cells which contain the most greater value can be marked as red. The smallest value contain cells can be marked as yellow ,etc.

To remove conditions use clear rules. To apply first select the cells and then click on clear rules

How to format table in excel?

To have a formatted or nice decorated table Formate as table option is used. To use this option at first select all those cells where you want to apply. For example, if you have 5 columns and 7 rows and if you want to apply the formate as table option there then at first select 5 columns and 7 rows and then go to the option and select one which you want.

Gray marked area:

Insert:
Here you can insert or create new cells, rows, columns, and sheets. Suppose you want to insert a row between 2 and 3 rows. So select 3 number row any cell and then click on insert row. To insert a column between the D and E column, select any cell of the E column and then click on insert column.

Delete:
Here you can delete cell, row, column, and sheet. To perform select the row, column, cell and then click on the related option.

Format:
Here you can control the row height, column width, protect the sheet using a password and hide (row, column, sheet). It's very easy and simple.

Orange marked are:

autosum:
Here you will see functions like sum, average, max, min, etc. If you click on the drop-down button then you will see these functions. Suppose you have 5 cells in a column and each cell contains some numerical value. Now if you want to find the average of these values then select all these cells and then click on average. For other functions, the process is same. First, select the cells and then click on the function.

Fill
If you have an empty cell then we can fill the cell with the previous cell(up) value, after cell(down) value, right cell(right) value, and left cell(left) value. To apply select the empty cell and then click on the up, right, left, and down options according to your need.

Sort & filter:
Here we can sort a single column or all the columns according to one column. To perform, at first select a column and click on A to Z(ascending order) or Z to A(descending order). After clicking a dialog box will open there you will see two options
1. Expand the selection
If you select this option then all the column's values will be sorted according to the selected column.
2. Continue with the current selection
If you select this option then only the selected column will sort. Here you can also do a custom sort. For custom, sort click on the custom sort option and then perform the custom sort.

Find & select:
To find values or replace values this option is used. To do that first select the column or cells then go to the find or replace option. After clicking on the find or replace option a dialog box will open. There you have to fill the needed things. If you click on find or replace then the first matched thing will be displayed and replaced, if you click on findall or replace all then all matched values will be displayed and will be replaced. If you click on find next then the first matched value will be displayed and if you click on find next then the second matched value will be displayed.