Latest Blog Posts

How to Calculate Manhattan Distance in Excel (2 Suitable Ways)

This tutorial will show how to calculate Manhattan distance in Excel. From the name, we can get an assumption that it is named after the famous city ...

How to Fix Excel Not Scrolling with Arrow Keys (4 Solutions)

1 - When the Enabled Scroll Lock Feature in Excel Prevents Scrolling with Arrow Keys 1.1 Turning Off Scroll Lock from External Keyboard   ...

How to Make a Fillable Form in Excel (5 Suitable Examples)

Here's an overview of how you can use a fillable form in Excel. How to Make a Fillable Data Entry Form in Excel: 5 Easy Examples Example ...

How to Find Comments in Excel: 4 Easy Methods

Method 1 - Using Show Comments Command from Review Tab to Find Comments in Excel Steps There are threaded comments on some of the cells in the ...

How to Remove Pop-up Comments in Excel (4 Suitable Ways)

We have a data set with some comments in the cell, which are giving pop-up comments when hovering over the arrows at the edges of the cells. We will ...

How to Extract Comments in Excel (3 Suitable Examples)

To illustrate how to extract comments in Excel, we'll use a sample dataset with 4 comments in the range of cells C4:C8. The VBA module is ...

How to Calculate Levenshtein Distance in Excel (4 Easy Methods)

The Levenshtein Distance, also known as the Edit distance, is named after Soviet mathematician Vladimir Levenshtein, who in 1965 first shared the ...

How to Create a Workflow in Excel (3 Simple Methods)

This article illustrates how to create a workflow in Excel. Workflow can be defined as the sequence of operations for any particular process. It is ...

How to Change the Cursor Color in Excel -2 Quick Methods

The  mouse cursor and a cell border cursor are showcased in the image below. This is the sample dataset. Method 1 - Change the ...

Excel VBA: Select All Cells with Data

This article will show you how you can select all the cells that contain data within a worksheet using Excel VBA. Excel VBA: Select All the ...

How to Add Symbol Before a Number in Excel: 3 Methods

Method 1 - Use Symbols Group to Add a Symbol Before a Number Step 1: Open the Symbols Option Select cell B5. Click on the Insert tab. ...

Excel VBA to Save as File Using Path from Cell: 7 Methods

Method 1 - Make Dataset Ready Make the dataset ready. Select a cell and type or paste the path location. Because you need to assign the cell ...

[Fixed!] Comments in Excel Far Away from Cell

If you are looking for some special tricks to solve the problem of  "comments in Excel far away from cell”, you've come to the right place. In ...

[Solved:] Excel Power Map Add-in Not Showing (with Easy Steps)

Excel is the most widely used tool when it comes to dealing with huge datasets. We can perform myriads of tasks of multiple dimensions in Excel. ...

How to Enable Editing in Excel Protected View (5 Methods)

Method 1 - Clicking on 'Enable Editing' to Edit in Protected View When opening an unsafe file (saved in previous versions of Excel or received from ...

Close the CTA

Advanced Excel Exercises with Solutions PDF

 

 

ExcelDemy
Logo