subtotal shortcuts
- Thread starter bharath
- Start date
no sajan i am not asking for that
after complete subtotal we can see 3 groupings on left side and we usually by clicking we can get all subtotal rows and grand total and details like that....
But here i am asking for without clicking on 1,2,3 level groupings can we have any shortcut keys????
after complete subtotal we can see 3 groupings on left side and we usually by clicking we can get all subtotal rows and grand total and details like that....
But here i am asking for without clicking on 1,2,3 level groupings can we have any shortcut keys????
Smallman
Excel Ninja
Not that I know of. You are going to have to create your own shortcut via vba if you want a customised solution.
Something like this;
Where you would split this macro up into 3 shortcuts or create some smart If or Case Select statement which determines which level you are on. This should suffice for a simple shortcut though. Once again the above has 3 as an example where as you may have 7 or so. You will need to split this procedure up.
Take care
Smallman
Something like this;
Code:
Sub testo()
Sheet1.Outline.ShowLevels 1
Sheet1.Outline.ShowLevels 2
Sheet1.Outline.ShowLevels 3
End SubWhere you would split this macro up into 3 shortcuts or create some smart If or Case Select statement which determines which level you are on. This should suffice for a simple shortcut though. Once again the above has 3 as an example where as you may have 7 or so. You will need to split this procedure up.
Take care
Smallman