Home>Article>Topics> What is the shortcut key for repeating the previous operation in Excel?

What is the shortcut key for repeating the previous operation in Excel?

青灯夜游
青灯夜游 Original
2021-01-05 15:28:52 115129browse

The shortcut key to repeat the previous operation in excel is the "Ctrl Y" or "f4" key; or you can add the "Repeat" command in the table, then select the cell and directly click the "Repeat" command icon That’s it.

What is the shortcut key for repeating the previous operation in Excel?

The operating environment of this tutorial: Windows 7 system, Microsoft Office Excel 2016 version, Dell G3 computer.

Recommended: "Excel Tutorial"

The shortcut key for repeated operations in the excel table is: Ctrl Y, or use the shortcut key "F4", or you can click the table tool Repeat button above the bar.

Specific method:

1. First perform an operation in the excel table, such as merging cells.

What is the shortcut key for repeating the previous operation in Excel?

#2. Then select the cells that need to be merged and directly press the "Ctrl Y" key on the keyboard.

What is the shortcut key for repeating the previous operation in Excel?

#3. You can directly repeat the previous step of merging cells on the selected cells to quickly merge the selected cells.

What is the shortcut key for repeating the previous operation in Excel?

#4, or after selecting the cells to be merged, click the "F4" button on the keyboard to achieve this function.

What is the shortcut key for repeating the previous operation in Excel?

5, or you can add a "Repeat" command in the table, and directly click the "Repeat" command icon after selecting the cell

What is the shortcut key for repeating the previous operation in Excel?

If you want to read more related articles, please visitPHP Chinese website! !

The above is the detailed content of What is the shortcut key for repeating the previous operation in Excel?. For more information, please follow other related articles on the PHP Chinese website!

Statement:
The content of this article is voluntarily contributed by netizens, and the copyright belongs to the original author. This site does not assume corresponding legal responsibility. If you find any content suspected of plagiarism or infringement, please contact admin@php.cn