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
Tag: Excel Tips
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
Insert a picture in Excel Comments
In this article, you will learn how to Insert a picture in Excel comments. Here I have taken the example for my popular Dashboards which are freely available to download.
33 Useful VBA Shortcut Keys
Keyboard Shortcut Keys can improve your productivity. In this article we will tell you 33 useful VBA shortcut keys. If you are a VBA developer or work on VBA frequently
Protect Excel Worksheet as UserInterFaceOnly
Just assume you a worksheet wherein you have few groups for column or rows and then you Protect Excel Worksheet that worksheet. Now will you be able to expand or
Highlight Unmatched Cells using Conditional Formatting in Excel
In this article you will learn how to Highlight Unmatched Cells Cells values from another range using Conditional formatting. For Example, we have Sales and Product Master worksheets. In the
Highlight the Consecutive Duplicates in Excel
In this article you will learn how to highlight the Consecutive Duplicates in Excel using Conditional Formatting. You will also learn how to highlight consecutive weekly off in an Attendance
VBA: Quickly merge cells with same value in Excel
In this article you will learn how to quickly merge same cells in Excel using VBA. Using this VBA code, you can merge multiple columns data together. This trick can