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

How to Use VBA While Wend Statement in Excel (4 Examples)

The While…Wend Statement is a logical function in Excel VBA. The statement is used to create a While loop. When you are uncertain about the necessity ...

How to Use VBA RTrim Function (5 Suitable Examples)

The VBA RTrim function is a built-in String or Text function in Excel. The RTrim function is only applicable in VBA macros. We can’t use the RTrim ...

How to Extract Hyperlink from URL in Excel (3 Methods)

We’ll use a bunch of URLs from the Exceldemy website to show how you can extract them. Method 1 - Create a User-Defined Function to ...

How to Link Cells in Same Excel Worksheet (4 Quick Ways)

Method 1 - Link Cells in Same Excel Worksheet with Help of Paste Link Linking cells in the same worksheet will save your time when you try to ...

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

Excel VBA LTrim function removes leading space from a string. This function is used to develop a Macro to remove leading spaces from a specific text. ...

Close the CTA

Advanced Excel Exercises with Solutions PDF

 

 

ExcelDemy
Logo