This is one of the most applicable using the MS Excel 2007. You can perform sorting and you can create a list of data, a series of rows and columns containing related data or a series of rows designate to function as a group. You can group it and summarize according to its level and creates outline of each group. You can show or hide detailed data in a worksheets by pressing + plus or – minus symbol and the number of its indicating the outline level of its group. Which display data in selected level such as overall total sales and total sales by month.
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.
About Arnel Cartoneros
