ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   subtotal label (https://www.excelbanter.com/excel-discussion-misc-queries/179602-subtotal-label.html)

KJ2

subtotal label
 
The problem I have is with subtotals and the summarization labels that appear
on the left. In most cases these labels appear but a few times they have
not. The labels allow for viewing of the detail, summary or grand total.
Why does this happen and how do I make them appear?

Xman019

subtotal label
 
The problem is most likely that the spreadsheet you are using has the option
to view outline symbols unchecked.

Here's how you fix it:

On the Tools menu, click Options.
Click the View tab.
Select the Outline symbols check box.
Click 'OK'
If the symbols still aren't visible or readable, use the Zoom box on the
Standard toolbar to change the magnification to 100%.
--


Marty


"KJ2" wrote:

The problem I have is with subtotals and the summarization labels that appear
on the left. In most cases these labels appear but a few times they have
not. The labels allow for viewing of the detail, summary or grand total.
Why does this happen and how do I make them appear?



All times are GMT +1. The time now is 02:38 AM.

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