Excel Basics Archives - Page 152 of 176

Excel Find Last Column With Data: 4 Quick Ways

Jul 6, 2024

Method 1 - Use the TAKE Function to Find the Last Data of the Last Column Select any cell to place your resultant value. We selected the cell ...

Excel Find Last Column With Data: 4 Quick Ways

Comparing Two Columns and Returning Common Values in Excel

May 24, 2024

Microsoft Excel offers several options for comparing columns, but most of them are for searching in one column only. This article will demonstrate ...

Comparing Two Columns and Returning Common Values in Excel

How to Highlight Selected Cells in Excel (5 Easy Ways)

Jul 6, 2024

Method 1 - Using Define Name to Highlight Selected Cells in Excel Step 1: Go to Formulas Tab > Select Define Name (in Define Names section). ...

How to Highlight Selected Cells in Excel (5 Easy Ways)

How to Vlookup and Pull the Last Match in Excel – 4 Methods

Aug 3, 2024

This is a sample dataset with a list of products and their quantity. Method 1- Applying the LOOKUP Function to Pull the Last ...

How to Vlookup and Pull the Last Match in Excel – 4 Methods

How to Remove Apostrophe in Excel?

Jul 31, 2024

Unwanted apostrophes can creep into Excel worksheets when copying data from Word or a website, or even from a simple typo. These apostrophes are ...

How to Highlight Blank Cells in Excel (4 Fruitful Ways)

Jul 29, 2024

In this article, we will discuss 4 different methods to highlight blank cells in Excel. We'll use the following dataset of the names of some students ...

How to Highlight Blank Cells in Excel (4 Fruitful Ways)

Applying Conditional Formatting for Multiple Conditions in Excel

Jun 25, 2024

Here's an overview of using Conditional Formatting for multiple conditions. We have the two data tables, which we'll format. The first table ...

Applying Conditional Formatting for Multiple Conditions in Excel

How to Apply Conditional Formatting with INDEX-MATCH in Excel: 4 Methods

May 29, 2024

Method 1 - Using Conditional Formatting with INDEX-MATCH with a Fixed Lookup Value in Excel (Over a Single Column) Steps: Select the column on ...

How to Apply Conditional Formatting with INDEX-MATCH in Excel: 4 Methods

How to Apply Conditional Formatting to Multiple Columns in Excel – 10 Easy Methods

Aug 3, 2024

The sample dataset (B4:F9) contains names of employees, their projects and their working hours on different days. Method 1 - Use the ...

How to Apply Conditional Formatting to Multiple Columns in Excel – 10 Easy Methods

Highlighting Row with Conditional Formatting Based on Date in Excel

Jun 16, 2024

Here's the overview of the functions we'll use today and how they highlight cells or rows based on dates or ranges. We have a data table with ...

Highlighting Row with Conditional Formatting Based on Date in Excel

How to Apply Conditional Formatting Formula in Excel If Cell Contains Text (6 Methods)

Jul 24, 2024

Method 1 - Highlight Cells Containing Any Text Select the cells where you want to apply conditional formatting. Go to the ...

How to Apply Conditional Formatting Formula in Excel If Cell Contains Text (6 Methods)

How to Highlight Row Using Conditional Formatting (9 Methods)

Nov 11, 2025

When you are working with a large database you may want to highlight some specific rows based on other cells or values to identify them quickly. In ...