Latest Blog Posts

How to Remove Hyperlink from Excel (7 Methods)

Method 1 - Remove a Single Cell’s Hyperlink from Excel We will remove the hyperlink only for “Exceldemy”. STEPS: Select cell C5. ...

How to Insert a Column Shortcut in Excel (4 Methods)

Method 1 – Using Shortcut Keywords 1.1 Using SHIFT + CTRL + Equal (=) Shortcut  To add a column left of the “Name” column, Select all of ...

How to Make a Price List in Excel (Step by Step Guidelines)

Step 1 - Making an Outline of the Price List Template We'll start with the following dataset that contains various product details, including ...

How to Remove Comments in Excel (7 Methods)

Dataset Overview We have a dataset containing student details (Name, ID, Scores). In Cell B8 and C12, there are two notes. Additionally, in Cell D7 ...

How to Highlight Cell Using the If Statement in Excel (7 Ways)

Let’s say we have the following dataset: Sales Representative's Name, their Sales Area, and the Number of Units Sold in each month of the first ...

Shortcuts to Insert New Row in Excel (6 Quick Methods)

Rows run horizontally along the worksheet. In Excel rows are denoted by numerical values like 1,2,3,4 etc. In this tutorial we will see 6 methods to ...

How to Sort an IP Address in Excel – 6 Methods

Excel treats an IP address as text. This is an overview: This is the sample dataset. Method 1 - Sort the IP Address Using an ...

How to Use VBA Str Function in Excel (4 Examples)

In Excel, we can use various functions to work quickly, and also we utilize VBA to do the work fast. In Excel VBA, there are so many functions that ...

How to Link Cells in Excel (7 Ways)

Why Do We Need to Link Cells in Excel? When you create a link between cells or external cell references in a sheet, it helps us maintain the same ...

The Hyperlink in Excel is Not Working -3 Solutions

The sample dataset contains Hyperlinks. Solution 1 - The Pound (#) Sign is Not Accepted in Hyperlinks If the link contains the Pound (#) ...

How to Insert a Clustered Column Chart in Excel – 4 Methods

Method 1 - Create a Clustered Column Chart for Region-Wise Quarterly Sales data This is the sample dataset. Step 1: Inserting a ...

How to solve If Excel Sort Is Not Working (2 Solutions)

Solution 1: Delete the Same Sheet's Reference from the Formula If 'Sort' is Not Working Problem: In the following dataset, we calculated the ...

How to Add Sort Button in Excel (7 Methods)

We have an Excel file that contains information about the employees of a company. The worksheet has the Name, Age, Gender, Date of Birth, States they ...

Hyperlink in Excel VBA: Properties and Applications

While working with VBA in Excel, we often have to deal with the hyperlink. In this article, I’ll show you can work with the hyperlink in Excel. ...

How to Link Sheets in Excel with a Formula – 4 Methods

The following dataset showcases Salesman, Product, and Net Sales of a company. Method 1 - Creating a Link Formula in Excel to Link Sheets 1.1 ...

Close the CTA

Advanced Excel Exercises with Solutions PDF

 

 

ExcelDemy
Logo