How to Merge Data from Multiple Workbooks in Excel (5 Methods)

We’ll use the following dataset that represents some salespersons’ sales in different regions. We’ll use two more workbooks, which also represent ...

How to Name a Column in Excel (3 Easy and Effective Ways)

Method 1 - Using Table Title to Name a Column in Excel In the following table, we can see that the columns are represented by the English letters A, ...

How to Show Formulas When Printing in Excel

In day-to-day use, users need to show Excel formulas when printing. Showing formulas in print may be the result of various users' requirements. ...

How to Hide Formulas from Other Users in Excel (2 Ways)

Method 1 - Hide Formulas From Other Users Using Protection On Entire Sheet Step 1 - Make sure your worksheet is in a lock state. Check your ...

How to Insert a Picture in a Cell Automatically – 3 Methods

The sample dataset showcases Car Models. To add pictures:   Method 1 - Insert a Picture in an Excel Cell Automatically Using ...

How to Lock Image in Excel Cell (2 Methods)

To illustrate how to lock images in a cell, we’re going to use a sample dataset that contains the ID, Product, and Images of the products. ...

How to Hide Formulas in Excel until Data Is Entered (2 Methods)

Method 1 - Hide All Formulas in Excel We'll use a data set containing formulas in Cell C11 and Cell C12. In the following screenshot, you can ...

How to Hide Formulas and Display Values in Excel (2 Ways)

Method 1 - Formatting Cells to Hide Formulas and Display Values in Excel In the sample dataset, we have used the SUM function to calculate the total ...

Mortgage Calculator with Taxes and Insurance in Excel (With Easy Steps)

Step 1 - Making the Outline We need the following values for the calculator. Each value will be entered in a row. Mortgage Amount → the ...

How to Change Cell Size Without Changing Whole Column (2 Easy Ways)

Excel is one of the most useful tools when it comes to dealing with a huge dataset. Often, we need to change the cell size without changing the whole ...

Using VBA to Select a Value from a Drop Down List in Excel – 2 Methods

Creating a Dropdown List from a Generic List in Excel In the dataset below, there are repeated values (Apple in B7 and B9) . Create a ...

How to Hide Cell Contents in Excel Formula Bar (5 Methods)

If you are looking for some easy ways to hide the cell contents in the Excel Formula Bar then this article will be helpful for you. Here, we’ll ...

How to Group Cells in Excel (6 Different Ways)

  To group cells in Excel, we are going to use the following dataset. It contains some products in column B, the name of the brand of those ...

Create a Drop-down List Using the INDIRECT Function in Excel – 2 Methods

This is an overview. The Excel INDIRECT Function Objective: Create a reference from a text string. References created will not change ...

Excel VBA: Inserting a Picture from the Folder – 3 Methods

You have pictures in a specific folder and want to insert one of these pictures in your Excel worksheet.   Go to the Developer tab. ...

Close the CTA

Advanced Excel Exercises with Solutions PDF

 

 

ExcelDemy
Logo