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 …
Excel VBA / Macros
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 …
10 Best Excel Books (that will make you an Excel Pro)
When we talk about learning Excel, we almost always think of videos and written tutorials. While these are great ways to learn Excel, you can also consider using Excel books …
How to Hide Columns Based on Cell Value in Excel
Excel provides features such as filters that let you hide rows based on cell values. However, if you want to hide columns based on cell values, there’s, unfortunately, no dedicated …
How to Flash an Excel Cell (Easy Step-by-Step Method)
There are a variety of ways in Excel to let you highlight or draw attention to important information in your worksheet. You can use highlights, make the font bolder, change …
How to Save Selection in Excel as PDF (3 Easy Methods)
Excel has some great features that make it really easy to export workbooks, worksheets, and even parts of a worksheet to a number of other formats. Some of these formats …
How to Sum Positive Numbers in Excel – Easy Formula
For someone fairly comfortable with Excel, summing up a list of cells is as easy as pie. But when it comes to summing up cells based on a particular condition, …
How to Count Negative Numbers in Excel – Easy Formula
Counting cells in a range of data is fairly easy, even if you are a beginner at Excel. But when it comes to counting only the cells that contain a …
How to Remove Macros from Excel? 3 Simple Methods
Macros provide a great way to automate repetitive tasks. In this way, they help get things done quickly, but there may be times when you want to remove macros from …