ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Automatic formating (https://www.excelbanter.com/excel-discussion-misc-queries/72969-automatic-formating.html)

Barbara

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

Dave Peterson

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