ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   How do you get rid of a 'automatic subtotals' format problem? (https://www.excelbanter.com/excel-discussion-misc-queries/225973-how-do-you-get-rid-automatic-subtotals-format-problem.html)

Jesus Pantoja

How do you get rid of a 'automatic subtotals' format problem?
 
I had a table and used the automatic subtotal to the table. It re-arranged
the table so I tried to remove it. But now that I have removed it (I clicked
the "Remove All" button on the subtotal dialogue box), the table looks
different. It used to alternate between blue and grey. Now there are blocks
of grey and blue. Even when I arrange the records the colors are still not
alternating. Is there a way to clear this formatting issue?


All times are GMT +1. The time now is 12:04 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com