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, …
Excel VBA / Macros
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 (7 Easy Ways)
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? 3 Easy Ways!
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? (3 Easy Formulas)
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? 3 Easy Ways!
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 …
How to Delete Hidden Rows or Columns in Excel? 2 Easy Ways!
Excel allows hiding rows in columns in case you don’t want to delete them, but also don’t want them to be visible in your worksheet. And in case you need …
How to Insert Sheet Name into Header or Footer in Excel?
Excel allows you to specify the header and footer in a worksheet, which can be quite useful if you need to print your data in the worksheet. A lot of …
How to Remove Space before Text in Excel (5 Easy Tricks)
One thing that often irritates a lot of Excel users is when you have spaces before the text in a cell. While it may look harmless, these could be quite …
How to Press Enter in Excel and Stay in the Same Cell? 3 Ways!
By default, whenever you’re in a cell in Excel and hit the Enter/Return key, the cursor would go down one cell. In most cases, this is what you want (especially …
How to Add Developer Tab in Excel? 2 Easy Ways!
If you’ve been following our Excel tutorials for a while, you would have come across a reference to the ‘Developer tab’ quite a lot of times. You might also have …