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 …
Excel VBA / Macros
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 …
How to Select Rows with Specific Text in Excel
When you are working with large amounts of data in spreadsheets, you need all the tips and tricks you can get to quickly access your required data. Oftentimes you might …
How to Extract Number from Text in Excel (Beginning, End, or Middle)
Extracting numbers from a list of cells with mixed text is a common data cleaning task. Unfortunately, there is no direct menu or function created in Excel to help us …
How to Find out What Version of Excel You Have (Easy Way)
Every version of Excel brings with it new features while making some older features obsolete. As such, we often need to know exactly which version of Excel we are using, …
How to Hide Rows based on Cell Value in Excel (2 Easy Methods)
Working with large datasets that contain rows after rows of data can be quite painful. In such cases, looking for data that match particular criteria can be like looking for …
3 Easy Ways to Duplicate Sheet in Excel (Shortcuts + VBA)
Working with spreadsheets often involves a lot of repetitive tasks. A common way that spreadsheet users save time and energy is by making copies of spreadsheets already created and using …