Automatic formating
Hi,
Is there a way to change/personalize an automatic formating in Excel? For example, when I ask for sub-totals in a sheet, I would like that all the line of sub-total be in Bold! Not just the 1st column. Tks, Barbara |
Automatic formating
I don't think you can change excel's behavior, but you could just format those
cells after you apply data|subtotals. I like to hide all the details (using the outlining symbols to the left) then select the cells to format edit|goto|special|visible cells only Then format the cells the way I like. Barbara wrote: Hi, Is there a way to change/personalize an automatic formating in Excel? For example, when I ask for sub-totals in a sheet, I would like that all the line of sub-total be in Bold! Not just the 1st column. Tks, Barbara -- Dave Peterson |
All times are GMT +1. The time now is 02:43 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com