Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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? |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
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? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Merging data into pivot tables | Excel Discussion (Misc queries) | |||
Building pivot tables in Excel 2007 based on existing pivot tables? | Excel Discussion (Misc queries) | |||
Merging of pivot tables | Charts and Charting in Excel | |||
Merging 2 different pivot tables | Excel Worksheet Functions | |||
merging multiple pivot tables | Excel Worksheet Functions |