While the default option in Microsoft Excel is to show all possible values in a Pivot Table, it also provides the option to hide specific values that you do not […]
Office
How to Automatically Refresh Pivot Table Data
While the default option in Microsoft Excel is to allow users to manually refresh the Pivot Table, it also provides the option to set the Pivot Table to automatically refresh […]
How to Hide Blanks in Pivot Table
As you may agree, Blank Values in a Pivot Table look unnecessary and can be distracting. Hence, you might be looking for a way to Hide Blanks in Pivot Table. […]
How to Remove Grand Total in Pivot Table
The default option in Microsoft Excel is to automatically add a Grand Total Row and Grand Total column to the Pivot Table, which is suitable for most reporting requirements. However, […]
How to Add or Remove Subtotals in Pivot Table
Adding Subtotals to Pivot Table provides an additional level of breakdown, which can help in providing more clarity to reports that you are trying to present. Similarly, you may find […]
How to Make One Page Landscape in Word Document
Is it possible to make One page Landscape in Microsoft Word Document, with all the other remaining pages in the document being in portrait mode? For example, let us assume […]
How to Delete Blank Pages in Microsoft Word Document
As you must have experienced it, the presence of a blank page somewhere in the middle of a Microsoft Word document can mess up with page numbering, especially when you […]
How to Forward Outlook Mail to Another Email Address
You can automatically forward emails landing in your Outlook Mail Account to Gmail or any other email address. In-fact, you can even set up Inbox rules to forward Outlook Mail […]
How to Password Protect Word Documents on PC and Mac
There are users who prefer writing journals, diaries and storing all kinds of personal information in Word Documents on PC or Mac, instead of writing them on paper. The downside […]