Advanced Excel Archives - Page 55 of 62

VBA to Convert Column Number to Letter in Excel (3 Methods)

Aug 4, 2024

In this article, we will demonstrate how to convert a column number to its corresponding column letter in Excel with VBA code using 3 methods: ...

VBA to Convert Column Number to Letter in Excel (3 Methods)

How to Remove Numeric Characters from Cells in Excel?

Jul 31, 2024

Method 1 - Apply TEXTJOIN Function to Remove Numeric Characters from Cells Steps: Create a new column, next to your existing column, where you ...

How to Remove Numeric Characters from Cells in Excel?

How to Split Cells in Excel (6 Easy Tricks)

Jul 3, 2024

Method 1 - Split Cells in Excel with the Text to Column Feature In the following table, we have some random names lying in the Text column. We'll ...

How to Split Cells in Excel (6 Easy Tricks)

Apply Conditional Formatting to Overdue Dates in Excel (3 Ways)

Jun 14, 2024

In this article, we will be using a project deadline list as a dataset to demonstrate all the methods. Method 1 - Apply Conditional ...

Apply Conditional Formatting to Overdue Dates in Excel (3 Ways)

How to Count Duplicates with Pivot Table in Excel

Nov 11, 2025

Sometimes we need to count the duplicates in an Excel PivotTable for easy calculation. The Excel PivotTable is an amazing feature. In this article, ...

How to Count Duplicates with Pivot Table in Excel

How to Do Conditional Formatting Based on Another Cell in Excel (6 Easy Ways)

Jun 23, 2024

Below is a database containing the ID, Name, Section, and Total Sales of some Sales Representatives. We will format some cells using conditional ...

How to Do Conditional Formatting Based on Another Cell in Excel (6 Easy Ways)

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

Jun 23, 2024

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 Excel Sheet into Multiple Sheets Based on Column Value

How to Split a Sheet into Multiple Sheets Based on Rows in Excel

Aug 4, 2024

Observe the GIF. The sample dataset (B4:C10) showcases employees and their working hours in Sheet1. To split the sheet into multiple ...

How to Split a Sheet into Multiple Sheets Based on Rows in Excel

How to Remove a Circular Reference in Excel – 2 Methods

Aug 3, 2024

Circular Reference: An Overview When a cell formula in Excel refers back to its own cell either directly or indirectly, it’s called a Circular ...

How to Remove a Circular Reference in Excel – 2 Methods

How to Find a Circular Reference in Excel (2 Easy Tricks)

Nov 11, 2025

Sometimes we input an Excel formula in a worksheet but it’s not working for some reason. It shows a warning prompt instead which mentions Circular ...

How to Find a Circular Reference in Excel (2 Easy Tricks)

How to Remove Table in Excel (6 Easy Methods)

Apr 29, 2024

Here's a brief overview of deleting a table from Excel. Let's see the steps in more detail. Remove a Table in Excel: 6 Easy Methods ...

How to Remove Table in Excel (6 Easy Methods)

How to Convert a Table to a List in Excel (3 Methods)

Jul 28, 2024

Method 1 - Using PivotTable and PivotChart Wizard to Convert a Table to a List in Excel Introduction to the Dataset: You have a dataset ...

How to Convert a Table to a List in Excel (3 Methods)

How to Split a String by Length in Excel – 8 Methods

Aug 2, 2024

This is an overview. The dataset showcases students’ records. Method 1 - Using the Flash Fill Feature to Split a String by Length ...

How to Split a String by Length in Excel – 8 Methods

How to Delete Blank Rows in Excel?

Aug 1, 2024

Method 1 - Delete a Couple of Blank Rows Manually Press & hold the Ctrl key and select the blank rows. Right-click > Go to the ...

How to Convert General Format to Date in Excel (7 Methods)

Jun 27, 2024

Note: General format in Excel means no specified format. Whenever you enter a numeric or alphanumeric value in a cell, Excel counts them in General ...