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 …
Excel VBA / Macros
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 …
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 …