Shulou(Shulou.com)06/01 Report--

This article mainly explains "Mobile Shortcut Keys commonly used in Excel". Friends who are interested may wish to have a look. The method introduced in this paper is simple, fast and practical. Let's let the editor take you to learn the mobile shortcuts commonly used in Excel.

Skillful use of keyboard shortcuts in Excel will improve our office efficiency, but there are too many keyboard shortcuts that dazzle us. Here's a summary of the shortcut operations of "move" and "choose".

In Excel, [shift] is the key related to selection, [Ctrl] is the key related to movement, and [Alt] is to change the direction of the [PgUp] [PgDn] (hereafter called page key) shortcut key.

1. [arrow keys] combination

Press [Ctrl] + [Arrow key] to move to the edge of the current data range in the worksheet.

Press [Shift] + [Arrow key] to expand the cell selection by one cell.

2. [page key] combination

Press [Ctrl] + [Page key] to move to the edge of the current data range in the worksheet.

Press [Shift] + [page key] to expand the cell selection by one cell.

Press [Alter] + [Page key] to extend the cell selection to the last non-blank cell in the same column or row as the active cell.

3. [Enter] and [Tab]

Press [Enter] to move down one cell.

Press [Tab] to move one cell to the right in the worksheet.

At this point, I believe that everyone on the "Excel commonly used mobile shortcuts" have a deeper understanding, might as well to the actual operation of it! Here is the website, more related content can enter the relevant channels to inquire, follow us, continue to learn!

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.