Shortcuts for moving and selection

Excel shortcuts for moving and selection are the ones you will use to a large extent in everyday work. You have no choice: when working with tables, these are most commonly performed operations, and if you apply shortcuts, they will make you considerably more productive. Productivity is a consequence of faster work, as most tasks can be done exclusively using the keyboard. Especially when you use a laptop, because when you are on the go, you may not have the favorite programmer’s pet at hand.

Moving to Excel is usually done using a mouse or cursor keys. By combining CTRL and cursor keys, we start from the beginning to the end of the data table or worksheet.

By combining the CTRL + SPACE key we select the current column, and with the SHIFT + SPACE key combination, the current line. By combining CTRL + SHIFT + SPACE, we select the entire worksheet. This can also be done using the universal Windows shortcut CTRL + A.

By pressing the HOME button, positioning is done on the first cell in a row, and by combining CTRL + HOME with the first cell in the table. If we press END, we enter the so-called End Mode. It allows you to position one of the cursor keys (arrows) to the “last” cell in the desired direction that belongs to the current row or column. The combination of the CTRL + END keys has a similar function as CTRL + HOME, but it places us on the last cell in the table.

Pressing the PGUP or PGDN key moves within the “one-page” worksheet down or up. If we press any of these buttons in combination with the ALT key, we will move one page to the left or to the right. Under the page, in fact, it means a “screen”.

Using the SHIFT key in combination with the shortcuts for movement, the selection of cells is performed. For example, just by using the SHIFT and cursor keys, we select one by one the desired cell in the desired direction. If you press CTRL at the same time and CTRL, we can select the entire row or entire column of the data table. For example, the fastest way to select the entire data table is to first position the first data cell, and then, while holding down CTRL + SHIFT, once press the right arrow, and then once down arrow. Excel under the table means the range of cells with continuous content. Where the content ceases, e.g. we come to an empty line, according to his working logic, the table stops!

By clicking the DEL button, the contents of the currently selected cell or cell group are deleted.

If we make a selection using the mouse, the CTRL and SHIFT keys can also be of great use to us. Clicking on the first cell in the row, then pressing SHIFT and clicking on the last cell in the row, we select all the cells between the two cells. If we are selecting and holding the CTRL key, it is possible to select different cells or different areas within the worksheet. These are also universal shortcuts that you can, with minor differences, apply in most Windows applications.