Automatic formating

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 
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.
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

How can I make pivot table sub-totals bold? 5
Insert New Row with auto formatting. 3
copy cell and formating 1
Write formula to look for 'like' value 2
Searching data within sheets 6
Excel 2003 Pivot Formatting 2
Subtotal 1
Macro for Sub total 1

Back
Top