In this blog post, I will explain how to convert Excel Files to CSV format files. Here, we are going to use the below Excel dataset and we are going to convert this dataset into CSV (Comma Separated Value) format. See the image below:- First, go to the location of our dataset where we have …
This blog post shows you to create search box in Excel without using VBA code. The search box will find all the duplicate or same cell values in one search. Suppose that we have a dataset and multiple cell values are the same within it. See in the image above where we circled cell values …
How to Create Search Box in Excel (No VBA Code Required) Read More »
This post explains how to filter the data as you type with the help of Excel VBA. Suppose that you have a dataset and you want to apply a filter in Excel with the help of VBA. So that you can filter the name and get them to filter the below dataset. Here in this …
This blog post explains about to copy and paste from one sheet to another dynamically in Excel VBA. Here we have two worksheets “Sheet1” and “Sheet2”. We have some data in “Sheet1” and we want to paste it into “Sheet 2”. It needs to be copied under the existing dataset in “Sheet2”. So simple VBA …
VBA Macro to Dynamically Copy and Paste from One Sheet to Another Read More »
This blog post shows you the step-by-step procedure to set or lock scroll area in Excel. Suppose that you are working in a dataset and you do not want to allow the user to enter the data beyond that dataset. In that case, you can set the limit for the user to not enter the …
How to Lock Scroll Area in Excel with VBA (Step By Step Guide) Read More »
We see the (-) negative sign before any negative number but do not find any (+) sign before any positive number.
is tutorial shows how to move or copy a worksheet from one workbook to another.
This tutorial explains the three different ways to change the font color in Excel VBA. VBA has many commands and functions that can be used. Using VBA we can easily do anything in Excel. VBA in Excel is an easy and fun thing to do. With VBA, you can change the color of the cell, …
3 Quick Ways to Change the Font Color in Excel VBA Read More »
The purpose of this blog post is to teach you how to lock / protect formula part only in Excel Dataset. Protecting or locking formula parts is one of the most important skills to learn in Excel. Excel datasets require a lot of effort to design formulas. And when we share the Excel file with a colleague, there may be a high chance that the formula will be changed or edited. Which could be harmful to you. To avoid this, we will present in this tutorial how to lock / protect formula parts only instead of the entire worksheet. What Is Protection …
How to Lock / Protect Formula Part Only In Excel (A Detailed Guide) Read More »