Latest Blog Posts - Page 339 of 412

Conditional Formatting If Cell is Not Blank

Jun 12, 2024

Method 1 - Use the Conditional Formatting ‘Highlight Cell Rules’ Option If a Cell Is Not Blank Steps: Select the entire dataset B5:D13. ...

Conditional Formatting If Cell is Not Blank

VLOOKUP Not Working (8 Reasons & Solutions)

May 25, 2024

Although VLOOKUP has some limitations, the reason why VLOOKUP is not working is usually human error. To demonstrate the possible issues and their ...

VLOOKUP Not Working (8 Reasons & Solutions)

How to Swap Columns in Excel (5 Methods)

Jul 3, 2024

Let's assume we have a dataset with First Names, Last Names, Salaries, and Countries in Columns B, C, E, and D respectively. Method 1 - ...

How to Swap Columns in Excel (5 Methods)

Excel LOOKUP vs VLOOKUP: With 3 Examples

Jul 4, 2024

Method 1 - Dealing with Approximate Match One of the main differences between LOOKUP and VLOOKUP functions is that the LOOKUP function is bound to ...

Excel LOOKUP vs VLOOKUP: With 3 Examples

How to Group and Ungroup Columns or Rows in Excel

May 9, 2024

Consider you have data in existing cells that contain names from different countries. They have different room numbers to be allocated ...

How to Group and Ungroup Columns or Rows in Excel

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

Jul 3, 2024

We have an Excel worksheet with information about a company. We'll freeze the column header and the employee names so they stay on the screen while ...

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

How to Use LOOKUP Function in Excel?

Jul 29, 2024

Here's an overview of the article, which represents a simplified application of the LOOKUP function in Excel. You’ll learn more about the dataset as ...

What Is Table Array in Excel VLOOKUP?

Aug 1, 2024

What Is Table Array Argument in VLOOKUP Function? The Table Array argument in the Excel VLOOKUP function is used to find and look up the desired ...

How to Use ColorIndex in Excel VBA (4 Examples)

Jun 26, 2024

Excel VBA ColorIndex Codes Check out the picture below for the ColorIndex of all the colors available in Excel VBA. Here’s a dataset with ...

How to Use ColorIndex in Excel VBA (4 Examples)

How to Use the CLEAN Function in Excel – 10 Examples

Aug 11, 2024

This is an overview. CLEAN Function in Excel Function Objective The CLEAN function removes all non-printable characters from a text. ...

How to Use the CLEAN Function in Excel – 10 Examples

How to Sum Multiple Rows in Excel (4 Quick Ways)

May 9, 2024

Download the Practice Workbook Sum Multiple Rows.xlsx 4 Quick Ways to Sum Multiple Rows in Excel Method 1 - Using the SUM ...

How to Sum Multiple Rows in Excel (4 Quick Ways)

How to Remove 0 from Excel (7 Methods)

Apr 24, 2024

When we work with spreadsheets not prepared by us, we face different types of number formats in cells. For example, phone numbers may contain leading ...

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

Jul 8, 2024

Here's an overview of a method where characters are added using Flash Fill. Download the Practice Workbook Add Characters.xlsm ...

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

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

Jun 12, 2024

We have a datasheet where ID, Marks, and Student Names are given in columns B, D, and C, respectively. We will use the dataset to select ...

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

How to Calculate in Excel If Cells are Not Blank: 7 Exemplary Formulas

Jul 6, 2024

Method 1 - Combine IF and AND Functions to Calculate If Cells are Not Blank Step 1: Add a row to show the calculation. Step 2: Go to ...