Excel Basics Archives - Page 119 of 176

How to Use Dynamic Named Range in Excel Chart (Step by Step)

Jul 4, 2024

Step 1 - Preparing the Dataset for a Dynamic Named Range in Excel We’re going to use the following dataset that illustrates the growth of ...

How to Use Dynamic Named Range in Excel Chart (Step by Step)

How to Change the Scope of a Named Range in Excel – 3 Methods

Aug 4, 2024

This is the sample dataset. Method 1. Using the Define Name Feature to Change the Scope of a Named Range Steps: Go to Formulas >> ...

How to Change the Scope of a Named Range in Excel – 3 Methods

How to Fix If Right Click Copy and Paste Are Not Working in Excel (11 Solutions)

Jun 11, 2024

We have a dataset containing information about several Armani group sales representatives. Columns B, C, D, and E give the sales representatives' ...

How to Fix If Right Click Copy and Paste Are Not Working in Excel (11 Solutions)

How to Find and Replace in an Excel Column (6 Methods)

Jul 24, 2024

Dataset Overview Let’s assume we have a dataset of a company’s sales with columns A to G representing Delivery Date, Region, Sales Person, Product ...

How to Find and Replace in an Excel Column (6 Methods)

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

Jun 14, 2024

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 Name a Column in Excel (3 Easy and Effective Ways)

How to Show Formulas When Printing in Excel

Nov 11, 2025

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 Show Formulas When Printing in Excel

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

Jul 29, 2024

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 Hide Formulas from Other Users in Excel (2 Ways)

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

Aug 2, 2024

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

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

How to Lock Image in Excel Cell (2 Methods)

May 9, 2024

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 Lock Image in Excel Cell (2 Methods)

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

Aug 2, 2024

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 in Excel until Data Is Entered (2 Methods)

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

Jul 29, 2024

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 ...

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

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

Nov 11, 2025

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 ...