Select Multiple Columns Using VBA
We select multiple columns in Excel for various reasons. For example, choosing numerous columns allows us to simultaneously apply formatting changes, such as…
Author: Christopher Sirali
Calculate Acceleration in Excel
Acceleration is the measure of how quickly an object changes its velocity. It is measured in meters per second squared. This tutorial shows…
Using a Dynamic Range With VLOOKUP in Excel
Sometimes we may need to use the VLOOKUP function when we expect additional rows or columns to be added to the data; therefore,…
Calculate the Original Loan Amount in Excel
A loan has four main elements: the amount, the interest rate, the loan term or the number of periodic payments, and the payment…
Custom Data Labels in Excel Chart
Data labels help point out information for a series of data points and make the chart more understandable. Therefore, you may want to…
Move X-Axis to the Bottom of a Graph in Excel
Sometimes when we create a graph in Excel, and the Y-axis has both positive and negative values, the X-axis appears in the middle…
Sum Range in VBA
Excel VBA does not have a built-in function for adding all the numbers in a range of cells. If we want to add…
Add New Line (Carriage Return) in String in VBA
We can use the following constants in Excel VBA to add a line break or carriage return to a text string : Example…
Round Value to the Nearest Quarter in Excel
Sometimes as we work with Excel we may need to round values to the nearest quarter. This tutorial shows you 4 methods of…
Replace Special Characters in Excel
Sometimes when we import data into Excel, it may come with unnecessary special characters. We may need to replace the special characters with…
