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, Computer Enthusiast
Category: Microsoft Office
Satisfied Customers: 90
Experience:  I have been using Office Pro for 10 years and implemented applications for business use.
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: 14 days ago.
Category: Microsoft Office
Customer: replied 14 days 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 14 days ago.

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

Expert:  Bhavik Joshi replied 13 days ago.

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

Expert:  Bhavik Joshi replied 13 days ago.

Are you looking for this option ?

Expert:  Bhavik Joshi replied 13 days 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 10 days 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 10 days ago.

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

Expert:  Bhavik Joshi replied 9 days ago.

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

Expert:  Bhavik Joshi replied 9 days 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 9 days ago.
I tried that too, but the formatting does not stick on refreshing... not sure why..
Expert:  Bhavik Joshi replied 8 days 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