Excel Basics Archives - Page 3 of 32

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

Jan 6, 2022 Excel Basics

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)

Jan 2, 2022 Excel Basics

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)

Dec 31, 2021 Excel Basics

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)

Jan 2, 2022 Excel Basics

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

Dec 30, 2021 Excel Basics

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

Jan 10, 2022 Excel Basics

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)

Jan 4, 2022 Excel Basics

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)

Dec 30, 2021 Excel Basics

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

Jan 2, 2022 Excel Basics

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

Jan 5, 2022 Excel Basics

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)

Dec 30, 2021 Excel Basics

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)

Jan 4, 2022 Excel Basics

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

Jan 4, 2022 Excel Basics

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)

Dec 30, 2021 Excel Basics

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)

Dec 30, 2021 Excel Basics

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