How JustAnswer Works:
  • Ask an Expert
    Experts are full of valuable knowledge and are ready to help with any question. Credentials confirmed by a Fortune 500 verification firm.
  • Get a Professional Answer
    Via email, text message, or notification as you wait on our site.
    Ask follow up questions if you need to.
  • 100% Satisfaction Guarantee
    Rate the answer you receive.
Ask NewITZone Your Own Question
NewITZone
NewITZone, Computer Enthusiast
Category: Microsoft Office
Satisfied Customers: 90
Experience:  I have been using Office Pro for 10 years and implemented applications for business use.
53509759
Type Your Microsoft Office Question Here...
NewITZone is online now
A new question is answered every 9 seconds

Can I use "Merge and Center Cells with labels" selectively

Customer Question

Can I use "Merge and Center Cells with labels" selectively on pivot table columns? I need help formatting a report I am working on.
Submitted: 7 months ago.
Category: Microsoft Office
Customer: replied 7 months ago.
Posted by JustAnswer at customer's request) Hello. I would like to request the following Expert Service(s) from you: Secure Remote Assistance. Let me know if you need more information, or send me the service offer(s) so we can proceed.
Expert:  Bhavik Joshi replied 7 months ago.

Hi, I'm Bhavik. Welcome to JustAnswer. I'm reviewing your question now, and will reply back ASAP.

Expert:  Bhavik Joshi replied 7 months ago.

I am checking your excel file and trying to understand your requirement.

Expert:  Bhavik Joshi replied 7 months ago.

Are you looking for this option ?

Expert:  Bhavik Joshi replied 7 months ago.

If yes then answer is no, because this option is for the entire table, when you change it all the columns will be affected by this.

Customer: replied 7 months ago.
How can I get to the same outcome? Is there another way to format the table so that I can keep the format constant? I have tried checking the box to say "preserve format" thanks
Expert:  Bhavik Joshi replied 7 months ago.

Okay, I am trying to make the format same for them. I think that can be done.

Expert:  Bhavik Joshi replied 7 months ago.

Yes ,here is the preserve format chekcbox which you can use to keep the formatting intact.

Expert:  Bhavik Joshi replied 7 months ago.

If formatting is going away when the pivot table is refreshed then you need to do below things for specific fields once :-

Put the cursor right over the heading
of the desired field, then slowly move the cursor upwards. Left-click when it
changes to a downward-pointing arrow. All the data for that field will be
selected. Now select Format >> Cells >> select your desired formatting >> OK.
Formatting applied this way will persist when the pivot table is refreshed

Customer: replied 7 months ago.
I tried that too, but the formatting does not stick on refreshing... not sure why..
Expert:  Bhavik Joshi replied 7 months ago.

I tried couple of times but I think it preserving formats. Can you specify which which column and row is not preserving it's format.

Related Microsoft Office Questions