How to improve the efficiency of repetitive operation in Excel

1. Ctrl+enter key combination

This key combination is used for fast padding of the same content. First, select the cells that you want to fill with the same content, enter the content, and then press Ctrl+enter to fill all the selected cells at once.

2. "Repeat" button and command

The "Repeat" button in the formula bar is used to repeat the previous action. You can use this button if you want to perform the same action in Excel, such as changing the font, glyph font size, and so on. Pressing the F4 key or ctrl+y can also easily achieve these functions.

3. Macros make repetition easier

Click view → macro → record macro, set the shortcut key in the pop-up dialog box, try not to repeat with the common shortcut key, click OK, do the action again, click Stop Recording, you can repeat the operation with the custom shortcut key. The biggest advantage of recording a macro is that multiple actions can be done in one lump.

4. Filter for duplicate data

Here are two methods: Function method and conditional format method. The key point of function method is to make good use of countif function. Exactly enter the range of cells to count and the calculated conditions. The step of the conditional formatting method is "start → conditional formatting → highlight cell rule repeat value" so that duplicate content is labeled with a different color.

5. Repeat execution function fast random number

Take the sequence number in the 1~500 range as an example, enter "=int (RAND () *500)" In a cell that requires a randomly generated ordinal number, and copy and paste the resulting random number into a numeric value.