Background Interior color in VBA

How to Change the Color of Cell upon Selection? In this article, you will learn how to change the color of the cell after selecting any color. We w...

Add Developer Tab in Excel

In this article, we will learn about how to show the Developer tab in ribbons of Microsoft Excel. We use the Developer tab to create the Macros, expor...

Extract Student Summary Data from Another Sheet Based on Various Status in Microsoft Excel

In this article, you will learn how to get summary status of student from Source sheet to Summary sheet based on multiple checks. Question:- I h...

How to SUMIF with Not Blank Cells in Excel

In this article, we will learn about how to get a return from non-blank cells. When you need to use excel SUM if function with some condition, we u...

Insert Bullets in Excel worksheet

Original Question:- How to insert a Bullet symbol into a Cell? When my supervisor creates spread sheets and sends them to me some of the cells h...

How to Center Excel Sheet Horizontally and Vertically on Excel Page

Microsoft Excel allows you to align worksheet on a page, you can change margins, specify custom margins, or center the worksheet horizontally or verti...

Data Validation for Specific Values

Original Question:- How to enter between specific values through Data validation? In my assignment I have been asked to use data validation to r...

Terms and Conditions of use

The applications/code on this site are distributed as is and without warranties or liability. In no event shall the owner of the copyrights, or the authors of the applications/code be liable for any loss of profit, any problems or any damage resulting from the use or evaluation of the applications/code.