How To Use Outline in MS Excel
Now we will see that we can use Outline in MS Excel.
For that we have taken one sports expense budget with his for half year that is 6 months. In that we have and total for our different sports games at quarter 1 and quarter 2, and we have done gross total at last for half yearly total. Also in this particular sheet we have applied formula for everything.
Now suppose if we do not want to show all the six months data we just want to show our quarterly data for any presentation or other thing, then we can do this with the help of Outline.
For that we will first go to DATA tab in which we have 'Group' option, which will have an option of 'Auto outline', when we'll select that we'll see of the Outline sections available at the top.
In which we will see some numbers which are known as outline numbers are present in left top corner and when we click on any one of them we can see the total of our all data shown accurately.
When we are using this option we can come across a problem, that we are not able to occupy all our sheet with outlines at once, so for that we will double click on DATA tab which will hide the ribbon section.
To hide and unhide our outline symbols and outline numbers we can use 'Ctrl+8' key from our keyboard.
Have a friend to whom you would want to share this course?