Excel Basics

Fix: Excel Remove Duplicates Not Working (3 Solutions)

Trying to remove duplicates and it’s not working in your Excel worksheet? This article will explain the possible reasons behind the issue and will ...

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

Sometimes we need to merge multiple cells into one to get the desired output. Undoubtedly, Excel provides some quickest features to do that. In this ...

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

Header and Footer contains different information of a document such as chapter name, author name, page number, publisher logo etc. in the top and ...

How to Remove Hyperlink from Excel (7 Methods)

In this article, we will discuss the process to remove the hyperlink from Excel. In Microsoft Excel, we use hyperlinks to directly go to a particular ...

Shortcuts to Insert Column in Excel (4 Easiest Ways)

We are often required to insert a column to an existing dataset in Excel. This is a really easy task and you can do it in various ways. In this ...

How to Remove Comments in Excel (7 Quick Methods)

In this tutorial, I will describe some easy and quick ways to remove comments from Excel sheets. Comments are useful while drafting Excel files. ...

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 IP Address in Excel (6 Methods)

Excel treats an IP address as text. Therefore the Sort & Filter tool in Excel cannot sort IP addresses correctly. This article shows 6 different ...

Hyperlink in Excel Not Working (3 Reasons & Solutions)

In Excel sheets, we often use Hyperlinks to link any sheet or page. Sometimes Hyperlinks may give you reference errors or links can be broken etc. In ...

How to Insert a Clustered Column Chart in Excel

Without a doubt, charts in Excel are an outstanding tool to portray any data graphically instead of showing a complex table with lots of fields. More ...

[Solved!] Excel Sort Not Working (2 Solutions)

Sorting data is one of the easiest and most frequently used operations in MS Excel. What if the sort command doesn’t work properly? This article will ...

How to Add Sort Button in Excel (7 Methods)

The sort button in Excel is a very powerful and useful feature that will let you sort the information in a large Excel worksheet without any hassle. ...

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

In this article, we’ll learn how to extract hyperlink from URL in Excel using three different methods. We often work with data from various sources ...

How to Remove Sort in Excel (3 Easy Methods)

In this article, we will demonstrate to you how to remove sort in Excel. In Microsoft Excel, we often sort data for the convenience of our work. ...

Cannot Insert Row in Excel (Quick 7 Fixes)

The created data sheets are not fixed so you may need to update them by inserting rows, columns, or various formulas, values from time to time, but ...

Advanced Excel Exercises with Solutions PDF

 

 

ExcelDemy
Logo