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
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!
