Subtotal feature in Excel
In this article, you will learn about the Subtotal feature of Microsoft Excel. Excel can organize data in groups, allowing you to easily show and hide different sections of your
Tag: Group Ungroup
Show Hidden/Collapsed Cells data on the Chart
In this article, you will learn how to display hidden data on the chart. if we create a chart for month wise sales and hide or collapse few months then
Protect Excel Worksheet as UserInterFaceOnly
Just assume you a worksheet wherein you have few groups for column or rows and then you protected that worksheet. Now will you be able to expand or collapse those