When you make use of calculations in an Excel Pivot Table you may come across #DIV/0! error values. Let us go ahead and take a look at how to Fix […]
How to Lock Cells In Excel to Protect Them
You may want to lock all cells or certain specific cells in an Excel worksheet, in order to protect the content in those cells from being modified or erased. You […]
How to Hide and Unhide Values in Pivot Table
In case you do not want a certain value or values appearing in Pivot Table, you can hide them. In this tutorial, you will find the steps to hide and […]
How to Hide Cells, Rows and Columns In Excel
In this tutorial, you will be learning the steps to Hide Cells, Columns and Rows in Excel, so that you can prevent confidential information from being viewed by others. Hide […]
How to Hide Formulas in Excel
Hiding Formulas in Excel is an effective way to prevent the formulas from being erased, modified or altered in any way. In this tutorial we are going to provide you […]
How to Automatically Refresh Pivot Table Data
Whenever you make changes to source data, it is important to make sure that Pivot Table is refreshed. You will find below the steps to Manually Refresh Pivot Table and […]
How to Change Pivot Table Name
It is really easy to change Pivot Table Name in Microsoft Excel. You will find below the steps to change the name of a Pivot Table, along with relevant screenshots. […]
How to Change Pivot Table Data Source and Range
Whenever the data used to create Pivot Table changes or gets reorganized, you will have to make changes to data source reference in Pivot Table. You will find below the […]
How to Hide Blanks in Pivot Table
Blank values in a Pivot Table look unnecessary and they can be distracting. You will find below the steps to hide Blanks in Pivot Table. Hide Blanks in a Pivot […]
How to Remove Grand Total in Pivot Table
Depending on your requirements, you may or may not want to show Grand Totals in your reports. You will find below the steps to Add or Remove Grand Total in […]
How to Add or Remove Subtotals in Pivot Table
Adding Subtotals to Pivot Table provides an additional level of breakdown, which can be useful. However, it is also easy to get rid of subtotals, if you do not require […]
How to Insert Checkbox in Excel
In this tutorial you will find the steps to Add or Insert Checkbox in Excel, in order to create an interactive checklist, inspection report or a to-do list. Insert Checkbox […]