06

Oct

[Excel] How to use shortcut keys to move cells surprisingly fast

In this section, we will introduce useful information for office work, such as the basic functions of Excel that you haven't heard about yet, and super-speed tricks used by experts.

In order to improve the work speed of Excel, it is important to quickly move to the target cell. Press Ctrl + arrow keys to move to the edge of the table, Ctrl + Home key to the upper left of the table, and Ctrl + End to the lower right of the table. By using the name, you can easily navigate to the desired cell and even jump to other sheets. To return to the active cell from elsewhere, you can quickly return to it with Ctrl+Backspace.

Four ways to use shortcut keys in Excel

1. Quickly move to the edge of the table

To move to the top, bottom, left, or right edge of the table, press Ctrl+↑↓←→.

[Excel] Move cell amazingly How to use shortcut keys to speed up

2. Quickly move to the upper left and lower right of the table

To move to the top left or bottom right of the table, press Ctrl+Home and Ctrl+End. The Home key and End key are used in combination with the Fn key depending on the computer.

3. Navigate quickly by name

To quickly navigate to a desired cell, name and navigate to that cell. You can easily move it to another sheet. A name is what you give to a cell or range of cells. Can be used to move the active cell or to reference in formulas.

Your name will be registered. Specify a name when jumping.

4. Move quickly to the active cell

To quickly move to the active cell, press Ctrl+Backspace. This is useful when referencing distant locations in a large table.

Please master the shortcut key operation that allows you to move cells instantly and use it to speed up your Excel work.