Latest Blog Posts

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

How to Split Excel Sheet into Multiple Worksheets (3 Methods)

Here's an overview of splitting an Excel sheet into multiple worksheets. We'll use a sample dataset representing the sales information of ...

How to use the SUMIF function with Multiple Criteria in Different Sheets in Excel – 3 Methods

This is an overview: The sample dataset showcases records of quarterly sales in three different sheets: Quarter 1, Quarter 2, and Quarter ...

How to Remove Macros from Excel – 5 Methods

This is an overview:   Method 1 - Selecting and Removing Macros using the Macro Dialog Box in Excel Step 1: Opening the Macros ...

Advanced Excel Exercises with Solutions PDF

 

 

ExcelDemy
Logo