Excel Basics

How to Copy Hyperlink in Excel (4 Easy Methods)

  Method 1 - Use the Mouse Click to Copy a Hyperlink in Excel In the following dataset, we will copy the hyperlink of the company “Exceldemy”. ...

How to Edit Hyperlink in Excel :5 Quick & Easy Methods

1. Edit Hyperlink through a Simple Right-Click in Excel Steps: Right-click on Cell B5 and select the Edit Hyperlink. The Edit ...

How to Sort by Month in Excel – 4 Methods

This is an overview. Method 1 - Using a Custom Sort Option to Sort by Month in Excel Step 1: Select C4:C13, and go to: Home → ...

How to Remove Panes in Excel (4 Methods)

Panes allow you to freeze one portion of your Excel datasheet and scroll the other portion separately. Though it is a useful feature, you may need to ...

How to Sort Merged Cells in Excel: 2 Easy Methods

Method 1 - Unmerge First to Sort Merged Cells in Excel 1.1 Single Column Steps: Part-1 Select the cells that we need to sort. Click on the ...

Fix: Excel Remove Duplicates Not Working (3 Solutions)

Reasons Why Excel Is Not Recognizing Duplicates Digits After Decimal: For example, 5 and 5.00 are the same. But MS Excel counts them as two ...

How to Merge Text from Two Cells in Excel (7 Methods)

We’ll use the following dataset, with a list of first and last names. We'll merge those into full names in column D. Method 1 - Merging ...

How to Remove Header and Footer in Excel (6 Methods)

Consider you have the following dataset with a Header. The dataset also has a Footer. Let's remove the Header and Footer from this ...

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 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 ...

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 ...

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 ...

Close the CTA

Advanced Excel Exercises with Solutions PDF

 

 

ExcelDemy
Logo