Try Data-Group and Outline-Auto Outline
--
-John
Please rate when your question is answered to help us and others know what
is helpful.


" wrote:

Sometimes when I subtotal an excell worksheet, the subtotal levels
(1,2,3) will show and sometimes they don't. I'm assuming this
probably has to do with some setting in excel but I can't figure it
out. Can anyone help??