How to Make Multiplication Table in Excel (4 Methods)

If you are looking for some special tricks to make a multiplication table in Excel, you've come to the right place. There are numerous ways to make a ...

Excel VBA: Add Hyperlink to Cell in Another Sheet (2 Examples)

In this article, we'll demonstrate how to add a hyperlink to a cell in another sheet using VBA in Excel. Excel VBA: Add Hyperlink to Cell in ...

How to Make Gridlines Darker in Excel (2 Easy Ways)

In this tutorial, we will show you how you can make gridlines darker in Excel. When we open a workbook Microsoft Excel automatically adds gridlines ...

Excel VBA to Find Duplicate Values in Range: 7 Examples

Method 1 - Use VBA For Loop to Identify Duplicate Values in a Range Step 1: Go to the Sheet Name section at the bottom border of each cell. ...

How to Make a To Do List in Excel (3 Easy Methods)

We will use a sample dataset to illustrate. The following dataset represents the Task, Status, and Deadline. Method 1 - Using the Filter ...

How to create a Hyperlink to a Cell in Another Sheet with VLOOKUP Function – 3 Steps

This is an overview: The Excel HYPERLINK Function Function Objective: The HYPERLINK function in Excel creates a shortcut or link that ...

How to Find and Replace Space in Excel: 5 Methods

Method 1- Inserting TRIM Function to Find and Replace Space in Excel ➤ Type the following formula in cell F4. =TRIM(C4) ➤ Press ENTER. ...

How to Merge Excel Files into One Using CMD: 4 Steps

Here, we have the following three files January.xlsx, February.xlsx, and March.xlsx containing the sales records for the January, February, and March ...

How to Find Duplicates in a Column Using Excel VBA (5 Ways)

Method 1 - Find Duplicates for Range of Cells in a Column ❶ Press ALT + F11 to open the VBA editor. ❷ Go to Insert >> Module. ❸ Copy ...

How to Use the INDEX and the MATCH Functions in Excel – 14 Examples

This is an overview.   The INDEX and the MATCH Functions in Excel The INDEX function returns a value or a reference to a ...

How to Make a Comparison Table in Excel: 2 Methods

Method 1 - Comparison of Two Tables with Conditional Formatting Steps: Select Table 2 (B14:E18). From Excel Ribbon, go Home > ...

Excel Fix: Gridlines Disappear When Color Added: 2 Solutions

Method 1 - Add Cell Border If Gridlines Disappear When Color Is Added Steps Press ALT+T+O, or ALT+F+T, or select File >> Options to open ...

How to Extract Certain Text from a Cell in Excel VBA: 5 Codes

Method 1 - Use the VBA Left Function to Extract Text from the Left Side of the Cell and Display it in a Message Box Step 1: Go to the Sheet ...

Excel VBA: Combining If with And for Multiple Conditions

In this tutorial, we will demonstrate how to combine If with And for multiple conditions with VBA. We use the If and Else statement to evaluate ...

How to Insert the Last Saved Date in Excel (4 Methods)

  Method 1 - Using BuiltinDocumentProperties Steps: Press ALT+F11 or go to the tab Developer, Select Visual Basic to open Visual ...

Close the CTA

Advanced Excel Exercises with Solutions PDF

 

 

ExcelDemy
Logo