Excel Basics

How to Unhide Rows in Excel (8 Quick Ways)

On the off chance that there is data on our worksheet we don't have to see, we can hide those that we would rather not see. Then, when we want that ...

How to Use Excel EXACT Function (6 Suitable Examples)

The Excel EXACT function tests two text strings and returns TRUE or FALSE depending on their exact match or otherwise respectively. The EXACT ...

How to Change Text Color Based on Value with Excel Formula

Fortunately, datastore, process, and manipulation are very familiar uses of Microsoft Excel. When we work with a large amount of data, sometimes we ...

How to Shift Cells Right in Excel (4 Quick Ways)

While working on a worksheet, you may need to shift your existing cells to add some extra data in between. When cells are shifted, the content of ...

How to Lock Columns in Excel (4 Methods)

The feature in Excel to lock columns is very useful to protect a confidential file from an unauthorized person while sharing information. Even ...

How to Freeze Columns in Excel (5 Methods)

While working with a big dataset sometimes we need to know how to Freeze Columns in Excel as well as Rows, or both of a worksheet. It’s necessary to ...

Conditional Formatting If Cell is Not Blank

In this article, we will discuss using Conditional Formatting in a cell if it is not blank. Often, when you work on spreadsheets, there might be ...

How to Remove Formatting in Excel Without Removing Contents

"Removing formatting in Excel without removing contents" means separating the raw data (text, numbers, formulas) from formatting (font styles, ...

How to Swap Columns in Excel (5 Methods)

While using MS Excel, sometimes we need to swap columns. There are many easy ways to swap columns in Microsoft Excel. I discuss here five time-saving ...

How to Group and Ungroup Columns or Rows in Excel

It's difficult to read and understand worksheets that contain a lot of extensive information. Fortunately, Microsoft Excel offers grouping data a ...

How to Find If Cell is Blank in Excel (7 Methods)

In this article, we will discuss if an Excel cell is blank or contains any data. Sometimes, while working with spreadsheets, we might need to find if ...

How to Freeze Rows and Columns at the Same Time in Excel

While working on a large Excel worksheet, we often need to freeze rows and columns at the same time to easily navigate the worksheet. Freezing rows ...

How to Use CLEAN Function in Excel (10 Examples)

The CLEAN function is an Excel text function that is used to remove non-printable characters or line breaks from texts of a dataset. In this article, ...

How to Add Characters in Excel (with Formula, Flash Fill & VBA)

You may need to add characters in Excel to the beginning, end, or in any position of all cells in a selection at times. I guess everyone knows how to ...

How to Select Specific Data in Excel (6 Easy Methods)

Undoubtedly Microsoft Excel helps us to do our work easily. Seeking a large Excel Spreadsheet is not always easy. In this article, I’ll show you 6 ...

Advanced Excel Exercises with Solutions PDF

 

 

ExcelDemy
Logo