Excel Basics

How to Select Cells with Certain Value in Excel (5 Methods)

Sometimes, we have to find and select cells with a certain value in Excel. In general, Excel carries numerous values as entries therefore at times ...

How to Fill Blank Cells with 0 in Excel (3 Methods)

Assume that you have a big spreadsheet with thousands of empty cells, and you want to replace the empty cells with a certain value. For example, we ...

If a Cell Is Blank then Copy Another Cell in Excel (3 Methods)

A blank cell has no content in it. So, it’s obvious that you might not want to copy a blank cell. Rather, you may want to copy the contents of the ...

How to Delete Extra Pages in Excel (4 Methods)

To showcase how you can delete extra pages in Excel, we are going to use the dataset below. It contains some product items, the quantity of those ...

How to Find Reference Errors in Excel (3 Easy Methods)

In this tutorial, I will explain the details of reference (#REF!) errors and guide you on how to find the errors in excel. Besides, I will mention ...

How to Drag Cells in Excel Using Keyboard (2 Cases)

To drag cells in Excel using keyboard, follow these steps: Select the range holding the Shift and arrow keys. Press Ctrl+D to fill the value ...

[Fixed!] Spell Check Is Not Working in Excel (4 Solutions)

The spell checker in Excel helps a lot to fix any unexpected errors in spelling. It can auto-correct or give you suggestions. But in some cases, you ...

How to Fix “Fixed Objects Will Move” in Excel (4 Solutions)

Solution 1 - Save Excel Files as XLSX or XLS Files to Fix “Fixed Objects Will Move” Error Follow these steps: Go to the File tab. ...

How to Delete Rows Based on Another List in Excel?

Sometimes, while updating data, we have to delete Excel rows from a list based on another list. Luckily, we can do this row deletion using Excel ...

How to Make Cells Independent in Excel (5 Methods)

Resizing the cells in Excel to make them independent of other cells is an essential thing to do when it comes to putting a larger word or number in a ...

Combine Multiple Excel Files into One Workbook with Separate Sheets (4 Ways)

Often, we have to deal with multiple Excel files, which is inconvenient. Things get easier if we can combine those Excel files into a single ...

How to Find Blank Cells in Excel (8 Easy Ways)

This tutorial shows how to find blank cells in Excel. Sometimes we receive Excel files from someone or import those files from a database. To work ...

How to Skip Blank Rows Using Formula in Excel (8 Methods)

A Microsoft Excel spreadsheet with blank rows is a frequent occurrence. The majority of them are superfluous, and they take up extra space on the ...

How to Group Cells with Same Value in Excel (3 Methods)

If you are working with data with different categories or have cells with the same value in your Excel worksheet, then you might need to group the ...

How to Check If Value Exists in Range in Excel (8 Ways)

If you are looking for some of the easiest ways to check if a value exists in range in Excel, then you will find this article useful. For a large ...

Advanced Excel Exercises with Solutions PDF

 

 

ExcelDemy
Logo