Hello all,
I am wondering if it is possible to move the body (column/row/values) area of a pivot table so that it does not sit directly below the filters. Likewise, if that is not possible, is it possible to merge the filter values across multiple cells (excel won't let me do either upon initial research)?
The problem I am running into, is that the filter values have a long string of text, and it is throwing off the formatting of the actual table below (which contains only numbers). Locking the column widths works, but then you are unable to read the text in the filter value cells.
Thanks.
I am wondering if it is possible to move the body (column/row/values) area of a pivot table so that it does not sit directly below the filters. Likewise, if that is not possible, is it possible to merge the filter values across multiple cells (excel won't let me do either upon initial research)?
The problem I am running into, is that the filter values have a long string of text, and it is throwing off the formatting of the actual table below (which contains only numbers). Locking the column widths works, but then you are unable to read the text in the filter value cells.
Thanks.