Excel Basics

Excel Formula to Change Text Color Based on Value (+ Bonus Methods)

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

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

In Excel, you can easily remove formatting from cells without removing the contents of the cells following some simple steps. In this article, we’ll ...

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 ...

REF Error in Excel (9 Suitable Examples)

Reference Error or REF Error occurs in Excel when a formula refers to invalid cells. It can happen when you delete cells, rows, or columns which are ...

Excel LOOKUP vs VLOOKUP: With 3 Examples

We use Both Excel LOOKUP and VLOOKUP functions to lookup values in datasets to bring out values from desired column and range. Though LOOKUP and ...

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 Add Columns in Excel (5 Quick Ways)

In Microsoft Excel, the column is basically the vertical arrangement of cells in the spreadsheet. Columns are arranged from up to down. In this ...

How to Collapse Rows in Excel (6 Methods)

The feature in Excel to collapse rows makes them disappear from the display. You may have a lot of rows in your dataset but don’t need to work with ...

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, ...

Remove Specific Character from String Excel (5 Methods)

When working with text data in Excel we may have to remove unnecessary specific character from string excel. To work conveniently we need to remove ...

ExcelDemy
Logo