Tips, shortcuts and practical tips for Excel

nnThe Excel tricks are in order in this article, as there are many that we do not know or if we know them we did not know that there was also another way, how to do it then a series of tricks for Excel.n

nt
1. Many times we want to select very large ranges, the cursor tends to move a lot then what we do is that the selection becomes more extensive, than we want, to select a range of cells with a greater precision what we must do is: place the cursor in the first cell of the range we want to select, then press Shift key (SHIFT), we keep it pressed until we click it at the end of the range we have selected.

nt

2. When we want to select cells but that they are not consecutive, many times it is necessary to select different cell ranges that are not consecutive, you can use the “CTRL” key, the first thing to do is to select the first range we have, then we press the “CTRL” key we keep it pressed and we select the whole range, when we finish we release the “CTRL” key.

nt

3. When we want to make an extended selection this is a different way to select a range of cells , it allows to set the initial cell in the choice and taking this reference, as far as we want to go, we use it so we position ourselves in the initial cell, then we press the “F8” key, then we click on the cell where we want it to end, Excel default goes by selecting the range of the initial cell to the end, then we can change range by clicking until “F8” is pressed again, to disable the extended selection method.

nt

4. If we want to select non-consecutive cells using the keyboard, we do this by selecting the first range using the extended selection “F8”, then press a combination of “MAYUSCULAS” + F8 keys, then the cursor moves them to the start, from the new non-consecutive range, then press the “F8” key and select the next range.

No, no, no, no, no, no, no, no, no, no, no, no, no, no, no, no, no, no, no, no, no, no, no, no, no, no, no, no, no, no, no, no, no, no, no, no, no, no, no, no, no, no, no, no, no, no, no, no, no, no, no, no, no, no, no, no, no, no, no, no, no, no, no, no, no, no, no, no, no, no, no, no, no, no, no, no, no, no, no, no, no, no, no, no, no, no, no, no, no, no. no, no, no, no, no, no, no, no, no, no, no, no, no, no, no, no, no, no, no, no, no, no, no, no, no, no, no, no, no, no, no, no, no, no, no, no, no, no, no, no, no, no, no, no, no, no, no, no, no, no, no, no, no, no, no, no, no, no, no, no, no, no, no, no, no, no, no, no, no, no, no, no, no, no, no, no, no, no, no, no, no, no, no, no, no, no, no, no, no, no, no, no, no, no, no, no, no, no, no, no, no, no, no, no, no, no, no, no, no, no, no, no, no, no, no, no, no, no, no, no, no, no, no, no, no, no, no, no, no, no, no, no, no, no, no, no, no, no, no, no, no, no, no, no, no, no, no, no, no, no, no, no, no, no, no, no, no, no, no, no, no, no, no, no, no,

nTo add a comment in a cell we will do it the following way, we will click on the cell where we want to add a comment, then in the context menu of the cell that we do it by right clicking the mouse, we will click on where it says to insert comment, we will put the comment in the box, then we will click outside the box and ready.