Excel Basics Archives - Page 12 of 124

Return Non Blank Cells from a Range in Excel (3 Suitable Ways)

Jun 16, 2024

The following dataset consists of two columns labeled Area and Sales Rep. It has several records that are missing important information. We are going ...

Return Non Blank Cells from a Range in Excel (3 Suitable Ways)

How to Stop Automatic Cell Formatting in Excel

Aug 4, 2024

This is an overview. Unchecking the AutoCorrect Dialog Box Steps Click the arrow button above the ribbon and select More ...

How to Stop Automatic Cell Formatting in Excel

How to Create a Custom AutoFill List in Excel – 2 Methods

Jul 3, 2024

Method 1 - Using the Advanced Excel Options to Create a Custom AutoFill List Create a dataset. Select the range to ...

How to Create a Custom AutoFill List in Excel – 2 Methods

How to Perform Tab Navigation in Excel (8 Easy Ways)

Jun 12, 2024

Here are two simple ways to navigate worksheet tabs in Excel: To move to the adjacent sheet tabs, press Ctrl+PgDn to move to the next sheet, and ...

How to Perform Tab Navigation in Excel (8 Easy Ways)

How to Create a Drawing Register in Excel (Easy Steps)

Jul 16, 2024

What Is a Drawing Register? A drawing register is essentially a list of drawings related to a project or a company. It includes essential details ...

How to Create a Drawing Register in Excel (Easy Steps)

How to Create an Approval Workflow in Excel (with Easy Steps)

May 22, 2024

Below is our dataset called “Running Project of DPR Construction”. Step 1: Open a Dataset from OneDrive Using Desktop App Go to your ...

How to Create an Approval Workflow in Excel (with Easy Steps)

How to Convert Old Excel Files to New Format: 2 Quick Methods

Jul 5, 2024

Method 1 - Using Convert Option Steps: Go to the File tab from Ribbon. The following window will open in your worksheet. Select ...

How to Convert Old Excel Files to New Format: 2 Quick Methods

How to Create a Catalogue in Excel (with Easy Steps)

Aug 6, 2024

Step 1: Giving a Suitable Title to the Catalogue Open an Excel file and give a suitable title to the workbook. On the 2nd row of the ...

How to Create a Catalogue in Excel (with Easy Steps)

How to Create a Stopwatch in Excel (with Easy Steps)

May 31, 2024

Step 1 - Display Stopwatch Clock in Excel Select the desired cell range, e.g., B4:C4. Navigate to the Home Choose the Merge and Center ...

How to Create a Stopwatch in Excel (with Easy Steps)

[Solved!] Excel Scaling Issues (2 Easy Methods)

Aug 4, 2024

Method 1 - Change Scaling in Settings Steps: Go to the File tab from the Ribbon or press Ctrl + P. Select Print from the menu list, and the ...

[Solved!] Excel Scaling Issues (2 Easy Methods)

How to Create Data Dictionary in Excel (with Easy Steps)

Aug 4, 2024

If you want to create a data dictionary in Excel, you have come to the right place. Here, we will walk you through 3 easy steps to do the task ...

How to Create Data Dictionary in Excel (with Easy Steps)

How to Fix Excel to PDF Size Problem While Printing: 4 Methods

Jun 2, 2024

Method 1 - Utilize Print Option to Solve Excel to PDF Size Problem STEPS: Choose the intended sheet as the Active sheet. Go to the File tab. ...

How to Fix Excel to PDF Size Problem While Printing: 4 Methods

How to Make a Picture Catalog in Excel (with Easy Steps)

Aug 6, 2024

In this article, we will describe a step-by-step procedure to make a picture catalog in Excel. As an example, we'll make a picture catalog to provide ...

How to Make a Picture Catalog in Excel (with Easy Steps)

How to Catalog Books in Excel – 2 Methods

Aug 10, 2024

Method 1 - Creating a Custom Catalog for Books Steps: Select the headings. Separate the columns with a borderline. Select a ...

How to Catalog Books in Excel – 2 Methods

SmartArt in Excel: Everything You Need to Know

Aug 9, 2024

OS Industries Ltd manufactures Men’s Shirts and sells in Texas, California, and New Mexico. The supply chain is showcased below with SmartArt. ...