• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

How to GROUP & UNGROUP DATA

S

somnath6309

New Member
Dear Sir/ Madam,

In excel, we have option: Data - Outline, or Data - Group - Outline.
I want to know how to use this feature effectively so that I can use the same in my reports.
Kindly provide me a tutorial if possible.

Regards,
Somnath.
 
Hi, somnath6309!
Tried reading the built-in tutorial aka help? Use the magic key F1! :mad:
And just as a tip, remember that if you enter in an empty cell "=XXX(" (unquoted) and press the "fx" button at the left of the edition bar text box, you'll be prompted with the function wizard which shows every argument, gives a brief description of the function and by the bottom left link lets you access the built-in or online help. It works for any function.
The same from the VBA editor, you can place the cursor (keyboard, so click, don't hover with mouse) on any VBA reserved word and press F1 to access the same type of help.
Regards!
 
You must log in or register to reply here.
Back
Top