PDA

View Full Version : Formating lines in table/pivot table



starsky
07-15-2010, 07:10 AM
Hi,

Is there any way to format only the visible lines in a table or pivot table, the grid lines having been toggled off?

E.g. a pivot table can have boxes of different sizes depending on how many elements are placed in the row area. Select All > Format > Borders will apply to the regular grid rather than the borders that are showing.

Many thanks.

geekgirlau
07-15-2010, 09:33 PM
Have you looked at the AutoFormat settings for pivot tables?

starsky
07-16-2010, 07:12 AM
Where are those settings? The only Autoformat reference I can find is under Table Options, which is just a tick box.

geekgirlau
07-19-2010, 04:46 PM
Click anywhere in the pivot table
Select Format | AutoFormat
Choose your format