What is the shortcut key for ctrl+h?

Ctrl H is the shortcut key for replacement, which has wonderful uses in Excel. Let me introduce its usage below.

1. Replace the entire workbook

Open the option in the replacement window - Scope: Workbook. Replacement can be done in all worksheets.

[Example 1] Replace "Yibiao Talent" in all worksheets in the workbook with "Zhengzhou Yibiao Talent Enterprise Management Consulting Co., Ltd."

2. Replace by color and other formats

can be replaced with more than just characters in excel, and you can also search and replace based on color.

[Example 2] Replace the number with a yellow background and an amount of 100 to 999.

Note: Check "Cell Match" to prevent numbers containing 100 from being replaced, such as 1100

3, in brackets Character interception

Using pass* can complete string separation

[Example 3] Extract the name of the university in brackets in the string

Find*(,replace with empty

Search), replace with empty

4. Alternate value formula

If you We need to extract values ​​every N rows. Directly copying the formula is not possible. Can we only use functions?

[Example 4] Extract the value of column B for every 3 rows

5. Copy formulas across workbooks

When copying formulas across excel files, not only will the formula reference the original table location, but the cell references will also change.

Use the method of replacing the = sign to keep the formula unchanged

6. Batch line breaks

Yes Use the method of replacing newline characters to force the string to newline (wps does not support it)

Newline: Replace " " (space) with newline character (press Ctrl j or alt Keyboard 10 input)

Cancel line breaks: replace line breaks with spaces

7. Delete extra blank lines in Word with one click

Press Ctrl H opens the replacement window, search for ^p^p (p must be lowercase), replace it with ^p, and replace all

multiple times.

The above is the detailed content of What is the shortcut key for ctrl+h?. For more information, please follow other related articles on the PHP Chinese website!