Excel Basics

How to Change Scope of Named Range in Excel (3 Methods)

This article will show you some easy process of how to change scope of named range in Excel. If you want to use a range of data in your excel sheet ...

[Fixed]: Right Click Copy and Paste Not Working in Excel (11 Solutions)

While working with a large Microsoft Excel dataset, sometimes we see that the right-click copy paste does not work in Excel. This is a common ...

How to Find and Replace in Excel Column (6 Ways)

In this article, we will learn about Excel Find and Replace in Column following a few easy methods. To make our task easier we can use the Find and ...

How to Name a Column in Excel (3 Easy and Effective Ways)

If you are looking to Name a Column in Excel in an easy way, this article is for you. Here, we will demonstrate to you several ways to do the task. ...

How to Hide Formulas from Other Users in Excel (2 Ways)

In many working sectors in our lives, we may want to hide our data from other people. For example, during many presentation and data sharing ...

How to Insert Picture in Excel Cell Automatically (3 Ways)

While Microsoft Excel is usually used for calculations, you may wish to save images with data in some cases and correlate an image with a specific ...

How to Lock Image in Excel Cell (2 Methods)

Sometimes, we may need to insert images in our Excel worksheet to visualize the products or services. But, when we move or resize the cell ranges, ...

How to Hide Formulas in Excel until Data Is Entered (2 Methods)

In this article, we’ll discuss how to hide formulas in Excel until data is entered. In our daily calculations, this will enable you to protect the ...

How to Hide Formulas and Display Values in Excel (2 Ways)

Sometimes we need to protect particular cells containing formulas for various reasons and only need the values to be displayed for the user. It is a ...

How to Group Cells in Excel (6 Different Ways)

In Microsoft Excel, grouping cells involves combining one or more cells in a spreadsheet. Grouping cells can help to read data more accurately and ...

[Fixed!] Formula Result Showing 0 in Excel (3 Solutions)

In this tutorial, we will demonstrate how to fix the problem of the formula result showing 0 in Excel. While working in Excel we might need to add ...

How to Insert Picture in Excel Cell Background (3 Methods)

In this article, we’re going to show you how to insert picture in Excel cell background. To demonstrate our methods, we’ve taken some data from a ...

How to Find and Replace Using Formula in Excel (4 Examples)

This article will help you to understand the find and replace formula(s) in Excel. Sometimes we need to edit our data in Excel sheets and for that ...

[Fixed!]: Excel Formula Not Showing Correct Result (8 Methods)

While using formulas in Excel, you might not get the result you expect the formula will return, or sometimes the formula will even throw an error. ...

[Fixed!] Excel Find and Replace Not Working (6 Solutions)

It’s bothersome if we face problems while using the Find and Replace tool in Excel. Because it’s the most commonly used tool in Excel. This article ...

Advanced Excel Exercises with Solutions PDF

 

 

ExcelDemy
Logo