Latest Blog Posts

Excel VBA: Create a UserForm Image from a Worksheet – 3 Examples

  Example 1 - Using the Copy Pasting Tool You have an image in your worksheet. To add this image to the UserForm dialog box:   ...

How to Use a Formula to Find Bold Text in Excel (4 Methods)

Dataset Overview We'll use a dataset that holds products sold on certain days. The products that have sold a Quantity of more than 50 (>50) are ...

How to Insert a Picture as Cell Background in Excel – 3 Methods

The dataset has three columns: Product, Size, and Color. Method 1 - Utilizing the Insert Tab to Insert a Picture as Cell Background  Images ...

How to Use VLOOKUP with a Column Index Number to Find Values from Another Sheet (2 Methods)

Dataset Overview In the screenshot below, you’ll find a sample dataset that we’ll use to demonstrate the two methods. Syntax of the ...

How to Find and Replace Using a Formula in Excel – 4 Examples

This is the dataset. Example 1 - Using Excel FIND and REPLACE Functions Steps: Create a new column (Actor's Short Name, here) and ...

How to Reduce the Size of Formula Bar in Excel (3 Ways)

Reducing the size of the formula bar in Excel saves space for a clear view. The formula bar is located below the toolbar, which displays the contents ...

Find and Replace a Text in a Range with Excel VBA (Macro and UserForm)

In this article, I’ll show you how you can use Excel VBA to find a specific text and replace it with another text within any range in a worksheet. ...

[Fixed]: Formula Bar Shows Different Value Than Cell in Excel

While working with a large Microsoft Excel dataset, sometimes we see that the formula bar shows different values than cells. It occurs for several ...

How to Copy a Cell to Another Sheet in Excel If the Cell Contains Text

The following dataset contains records of product codes, product lists, salesperson’s names, and corresponding sales values for a company. Using this ...

[Fixed!] Formula Bar Is Not Showing in Excel (4 Solutions)

Sometimes, we may see that the Formula Bar is missing in our Excel worksheet. The formula bar is very important for us to view the cell contents, ...

Excel VBA: Count Rows in a Sheet (5 Examples)

Counting the total number of rows in a sheet is quite easy for a smaller size of dataset. However, if the size of the data table becomes large, then ...

If Cell Contains Text Then Add Text in Another Cell in Excel: 6 Ways

To explain detecting and adding text to cells, let's use a sample dataset containing ID, Product Name, and Size.   Method 1 - If ...

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

We have an Excel worksheet that has the information about the revenues of different outlets of a chain restaurant for January and February. We will ...

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

To demonstrate the reasons and fixes for find and replace not working in Excel, the following dataset will be used. Solution 1 - Ensure ...

How to Find the Last Non-Blank Cell in a Row in Excel (5 Methods)

Dataset Overview We'll use the below Dataset containing Employee Names and Working Hours. Method 1 - Using Excel LOOKUP Function The ...

Close the CTA

Advanced Excel Exercises with Solutions PDF

 

 

ExcelDemy
Logo