In this post, I will show you a simple trick by which you can find out complete blank rows in the Excel datasheet. I have made an arbitrary sheet to describe. I have to find out only completely blank rows …
Lesson#131: Find out complete blank rows in the Excel datasheet Read more »
Here I am having an example to show you the Paste Special with skip blanks in Excel. Serials are incomplete in both columns. In column A even numbers are absent and in column B odd numbers are absent. If you …
Lesson#130: Paste Special with skip blanks in Excel Read more »
Hello friend! I am going to share some information about Formula Auditing in Microsoft Excel. In the Formula ribbon, you can get a group of features named Formula Auditing. It includes Trace Precedents Trace Dependents Remove Arrows Show Formulas Error …
Lesson#129: An overview of Formula Auditing in Excel Read more »
Here I will show how to make auto arranged serial no when you filter a column. This post will be very useful to many excel users like me. Suppose you are using a data sheet and you need to filter …
Lesson#128: Formula to make serial no auto arranged when filtered Read more »
An easy and simple trick to make a color picker will be shown here. Here I have made a color palette by coloring different cells with different colors. This palette allows us to pick different types of colors by selecting …
Lesson#127: Trick to make a color picker with VBA Read more »
Here I will show you how to make a simple color tester with VBA. This color tester is having only one big button. It will take input from the user for the value of Red, Green, and Blue. Then it …
Lesson#126: Making a simple color tester with VBA Read more »
Hello, we are back again with a very basic VBA learning topic. How to use a function with VBA. Here I am having an array with some random numeric values in the range A1:A10. I want to make SUM, AVERAGE, …
Another step towards learning VBA. In this post, we will learn to format text in excel with VBA. In the previous post, I discussed changing the cell background color and color codes. Lesson#123: How to change cell color with VBA …
Lesson#124: How to format text in excel with VBA Read more »
Here I will show how to change cell color by using VBA. These are the basic lessons for learning VBA. There are some methods to write code to change the cell background color. Here I have picked a cell range …
Excel doesn’t accept formatting cells that are protected if they aren’t allowed for users. To format unprotected or protected cells users must allow them before protecting a sheet. When you are protecting a sheet just see these options. The third …
Lesson#122: Cell formatting in a protected sheet in Excel Read more »