How to Hide Comments or Notes in Excel Workbooks

How to Hide Comments or Notes in Excel Workbooks

Hide Notes and Comments in Microsoft Excel by Avantix Learning Team | Updated October 17, 2020 Applies to: Microsoft® Excel® 2010, 2013, 2016, 2019 and 365 (Windows) You can hide comments and notes in Excel workbooks. In addition to adding comments in Excel, there is...
How to Hide Comments in Word (or Display Them)

How to Hide Comments in Word (or Display Them)

Show or Hide Comments in Microsoft Word Documents by Avantix Learning Team | Updated January 10, 2021 Applies to: Microsoft® Word® 2010, 2013, 2016, 2019 or 365 (Windows) You can show and hide comments using the Review tab in the Ribbon in Microsoft Word. If you add...
How to Hide or Unhide Columns or Rows in Excel (with Shortcuts)

How to Hide or Unhide Columns or Rows in Excel (with Shortcuts)

Hide and Unhide Rows and Columns in Microsoft Excel (with Shortcuts) by Avantix Learning Team | Updated January 29, 2022 Applies to: Microsoft® Excel® 2013, 2016, 2019 and 365 (Windows) You can hide or unhide columns or rows in Excel using the context menu, using a...
How to Group by Month and Year in a Pivot Table in Excel

How to Group by Month and Year in a Pivot Table in Excel

Group Dates in an Excel Pivot Table by Month and Year by Avantix Learning Team | Updated March 7, 2021 Applies to: Microsoft® Excel® 2013, 2016, 2019 and 365 (Windows) If you have valid dates entered in your source data, you can group by month, year or other date...
How to Remove Blanks in a Pivot Table in Excel (6 Ways)

How to Remove Blanks in a Pivot Table in Excel (6 Ways)

Hide or Change the Display of Blank Cells in Excel Pivot Tables by Avantix Learning Team | Updated April 5, 2021 Applies to: Microsoft® Excel® 2013, 2016, 2019 and 365 (Windows) When you create a pivot table in Excel, blank cells may appear if you have blanks in your...

Pin It on Pinterest