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 …
Excel VBA / Macros
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 …
How to Delete Hidden Rows or Columns in Excel?
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
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 …
Press Enter and Stay in the Same Cell in Excel
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?
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?
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
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 …