How to Convert Number to Text and Keep Trailing Zeros in Excel

We have an Excel worksheet that contains information about different fruits and their price. We will use this worksheet to show how to convert number ...

How to Convert Number to Text for VLOOKUP in Excel (2 Ways)

Problems with the Text and Number Formats in VLOOKUP If your lookup value and the column values are in a different format, it will cause an error. ...

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

To explore the fixes, we’ll use the following dataset that represents some clothes’ prices. Reason 1 - Excel Can't Check Spell in a Cell ...

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 Use Variable Row Number as Cell Reference in Excel

As shown in the below screenshot, we want the sum of a couple of numbers. We can simply get the sum by summing the range (i.e., B5:B11). However, if ...

How to Combine Two Bar Graphs in Excel (5 Ways)

For a company, we have some Selling Prices and Profits for different years, which we have represented in two different bar graphs. Using the ...

How to Copy Conditional Formatting to Another Workbook in Excel

Conditional Formatting is one of the most used Excel tools. Conditional Formatting allows us to format cells according to our criteria. In this ...

Compare Two Columns in Excel and Highlight the Greater Value (4 Methods)

The sample dataset contains information about the sales amount of some salespeople for two months. We will compare the sales of the first month with ...

How to Delete Rows Based on Another List in Excel: 5 Methods

Method 1 - Delete Rows Based on Another List by Applying the Excel COUNTIF Function and Sort Option Steps: Type the below formula in Cell D5 ...

How to Add a Checkbox in Excel (2 Steps + 4 Uses)

Most likely you see a checkbox that is mainly used for selecting or deselecting any option. Though the process of adding a checkbox in Excel is quite ...

Calculate Years and Months between Two Dates in Excel

To calculate years and months between two dates we are going to use this dataset. It contains some start dates and end dates, and we'll get the ...

How to Make Cells Independent in Excel (5 Methods)

The dataset below shows information about some people in a charity organization, including their names, ages, contributions per month, and ID ...

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

In this example there are three different Excel Files and each of them contain a different Sheet. Method 1 - Apply Move or Copy Operation to ...

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

Method 1 - Use Go To Special Dialogue Box to Find Blank Cells in Excel In the below screenshot, we have the attendance of 6 students for 3 days. We ...

How to Copy Conditional Formatting to Another Cell in Excel (2 Methods)

If you use specific conditional formatting to highlight cells based on some specific conditions, you might want to copy the conditional formatting to ...

Close the CTA

Advanced Excel Exercises with Solutions PDF

 

 

ExcelDemy
Logo