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
Tag: Excel Tips
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
VBA.Inputbox Vs Application.Inputbox in Excel VBA
In this article you will learn the use of VBA.Inputbox Vs Application.Inputbox in VBA. Input box is used to take the input from use on run time. VBA.Inputbox Vs Application
Excel Tip: Checkbox in Excel Table
Checkbox in Excel Form Controls is very useful in Microsoft Excel. Here we have created a table in each row one check box is available. We have used conditional formatting