Computer Training & Application Solutions made Simple
Contact us for a free consultation
  • Click to send us an email. We'd love to hear from you!   Ottawa       613-656-4229
  • Click to send us an email. We'd love to hear from you!   Montreal    514-342-9494

CLEAR ALL EXCEL WORKSHEET COMMENTS IN ONE STEP

Courtesy of
DJH Training & Application Solutions Inc.

Instead of clearing comments one at a time, follow these simple instructions:

1. Select the sheet (use the Ctrl + A keyboard shortcut)

2. Click the Clear button on the Home tab and select Clear Comments

 

 

 

BONUS TIP: If you insert comments often, use the SHIFT + F2 keyboard shortcut



More Newsletter Articles

© 2017 DJH Training & Application Solutions Inc.

WOULD YOU LIKE TO USE THIS ARTICLE IN YOUR NEWSLETTER, EZINE OR WEB SITE? You can, as long as you include this complete blurb with it: An entrepreneur at heart, Deborah J. Sparks established DJH Training & Application Solutions Inc. over 25 years ago, realizing her dream of creating a company known for providing high quality computer software training, application development and support and exercising her passion for teaching. To learn more and to register for DJH's free newsletter, Innovations, please visit www.djhsolutions.ca.