Excel Basics

Excel Highlight Cell If Value Greater Than Another Cell (6 Ways)

To compare any particular product price, availability, etc. in different times or seasons the greater than operator helps us. In this article, I’m ...

How to Remove Subtotals in Excel (2 Easy Tricks)

In this article, we will discuss two easiest methods to remove subtotals in Excel. Basically, we use the subtotal option in excel to organize and ...

How to Change a Row Color Based on a Text Value in a Cell in Excel

While dealing with a huge database you may need to change the row color of some specific cells based on a text value to identify them quickly. Excel ...

Conditional Formatting on Multiple Rows Independently in Excel

Conditional formatting is one of the essential tools in Microsoft Excel. Analyzing data, creating insights, and other things that we can do using ...

How to Compare Two Excel Sheets for Differences in Values (4 Ways)

When we have two versions of the same workbook, the first thing that crosses our mind is to compare them and find the differences in values between ...

How to Remove Checkboxes from Excel (5 Easy Ways)

Often, we use checkboxes in Excel to demonstrate our To-Do lists’ status and many more. In this article, we discuss how to remove checkboxes from ...

Excel Conditional Formatting Based on Multiple Values of Another Cell

In this article, I’ll show you how you can apply Conditional Formatting in Excel based on multiple values of another cell. You’ll learn to apply ...

How to Remove Numbers from a Cell in Excel (7 Effective Ways)

A very common problem while using MS Excel is how to remove numbers from text cells. For some reason, various systems mix up text and numbers ...

Null vs Blank in Excel

While working with data in Microsoft Excel, you may encounter Null values or Blank cells. There has been a lot of confusion around this about how ...

How to Remove Table from Excel (5 Easy Ways)

Excel Tables offer multiple inbuilt features to organize data. But what if we don’t need to use any table or want to use features of it? In that ...

How to Highlight Duplicates in Excel (6 Easy Ways)

You might work with a lot of data that contains duplicates. You might want to highlight the duplicates. Excel has some easy and useful ways to ...

How to Delete Empty Cells in Excel (6 Methods)

To delete empty cells is quite a common and basic task that we might need to do frequently in Excel. There are multiple ways available in Excel that ...

How to Compare Two Columns Using Conditional Formatting in Excel

One of the essential tools of Excel is Conditional Formatting.  Conditional formatting highlights interesting cells or ranges of cells, indicates ...

How to Remove Trailing Spaces in Excel (6 Easy Methods)

Often while working in Excel, we encounter hasty inputs of trailing spaces in cells. Whatever the reasons it may be, existing trailing spaces pose ...

How to Split Excel Sheet into Multiple Worksheets (3 Methods)

A large dataset may contain multiple values based on the same column. If you want you can split the same categories’ (Department, Month, Region, ...

ExcelDemy
Logo