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: Excel Tips
Loop Through in Worksheets, Sheets & Chart in VBA
In this article, we have explained the difference between Chart Sheet and Worksheet in Excel. We have also explained how to loop through the Charts, Sheets and Worksheets Loop Through
Create Auto Table of Contents in Excel Workbook
In this article, you will learn how to Create Auto Table of Contents in Excel for any active workbook using VBA. We have created VBA code which you can put in
Auto Bullet Points in Excel
In this article, you will learn how to add Auto Bullet Points in Excel using Custom formatting. To add the auto bullet point in excel range below are the steps-
Apply Same Format on other Charts
In this article, you will learn how to apply the Same Chart Format on the other Charts. Let’s say we have month-wise sales data chart and we do some formatting
Show Hidden/Collapsed Cells data on the Chart
In this article, you will learn how to display Show Hidden/Collapsed Cells data on the chart. if we create a chart for month wise sales and hide or collapse few
Quick Re-Arrange Columns Sequence Using Data Sorting
In this article, you will learn how to sort the data by columns. If you have multiple columns in your excel sheet and you want to arrange the order of
Dynamic Number Format for Millions and Thousands
Many times, when we create a chart and our numbers are quite big then our data labels on the chart are not proper readable. In that case we can change
Create Multiple Names using VBA in Excel
Our daily Excel activities can be automated using VBA. Here we have created an example of Create Multiple Names using the Name range in Excel using VBA. Lets’ say we
Highlight and get birthdays count from Date of Birth
In this article, you will learn how to get count of persons from a Date of Birth data whose birthdays are in the specific month. You will also learn how