Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 16
Default Pivot table formating

I am currently using a pivot table to help sort all of my results from a
model. The problem that i am facing is that i am constantly having to change
my border formatting every time. I will set it and save. Then when i change
any of my parameters it goes back to a mixed border formating making my
tables look very unprofessional. Can you please help me keep my borders so
that i do not have to keep changing them.
  #2   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 5,939
Default Pivot table formating

My preference for pivot tables is to use autoformats. On the pivot table tool
bar is an icon with a table and lightning bolt on it. Select from the auto
formats and you are set...
--
HTH...

Jim Thomlinson


"Soccer boy" wrote:

I am currently using a pivot table to help sort all of my results from a
model. The problem that i am facing is that i am constantly having to change
my border formatting every time. I will set it and save. Then when i change
any of my parameters it goes back to a mixed border formating making my
tables look very unprofessional. Can you please help me keep my borders so
that i do not have to keep changing them.

Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Pivot Table - How to Set and Preserve my Formating for all futurepivots Negda Excel Worksheet Functions 3 May 2nd 08 02:42 PM
need help with pivot table formating magickarle Excel Discussion (Misc queries) 1 June 1st 07 03:02 PM
pivot table formating lee Excel Discussion (Misc queries) 1 April 27th 07 01:51 AM
chart formating disappears when i refresh pivot table data wunder boy Excel Discussion (Misc queries) 3 August 16th 06 11:38 AM
Conditional Formating on calculated data in a pivot table David Excel Worksheet Functions 1 March 13th 05 03:16 PM


All times are GMT +1. The time now is 01:55 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"