Excel Basics

How to Find and Replace within Selection in Excel (7 Methods)

Frequently, you may need to find a particular data, formatting, or even cell references and then replace it with something new. Find and Replace is ...

How to Hide Formula but Allow Input in Excel (2 Methods)

This article illustrates how to hide a formula in Excel but allow input from users. This will enable you to protect the formulas from serious errors ...

Select All Cells with Data in a Column in Excel (5 Methods+Shortcuts)

In Microsoft Excel, a dataset usually contains data in each cell. But there may be some cells without data or blank. Selecting the cells with data ...

Multiple Excel Cells Are Selected with One Click (4 Causes+Solutions)

Usually clicking on an Excel cell alters the cell selection. This means clicking on a cell in Excel changes the cell selection from the previously ...

How to Find and Replace Blank Cells in Excel (4 Methods)

Excel is the best tool when it comes to working with a large dataset. Sometimes we need to find and replace blank cells in Excel. In this article, I ...

How to Add Leading Zeros in Excel Text Format (11 Methods)

In Microsoft Excel, leading zeros can be extremely useful in a variety of applications. A leading zero is any “0” digit in a number string that comes ...

If Checkbox Is Checked Then Apply Formula in Excel (4 Methods)

After you've created a checkbox, you might want to know how to use formulas in checkboxes to apply the condition. You'll need to know how to use ...

Select All Cells with Data in Excel (5 Easy Methods)

In this article, I will discuss how you can select all cells with data in Excel. When a large dataset contains data in discontinuous cells, it is ...

How to AutoFill Formula When Inserting Rows in Excel (4 Methods)

Excel is one of the most useful tools when it comes to dealing with a large dataset. We often need to insert rows in a dataset. But normally Excel ...

[Fixed] AutoFit Row Height Not Working for Merged Cells in Excel (2 Suitable Solutions)

In general, the AutoFit Row Height and the AutoFit Column Width commands automatically fit all the cell contents in an Excel worksheet. But if your ...

[Fixed!] Arrow Keys Not Moving Between Cells in Excel (2 Ways)

When everything is operating properly, you would anticipate the cursor to go to the cell to the right or left when you press the right or left arrow ...

How to Remove Blank Cells from a Range in Excel (9 Methods)

While working with a large range of datasets, we might see some unnecessary blank cells which are pretty annoying. Luckily, in Excel, there are ...

How to Make Empty Cells Blank in Excel (3 Methods)

In Microsoft Excel, while putting data in a spreadsheet, it’s a good practice to check all the cells. If there is some kind of data that contains ...

How to Deal with Blank Cells That Are Not Really Blank in Excel (4 Ways)

Sometimes you may think a cell is blank because there’s nothing in it visible. But turns out it may not be actually blank. There might be a formula ...

How to Move a Group of Cells in Excel (4 Easy Ways)

Sometimes, we have to move a group of cells in Excel depending on dataset orientations. There are multiple ways to move a group of cells whether they ...

Advanced Excel Exercises with Solutions PDF

 

 

ExcelDemy
Logo