Excel Basics Archives

How to Remove Duplicates Using VLOOKUP in Excel (2 Methods)

Oct 24, 2021 Excel Basics

When you have to deal with massive data from multiple worksheets across your Excel workbook, the VLOOKUP function is your savior. The VLOOKUP ...

Excel Formula to Find Duplicates in One Column

Oct 23, 2021 Excel Basics

In Microsoft Excel, there are numerous methods available to find duplicates in a single column. We can insert a function or use a combined formula to ...

How to Remove Duplicate Rows in Excel (3 Ways)

Oct 21, 2021 Excel Basics

While working with a large dataset in Excel, there is a possibility that you are getting the same duplicate rows or columns. Sometimes we may need to ...

How to Highlight Duplicates in Two Columns in Excel

Oct 21, 2021 Excel Basics

Today I’ll show how to highlight duplicates in two columns in Excel with proper examples and illustrations. Download Practice Workbook How ...

Highlight Duplicates across Multiple Worksheets in Excel (3 Formulas)

Oct 21, 2021 Excel Basics

In Microsoft Excel, when you have to look for duplicates or matching values across multiple worksheets, you’ll find lots of suitable formulas to meet ...

How to Fill Down to Last Row with Data in Excel (3 Quick Methods)

Oct 18, 2021 Excel Basics

While working in Excel, we often have to deal with large data sets. It is a wise idea to fill the first cell manually and then apply the autofill ...

Fix: Excel Autofill Not Working (7 Issues)

Oct 17, 2021 Excel Basics

In Microsoft Excel, there might be several reasons for the Autofill or Fill Handle option not working properly. In this article, you’ll find these ...

How to Combine Text And Hyperlink in Excel Cell (2 Methods)

Oct 13, 2021 Excel Basics

Hyperlink in Excel is used to create a link to a certain web page, documents, and folder or to a specific worksheet. There may be a situation when ...

How to Create Dynamic Hyperlink in Excel (3 Methods)

Oct 13, 2021 Excel Basics

Excel allows you to deal with links. Cases can be like hyperlink to cell, find links, deal broken links, and many more. Today we are going to show ...

How to Edit Links in Excel (3 Methods)

Oct 12, 2021 Excel Basics

While working with a large database we sometimes may need to link other workbooks to the database to get data. But in many situations, the link can ...

How to Hyperlink to Cell in Excel (2 Simple Methods)

Oct 12, 2021 Excel Basics

Situations may demand you to deal with links in Excel. Cases can be like find links, deal broken links, and many more. Today we are going to show you ...

Find Broken Links in Excel (4 Quick Methods)

Oct 12, 2021 Excel Basics

While working with Microsoft Excel, it’s a common scenario to find some broken links in the data. There are a few simple reasons behind this problem ...

How to Enter Time in Excel (5 Methods)

Oct 12, 2021 Excel Basics

Entering time manually is one of the most boring things to do in Excel. Luckily, Excel has some features by which you can easily input time value in ...

Find And Replace Multiple Values in Excel (6 Quick Methods)

Oct 11, 2021 Excel Basics

In Microsoft Excel, it’s a usual scenario to find and replace multiple text or numeric values. You can use the Find and Replace command, apply ...

How to Create List from Range in Excel (3 Methods)

Oct 11, 2021 Excel Basics

While working with a large database, you may need to create a list of data or text from the given database. If you do it manually, it will cost you a ...