How to quickly delete comments in Excel table Excel delete all comments tutorial

In daily office use, some users will use the function of adding comments if they want to explain the numbers in the table. If they want to delete them when they are no longer needed, deleting them one by one is too troublesome, so is there any What about quick batch deletion? This article brings a detailed tutorial to share with everyone. If you are interested, please continue reading. How to quickly delete comments in Excel tables? 1. In the worksheet with comments, press F5 to pop up the positioning window, and then select the positioning condition command. As shown below:

2. In the positioning conditions window, select Annotation and click OK. Now we have all the annotations selected. As shown below:

3. In the most critical step, press the Shift+F10 function key combination to pop up the right-click menu, and then select the Delete Annotation command. (1) Shift+F10 pops up the right-click menu:

(2 renderings:

The above is the detailed content of How to quickly delete comments in Excel table Excel delete all comments tutorial. For more information, please follow other related articles on the PHP Chinese website!