How to Remove the Page Break Lines in Excel (3 Methods)

What Are the Page Break Lines? Page break lines divide an Excel worksheet into separate pages for printing. There are two types of page break lines: ...

How to Find Duplicate Rows Based on Multiple Columns in Excel

Method 1 - Using the COUNTIFS Function We will use the following dataset for this method. STEPS: Select the cell range. Go to the ...

How to Split Excel Sheet into Multiple Sheets Based on Column Value

Here's an overview of using slicers to filter a table by specific value. Read on to learn more. Split Excel Sheet into Multiple Sheets ...

How to Split a String into an Array in VBA (3 Effective Ways)

In this article, I’ll show you how you can split a string into an array in VBA. Split is one of the most important and widely used functions that we ...

Highlight Duplicates in Excel

In this article, we will learn how to highlight duplicates in Excel, find duplicates, and remove the duplicates in Excel. This option is quite basic ...

How to Use Left Trim Function in Excel: 7 Easy Ways

Some spreadsheets like the following sample dataset require us to trim data from the left. Here, we need to trim the Color from the given Product ...

Using a Macro to Compare Two Columns and Highlight the Differences in Excel – 2 Methods

Method 1 - Using a VBA Macro to Compare Two Columns and Highlight the Differences in Excel This is the sample dataset. Steps: Press Alt ...

How to Delete Empty Cells in Excel (8 Easy Methods)

In this tutorial, we'll be covering some easy ways to delete empty cells in Excel. We'll use the following dataset (a sample student mark sheet) and ...

How to Count Duplicate Rows in Excel (6 Ideal Examples)

Eaxample 1 - Use COUNTIF Function to Count Duplicate Rows for Single Condition 1.1 Count Duplicate Rows Considering First Occurrence We have a ...

How to Use Conditional Formatting to Compare Two Columns in Excel

Conditional formatting allows you to change the appearance of cells based on specific criteria that you define. When the conditions are met, the cell ...

INDEX-MATCH with Duplicate Values in Excel (3 Quick Methods)

  Method 1 - Finding Duplicate Values in Excel with INDEX, MATCH, IF, and COUNTIF We have input some salespersons’ states and sales in the ...

How to Remove Trailing Spaces in Excel (6 Easy Methods)

While working in Excel, we often encounter hasty inputs of trailing spaces in cells. Whatever the reasons may be, existing trailing spaces pose ...

How to Remove Print Lines in Excel (4 Ways)

We have a dataset with some dotted-lined borders. These page break lines show how much of the worksheet will be printed on a single paper. We need to ...

How to Merge Multiple Excel Files into One Sheet by VBA (3 Examples)

We have 3 Excel files - File1, File2, and File3 - which we are going to merge into one sheet or in one workbook. Remember: The files ...

How to Find and Replace Using VBA (11 Ways)

  Download the Workbook VBA Find and Replace. xlsm How to Find and Replace Using VBA - 11 Ways We will use the following table ...

Close the CTA

Advanced Excel Exercises with Solutions PDF

 

 

ExcelDemy
Logo