How to Select Multiple Items from a Drop Down in Excel?
A drop-down list in Excel is a data validation tool that allows users to select values from a predefined list of options. The default behavior of a drop-down list in …
Excel VBA / Macros
How to Select Every Other Row (Alternate Row) in Excel?
Selecting every other row in Excel could be useful when you want to manipulate alternate rows in your data set. For example, you may want to highlight every other row, …
Remove Blank Rows in Excel (5 Ways + VBA)
A dataset in Excel containing blank rows is challenging to read and navigate and can lead to computational errors. Therefore, we must remove the empty rows to resolve such problems. …
How To Hide Formulas In Excel Without Protecting the Sheet?
Sometimes we may need to hide formulas in our Excel worksheet without necessarily protecting the sheet or protecting the cells that have the formulas. In this tutorial, I will cover …
Subscript Out of Range Error in VBA – How to Fix!
Sometimes when we write and attempt to run sub-procedures in Excel VBA, Excel VBA returns a message box with the error message “Runtime error 9: Subscript out of range.” The …
How to Delete Defined Name in Excel? (Name Manager + VBA)
We define and use names in Excel formulas to easily understand, reference, and maintain data. For example, we can define a name for a table, a cell range, a constant, …
How to Open Excel Files Using VBA (Examples)
We can easily open an Excel file using Excel VBA by applying the Workbooks.Open method and the path of the file. The Workbooks.Open method has one required argument of Filename …
Switch First and Last Name with Comma in Excel (Reverse Names)
If you’ve ever been tasked with organizing a list of names in Excel, you know how frustrating it can be to get the formatting just right. A common format when …
How to Separate Date and Time in Excel?
There may be times when you import datasets and find that date and time columns have been combined. In this tutorial, we are going to look at seven simple methods …
How to Filter Multiple Columns in Excel?
In Microsoft Excel, when we apply a filter to a specific column it only filters all the columns based on that specific column. But we often came across situations where …
How to Get the First Day Of The Month In Excel?
Sometimes, you may want to get the first day of the month when you already have a date. For example, if you have 15 Jan 2023, you can use a …
How to Remove Table Formatting in Excel?
Excel Table is an amazing built-in feature that allows us to easily work with the data. When you convert a data set into an Excel Table, you’re able to use …