You work with a table or PivotTable and have an issue: Only the first item is filled. The cells underneath are blank, indicating that the first cell should repeat. Here is how to easily fill down the first filled cell for all blank cells underneath. Example: Fill down empty cells with values from above Let’s… Continue reading How to Fill Down Empty Cells With Values From Above
Tag: pivottable
How to Prevent Users to Restore PivotTable Source Data
In a “normal” PivotTable (without changing any of the default settings), other Excel users can easily restore the source data. Also, when you copy and paste the PivotTable into a new Excel file without the data. But what, if you want to prevent other users to see all the data? Here is how to do… Continue reading How to Prevent Users to Restore PivotTable Source Data
How to Restore All Raw Source Data From PivotTable
You have received an Excel file with a PivotTable in it. Unfortunately, the file does not have the raw source data of the PivotTable. Or has it? Here are the steps for easily restoring the raw source data of the PivotTable.
GETPIVOTDATA: Disable GETPIVOTDATA permanently in Excel
Does this sound familiar to you? You want to refer to a cell within a PivotTable, let’s say cell C6. But instead of getting =B6, Excel does something like =GETPIVOTDATA(“Value”;$A$3;”Name”;”c”). This article shows you how to permanently disable GETPIVOTDATA in Excel.
How to Count Number of Unique Records in Excel: 5 Methods!
A common task in Excel is to find out the number of different entries in a list. For example, you have a list of names and want to know, how many different people are listed as some people might be multiple times on the list. This article introduces 5 different methods of counting the number… Continue reading How to Count Number of Unique Records in Excel: 5 Methods!
Data Source of PivotTables: How to See and Change It
You receive an Excel workbook with a Pivot Table and don’t know what data it is referring to? Or you have added a column or row to your data and want to adapt the Pivot Table?
How to Avoid Changing the Column Width When Refreshing PivotTable
In a previous Excel Tip we have learned how to create a simple Excel Pivot Table. Now we will go on from there and learn how to eliminate one of the major pains of Pivot Tables: It changes the size of the columns after each update of the values.
Pivot Tables – How to Create a Pivot Table in Excel
You have some data and want to gain a quick overview? Or conduct some easy evaluation? Maybe later on analyze the data in more detail? For all these purposes, a Pivot Table can be a good choice.