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 …
Excel VBA / Macros
How to Delete/Remove Checkbox in Excel?
Checkboxes provide an easy way to get yes/no type inputs from the user quickly. However, you might struggle while trying to delete these checkboxes (especially when you got multiple checkboxes …
How to Merge Two Excel Files? 3 Easy Ways!
Accessing data from multiple Excel files can be time-consuming and hard. You often have to switch between multiple open windows, it’s messy and you feel like there’s data all over …
SetFocus in Excel VBA – How to Use it?
User forms in Excel usually have a particular ‘tab order’ that automatically navigates you to a given control as and when you enter data. However, sometimes you might want to …
Remove Parentheses (Brackets) in Excel – 3 Easy Ways
The parentheses are a pair of symbols that have different meanings in different contexts. In general, parentheses are used to group elements together into an entity. In the English language, …
How to Flip Data in Excel (Columns, Rows, Tables)?
When trying to flip data, be it a column, row, or table in Excel, you would probably find that there’s no built-in option to do this. If your data is …
How to Find the Last Space in Text String in Excel?
Finding positions of a certain word or character is quite common in Excel. However, there might be cases where you need to find the position of a certain instance of …
How to Move Row to Another Sheet Based On Cell Value in Excel?
If you’re looking for a way to move rows of data from one sheet to another depending on the value in a given cell, there’s, unfortunately, no direct feature or …
How to Extract Text After Space Character in Excel?
Data cleaning is probably the most common data pre-processing task. This becomes especially necessary when the data is imported from an external source, which was probably formatted differently. One of …
How to Remove Duplicate Rows based on one Column in Excel?
One of the most common data cleaning tasks in Excel includes removing duplicate or redundant records/rows. While removing whole rows that are duplicate is straightforward, it’s a little trickier when …
What is the Excel Personal Workbook Location?
The Excel Personal Macro Workbook is the workbook that contains all your created macros in one place. This workbook usually opens whenever you start Excel, but since it is hidden, …
How to Bold Text using VBA in Excel
The best way to draw a user’s attention to a cell or some text within a cell is to make it look different from the rest of the text. One …