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 …
Steve Scott
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. …
How to Save Selection in Excel as PDF?
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 …
Why is Merge and Center Grayed Out?
To ensure a formatted and symmetrical look in our worksheets, we often need to merge a few cells together and center the contents of the merged cell. For example, you …
How to Sum Positive Numbers in Excel (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 (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?
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 …