Playing levels

When we have an “Outline”, we show or hide different levels in different ways, .

 

	One way is to click on the minus and plus buttons.		A third way is to click on the “Details” or “Hide Details” button in the “Outline” group in the “Ribbon”.
	A second way is by clicking on the level buttons (1,2,3 …). The number of level buttons is dependent on the number of levels. For example, if you wish to see the first level in the list, click the number 1, if you wish to see a second level, click the number 2, and so on.

Hide “Outline” Symbols

Depending on the number of levels in our “Outline”, the “Outline” area at the top and on the right side of the window may take quite a bit of space.

We can temporarily hide them.

To do this, click the Ctrl + 8 keys on your keyboard.

 

Remove an “Outline”

An “Outline” is as easy to remove as any other item.
Just click the “Ungroup” button and select “Clear Outline.”

Note that if you have a whole list, you can not undo this action.

 

To remove certain parts of an “Outline”, first select the “Range” of the group you want to delete. Click the “Ungroup” button in the “Ribbon” and select rows or columns in the dialog box that appear.

Click OK

 

 

If we have removed a portion of an “Outline”, we can restore it by pressing the “Undo” button in the “Ribbon”.

 

Add “Subtotals” to a “Worksheet”

We may add “Subtotals” to a “Worksheet” at any time  by clicking on the “Subtotal” in the “Ribbon”. This way we don’t need to insert “Formulas” as “Excel” does it for us. First we sort our data to get the information we wish to group.  In the example below, this is easy, Europe in Europe, America in America, and Africa in Africa.
Select a cell in the “Range” and click the “Subtotal” in the “Ribbon”.

Attention! There cannot be any blank rows or columns in our group.

 

This opens the “Subtotals” dialog box. In the “Add Subtotal to:” I check all the months for which I want to see a “Subtotal”.  The “Use Function” is set to SUM function. That’s all I need.

We have a number of check boxes to verify.

1. “Replace current sub-totals”. 2. “Page breaks between groups” and 3. “Summary below data”.

 

If the latter is not checked, “Excel” puts all “Subtotals” and totals above the data.

Click OK

“Subtotals” (1), “Grand Total” (2), and an overview area (3) are added automatically.

 

Removing “Subtotals “

To remove “Subtotals”, we click the “Subtotal” button again in the “Ribbon”.

Click the bottom left of the dialog box and click “Remove All”.

That’s it.

Featured Courses

• Downloading iPad Apps
• Lesson 1: Introduction to Publisher
• Lesson 65: File Formats