Merging cells in Pivot tables
We have made a pivot table with 15 columns. For the row that states
"companies from",we want to merge all 15 cells in that row so that the title will merge and center. We tried selecting all the cells and doing a merge and center but it says that we can't do that in a pivot table. Any help please? |
Merging cells in Pivot tables
You can't merge those cells, though you could use another cell as a reference.
so, assuming your data is in B2:K2.. Merge B1:K1 Enter into B1: =B2&" "&C2&" " etc... and you can just hide row 2... "nidabland" wrote: We have made a pivot table with 15 columns. For the row that states "companies from",we want to merge all 15 cells in that row so that the title will merge and center. We tried selecting all the cells and doing a merge and center but it says that we can't do that in a pivot table. Any help please? |
All times are GMT +1. The time now is 06:02 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com