Cell content testing

There are several functions in Excel that literally serve to “find the cell in time and space”. They can be used to identify the row and column in which the cell is located, count the rows or columns, determine the type of value that the cell contains … By themselves, these functions are seldom used. In combination with other functions, in conditional formatting, and especially with data validation, they can be irreplaceable.

Row/column shortcuts

When working with tables, there is often a need to manipulate rows and columns, and it is adding, deleting, hiding, or displaying hidden rows or columns. Manipulation is usually done by selecting some of the options from the Home toolbar, but there are several shortcuts that can help us perform these operations much faster.