Excel styles are a useful way to define certain features of cell content formatting and give them a name, so that we can later use them more easily to format similar tables. For example, a style with the title “Header” can be used to format the headers of all the tables we make. Once saved style can be applied multiple times, and the subsequent change of style automatically changes and the formatting characteristics of all the cells in which the style is applied.
Although each cell has its own address, so we know how to find the data it contains, sometimes it would be good if we can access the cell using the term that determines its contents more closely. With this purpose, Excel has the ability to designate a cell or group of cells. The names thus created can be used as operands in formulas, function arguments, or to enable us to selectively select a cell or group of cells.
Each cell in the table has an address that consists of the name of the row and column in the cross section of which it is located. However, sometimes it is necessary to indicate both a worksheet or a workbook (document), it belongs so that we could use it as an operand in some form. Below it will be the address of the cell address that uniquely determines where it is located.
When copying formulas Excel automatically updates the address of cells that it contains. This is a very useful feature, since it allows us to create a formula once and then only copy it into the cells where it is applied, similar to the initial cell. However, sometimes there is a need for one or more address-operands to change. In this case, we use techniques for fixing addresses in a cell.
Data entry in large tables can be complicated, first of all because, by adding new rows, the header disappears from the screen. Therefore, we are not sure in which column we enter which data, so the work is much slower. “Freezing” rows or columns is a technique by which we fix one or more rows or columns so that they always appear on the screen. At the same time, we can continue to fill in the data of new rows and/or columns with a clear idea of where we need to enter.