Hi. I have a pivot table and I have two questions about formatting.
Question 1: Can you bold headers? I have my months going across the top and I wanted to bold them. Is that possible?
Question 2: There is a total option in the pivot table. However, the totals appears at the very top of the pivot table instead of the bottom. Is there a way to position it to the bottom?
Thank you!
Edit: I know the functionality is available in the extension Pivot Table but that table doesn't allow the indent and looks far uglier (IMO).
Hi. I have a pivot table and I have two questions about formatting.
Question 1: Can you bold headers? I have my months going across the top and I wanted to bold them. Is that possible?
Question 2: There is a total option in the pivot table. However, the totals appears at the very top of the pivot table instead of the bottom. Is there a way to position it to the bottom?
Thank you!
Edit: I know the functionality is available in the extension Pivot Table but that table doesn't allow the indent and looks far uglier (IMO).
Right-Click on Total: Right-click on any of the total cells. Choose Move Options: Select "Move Options" from the context menu. Select Location: Choose the desired location for the totals. In your case, you'll want to select "At the end of each row" or "At the end of each column," depending on the orientation of your pivot table.
