How to Fill Blank Cells with Value above in Excel?
Sometimes, you may have a dataset where there are empty/blank cells in a dataset that should have been filled with the same value. Below is a common example where the …
Excel Tips
Here you will find common Excel tips and tutorials that can help you speed up your work and get stuff done faster.
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, books can do a much better job …
How to Compare Two Columns in Excel (using VLOOKUP & IF)
When you’re working with data in Excel, sooner or later you will have to compare data. This could be comparing two columns or even data in different sheets/workbooks. In this …
How to Remove Formulas in Excel (and keep the data)
Watch Video – How to Remove Formulas in Excel Sometimes you may want to remove formulas from the worksheets but keep the data. It is also recommended to remove formulas …
Multiple If Statements in Excel (Nested IFs, AND/OR) with Examples
We use the IF statement in Excel to test one condition and return one value if the condition is met and another if the condition is not met. However, we …
How to Remove Dashes (-) in Excel?
Sometimes, you may get data (text or numbers) that have dashes (or hyphens) in it. If you want to remove these dashes in Excel, you can use a couple of …
What does $ (dollar sign) mean in Excel Formulas?
If you have worked with Excel formulas, I am sure you have noticed that sometimes there is a $ symbol as a part of the cell references. If you’re wondering …
How to use Excel If Statement with Multiple Conditions Range [AND/OR]
![How to use Excel If Statement with Multiple Conditions Range [ANDOR]](https://spreadsheetplanet.com/wp-content/uploads/2023/02/How-to-use-Excel-If-Statement-with-Multiple-Conditions-Range-ANDOR.png)
To perform complicated and powerful data analysis, you need to test various conditions at a single point in time. The data analysis might require logical tests also within these multiple …
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?
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 Print Row Numbers in Excel?
When printing out an Excel worksheet, we usually just need to see the data. We don’t really care much for the location of the data, neither do we want to …
Why are Dates Shown as Hashtags in Excel?
The notorious string of “hashtags” or pound characters (####) can often cause frustration. This error usually accompanies string and number cells, but it is mostly encountered when working with dates. …