

How to create this. So do this by following this instruction.
- Create your worksheets or use your old data of the excel
- Be sure to create label of its columns be sure that have no blanks of the columns and rows
- Put a different color same as you seen in my post picture
- Create a total of its group same of the post picture above
- Highlight your worksheet data excluded the label or value
- Now click Home tab menu then go to Editing tab then click sort and filter button
- Now click sort A to Z
- You will see that the data arrange alphabetically together with the alphanumeric inside your worksheets
- Now highlight the worksheets
- Click Data Tab Menu
- Then click group button
- Then click group
- Now outline your worksheets
- Click Data Menu Tab
- Then point your mouse cursor to outline box launcher
- And you will see a dialogue box name settings
- Check box all options
- Then click create button
- And you will done
- Just click the plus minus button to see your work done and numbers to see the group level of your worksheets. Same as the post picture posted above of this post.
0 comments:
Post a Comment
Note: We have Zero Tolerance to Spam. Avoid Promotions with 'Links' considered as spam will be deleted immediately upon our review.