Skip to content
Spreadsheet Planet
  • About
  • Excel Tips
  • Formulas
  • Charts
  • VBA / Macros
  • Shortcuts

Excel VBA / Macros

How to Select Multiple Items from a Drop Down in Excel?

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 …

Read more

How to Select Every Other Row (Alternate Row) in Excel?

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, …

Read more

Remove Blank Rows in Excel (5 Ways + VBA)

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. …

Read more

How To Hide Formulas In Excel Without Protecting the Sheet?

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 …

Read more

Subscript Out of Range Error in VBA – How to Fix!

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 …

Read more

How to Delete Defined Name in Excel? (Name Manager + VBA)

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, …

Read more

How to Open Excel Files Using VBA (Examples)

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 …

Read more

Switch First and Last Name with Comma in Excel (Reverse Names)

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 …

Read more

How to Separate Date and Time in Excel?

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 …

Read more

How to Filter Multiple Columns in Excel?

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 …

Read more

How to Get the First Day Of The Month In Excel?

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 …

Read more

How to Remove Table Formatting in Excel?

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 …

Read more

Older posts
Page1 Page2 … Page6 Next →

Most Popular Articles

How to Compare Two Columns in Excel (using VLOOKUP & IF)

Multiple If Statements in Excel (Nested Ifs, AND/OR) with Examples

How to Remove Dashes (-) in Excel?

How to Center the Worksheet Horizontally on the Page in Excel

How to Merge First and Last Name in Excel

How to Remove Commas in Excel (from Numbers or Text String)

Why does Excel Open on Startup (and How to Stop it)

How to Remove Apostrophe in Excel

How to Unsort in Excel (Revert Back to Original Data)
SpreadsheetPlanet.com is a participant in the Amazon Services LLC Associates Program, an affiliate advertising program designed to provide a means for sites to earn advertising fees by advertising and linking to Amazon.com

2023 © SpreadsheetPlanet.com Privacy Policy | Sitemap

DMCA.com Protection Status