pivot blank row labels

  1. P

    PivotTable for Excel Mac Deleting Data in Row (1&2) Column (1&2)

    I am using Excel 2016 on a Mac. When I create a pivot table from the data, it is deleting the data from the first two rows of the first three columns (labeled Loan Num, Issue Date, State) How do I keep the data from getting deleted when I create the pivot table. Below are pictures of the Excel...
  2. D

    Hide rows in pivot table wehere the values are "empty" (VBA)

    Hi, I want to hide the entire row in a pivot table in which the value(-s of that row is either zero, empty, or #NB. In the beginning of the year there wuill be o1 value in the pivot table (month=1). At the end of the year there will be 12 values in the pivot table (month=12). I want to solve...
    • dkoek
    • Thread
    • hide blank row pivot blank row labels vba & excel 2010
    • Replies: 7
    • Forum: Excel Questions
  3. T

    Non-uniform Data Set for Pivot Table/Chart

    Hello all, First of all a big thanks to all users who have posted such great answers to past questions as well as those who posted those questions to begin with. I have searched for a macro/VBA free solution to this problem for a while with no luck. Hoping I will strike gold on my first post...
  4. M

    Removing "blank" row labels in a pivot table

    I am creating a data sheet on TAB1 and a Pivot table on TAB2 This will be used to add data to daily and review the totals in the pivot When I choose the large area of the spreadsheet for the source data so I can or others can add new info without constantly updating the source data, I have...

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top