Implementation method: First open the excel table that needs to be operated; then select all cells where the hyperlink content needs to be canceled; then press the "ctrl c" key on the keyboard to quickly copy the selected content; finally press Just press the "Enter" key on your keyboard.
The operating environment of this tutorial: Windows 7 system, Microsoft Office Excel 2007 version, Dell G3 computer.
Select: Select all the cells where you want to cancel the hyperlink content.
Copy: Use the keyboard shortcut "ctrl c" to quickly copy the selected content (of course, you can also right-click the mouse and select copy).
Enter: Press the Enter key (Enter) on the keyboard.
This is done. Although the style is still the same as the hyperlink style, if you click and see, the link has been cleared.
Related learning recommendations: excel tutorial
The above is the detailed content of How to cancel all hyperlinks in excel with one click. For more information, please follow other related articles on the PHP Chinese website!