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 March 1, 2020 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...
Show or Hide Formulas in Microsoft Excel (3+ Easy Ways)

Show or Hide Formulas in Microsoft Excel (3+ Easy Ways)

Show or Hide Formulas in Excel Using a Keyboard Shortcut, Button or Formula by Avantix Learning Team | Updated February 25, 2020 Applies to: Microsoft® Excel® 2010, 2013, 2016, 2019 and 365 (Windows) You can easily show or hide formulas in a number of ways in...
Keep Text Together in Microsoft Word (Words, Lines or Paragraphs)

Keep Text Together in Microsoft Word (Words, Lines or Paragraphs)

3 Ways to Keep Words, Lines or Paragraphs Together in Microsoft Word Documents by Avantix Learning Team | Updated February 20, 2020 Applies to: Microsoft® Word® 2007, 2010, 2013, 2016, 2019 and 365 (Windows) You can keep text together in several ways in Microsoft...
Hiding Notes in Microsoft Excel (Writing Notes within a Formula)

Hiding Notes in Microsoft Excel (Writing Notes within a Formula)

How to Insert Notes in Formulas using a Function in Excel by Avantix Learning Team | Updated November 24, 2019 Applies to: Microsoft® Excel® 2010, 2013, 2016, 2019 and 365 (Windows) In addition to adding comments in Excel, there is a relatively obscure function called...
Inserting, Editing, Deleting, Showing and Hiding Comments in Excel

Inserting, Editing, Deleting, Showing and Hiding Comments in Excel

How to Easily Insert, Edit, Delete, Show and Hide Comments in Excel Workbooks by Avantix Learning Team | Updated December 9, 2019 Applies to: Microsoft® Excel® 2010, 2013, 2016 and 2019 (Windows) You can insert comments in Microsoft Excel using the comments feature....

Pin It on Pinterest