Ungrouping Highest Level & Changing Levels

F

FARAZ QURESHI

Hi,

I am sorry but no one has till yet answered my following question that I
placed around week ago. PLEASE help me ou:

I have created subtotals using:
Data > Subtotals

Now what I want is to have the subsets of level two remaining and being
displayed on the Level-1 but want the original Level-1 of Grand Total be
removed.

Any help shall be appreciated.

Thanx!
 
F

FARAZ QURESHI

OKAY!!!!!!!!

I found the result by experimenting myself time and again!

Selection of complete data; and
Pressing Shift+Alt+Left Arrow sure helps out!
 

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

Steam user spends $13,000 to get to Steam's highest level 2
copy level 2 data in an outline 8
identify first row after subtotals 2
A Pivot Table challenge--I can't do it, can you? 5
Create mutli-level subtotals 7
School levels in Excel 0
Sum in first blank cell and a few more things... 3
sum sub levels. 3

Top