Latest Blog Posts

How to Hyperlink Multiple PDF Files in Excel (3 Methods)

Excel HYPERLINK Function Introduction The HYPERLINK Function creates a shortcut in a specific cell. If you click on the shortcut, it will open the ...

How to Add a Blank Option to a Drop-Down Lists and Create a Drop-Down List Without a Blank Options

METHODS TO ADD Method 1 - Use an Empty Cell as Reference Insert a Blank Cell: Add an empty cell at the beginning of your source list. For ...

How to Populate a Mail Merge Document from Excel with a VBA Macro

Scenario In the following image we have an email format in the Home sheet of our Excel workbook. There is another sheet named Info in our ...

This workbook contains links to other data sources’ Error in Excel: 2 Methods

Method 1 - Fix ‘This workbook contains links to other data sources’ Error in Excel with Automatic Update and No Message STEPS: Go to File ➤ ...

How to Show Value Instead of Formula in Excel (7 Methods)

We will consider the following dataset to demonstrate how to show value instead of formula in Excel. Method 1 - Using the Paste Values ...

How to Fix If Excel Automatic Update of Links Has Been Disabled

  What Is the ‘Excel Automatic Update of Links Has Been Disabled’ Issue? If you have a worksheet linked to another source workbook through a ...

How to Set Value to a Named Range with Excel VBA (3 Methods)

In this article, I’ll show you how you can set value (s) to a named range with VBA in Excel. You’ll learn to set a single value to a named range, as ...

How to Use Formula for Car Loan Amortization in Excel?

We can easily calculate the car loan amortization by using Microsoft Excel financial formulas. This is an easy task. While purchasing a car, ...

How to Remove Hyperlink Permanently in Excel (4 Ways)

If you want to Remove Hyperlink in Excel Permanently in an easy and quick way, this article is for you. Here we will walk you through some easy and ...

Excel VBA: Format Number with Comma (2 Examples)

How to Write Code in the Visual Basic Editor Go to the Developer tab from the Excel Ribbon. Click the Visual Basic option. In the ...

How to Hide Formula in Excel Using VBA: 4 Methods

Method 1 - Embed VBA to Hide the Formula of a Range in Excel Steps to Protect a Sheet: Go to the tab Review. Click Protect Sheet from the ...

VBA INDEX MATCH Based on Multiple Criteria in Excel (3 Methods)

This is the sample dataset for illustration. We will extract a certain result residing in one column based on conditions from the other two columns. ...

How to Format Phone Number with Dashes in Excel: 2 Methods

Method 1 - Using Format Cells Option 1.1 Using Special Category Excel has some built-in number formats which you can access from the Format Cells ...

How to Format Phone Number with Country Code in Excel (4 Methods)

  Method 1 - Using Format Cells Dialog Box Select the range containing phone numbers. Press Ctrl+1 to open the Format Cells dialog ...

How to Put Parentheses for Negative Numbers in Excel

The following sample dataset of Purchase Price and Selling Price are provided in USD for each Product. If you subtract the Selling Price from the ...

Close the CTA

Advanced Excel Exercises with Solutions PDF

 

 

ExcelDemy
Logo