Excel Basics

How to Turn on Spell Check in Excel (3 Ways)

While working in Excel, Excel might not correct all the spelling mistakes but it offers some methods to automatically check spelling mistakes. We ...

How to Lock Multiple Cells in Excel (6 Suitable Methods)

Basically, you may need to lock multiple cells for two reasons. One is to lock cells for protecting them from further edits or changes whereas the ...

Excel Checkbox: If Checked then Change Cell Color (2 Methods)

In Microsoft Excel, using the checkbox or the tick box is not very common. But you will see this to solve a lot of problems. It basically creates a ...

How to AutoFill Sequential Letters in Excel (5 Quick Ways)

It will be very supportive if we can AutoFill sequential letters in Excel instead of putting them one at a time. In this article, I will try to show ...

Excel VBA: Turn Off the “On Error Resume Next”

One of the most important jobs in Microsoft Excel VBA is error handling. If you're a programmer, you're well aware of the necessity of error handling ...

How to Auto Number Cells in Excel (10 Methods)

There are various ways to auto number cells in Excel. Auto numbering cells means filling the cells automatically with numbers in Excel. Here we will ...

How to Copy a Formula Across Multiple Rows in Excel (5 Ways)

In Microsoft Excel, we may occasionally have to repeat the same formula to a whole column or row. If we enter the formula in each cell one by one, it ...

How to Make a Group of Cells Negative in Excel (5 Methods)

This article shows 5 easy ways to make a group of cells negative in excel. The Paste Special feature, some formulas with functions, and Excel VBA are ...

How to Lock Certain Cells in Excel (4 Methods)

To protect our spreadsheet, we need to know how to lock certain cells in Excel. Locking the whole spreadsheet or certain cells in Excel allows us to ...

How to Add Checkbox in Excel without Using Developer Tab

In this article, we will learn to add a checkbox in the Excel worksheet without using the Developer tab. We use a checkbox to select or deselect any ...

How to Select a Range of Cells in Excel Formula (4 Methods)

While using formulas in Excel, we have to insert a specific range of cells to make the formula work or get the desired result. In this tutorial, I ...

How to Copy Multiple Cells to Another Sheet in Excel (9 Methods)

Copying and Pasting are useful because they allow transferring data from one place to another without retyping it each time. In Microsoft Excel, the ...

Formula to Return Blank Cell instead of Zero in Excel (with 5 Alternatives)

You may like to keep blank cells instead of zero values in your dataset. There are several ways to do it. But this article will provide you with the ...

[Fixed!] Delete Sheet Not Working in Excel (2 Solutions)

In this tutorial, we'll look at how to fix the problem when delete sheet not working in Excel. While working with a workbook that consists of ...

How to Select a Range of Cells in Excel (9 Methods)

We will use the following dataset to illustrate selecting cells. Method 1 - Click & Drag to Select a Range of Cells in Excel For ...

Advanced Excel Exercises with Solutions PDF

 

 

ExcelDemy
Logo