How to Get the Cell Address Instead Of Value In Excel?
In Excel, we often use formulas like INDEX/MATCH, VLOOKUP, and XLOOKUP to match the lookup value but in some scenarios, we came across a situation in which we lookup for …
Excel Tips
Here you will find common Excel tips and tutorials that can help you speed up your work and get stuff done faster.
How to Remove Conditional Formatting in Excel?
The Conditional Formatting feature provides an excellent way to highlight or draw attention to data that meets certain criteria or conditions. It is an effective visual communication technique. Spreadsheet designers …
How to Change Font Color Based on Cell Value in Excel?
I have seen many people manually change the cell’s font color based on the cell value. While this is all right if you have to do it once in a …
How to Change Theme Colors in Excel?
By default, your Excel has some preset theme colors and fonts. These preset theme colors are applied when you open any new Excel file and create charts or Excel Tables. …
BETWEEN Formula in Excel
Excel has close to 500 awesome formulas across various different categories, but it does not have a BETWEEN formula. And there is probably a good reason for this – you …
Remove Grand Total From Pivot Table in Excel
Pivot tables are extremely useful in analyzing and summarizing a large amount of data with a few clicks. When you create a Pivot Table in Excel, by default it would …
How to Clear Filter in Excel? Shortcut!
Excel filters are quite useful when you’re trying to analyze a large amount of data. Excel allows you to quickly apply filter your data based on one or more than …
How to Strikethrough in Excel (5 Ways + Shortcuts)
While strikethrough is mostly used in Office applications such as Microsoft Word or Outlook, a lot of users also use it in Excel. One common use case where you may …
Fill Blank Cells with 0 in Excel
Sometimes you will have a data set that has blank cells in it that you need to fill with a 0. I have often found this to be a case …
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 …
Fill Blank Cells with Dash (-) in Excel
Blank cells are often a part of the data that you download from databases or from the web. Or it could be a result of the data not being available/entered …
How to Highlight Blank Cells in Excel?
Many times, when you download a data set from the web or from a database, it would have blank cells in it. It is often required to handle these blank …