Excel Basics Archives - Page 47 of 176

How to Move Watermark in Excel (with Easy Steps)

Nov 11, 2025

A watermark is a logo, text, picture, or pattern. We usually superimpose it onto another image or dataset intentionally. The main purpose of a ...

How to Move Watermark in Excel (with Easy Steps)

How to Export HTML Table with Formatting to Excel

Jul 12, 2024

We have a DOCTYPE HTML code that contains information about several Customers. We will create an HTML table using Notepad. Step 1 - Create ...

How to Export HTML Table with Formatting to Excel

How to Check Spelling and Grammar in Excel – 4 Methods

Aug 8, 2024

This is the sample dataset. Method 1 - Using the Spelling Command 1.1 Check Spelling Mistakes for a Single Cell Steps There is a ...

How to Check Spelling and Grammar in Excel – 4 Methods

How to Fill Empty Cells with a Default Value in Excel – 3 Methods

Aug 3, 2024

Consider the following dataset. To fill empty cells with default values: Method 1 - Fill Cells with a Default Value by Using a Simple ...

How to Fill Empty Cells with a Default Value in Excel – 3 Methods

How to Copy a Sheet If Name Already Exists in Excel

Jun 26, 2024

Sometimes when copying a sheet from one workbook to another, Excel will show a warning about ranges having the same name. In this article, we will ...

How to Copy a Sheet If Name Already Exists in Excel

How to Stop Name Conflict Dialog Box in Excel (3 Effective Ways)

Jun 16, 2024

Method 1 - Stop Name Conflict Dialog Box with Existing Version The name conflict error comes from named ranges from several sheets colliding ...

How to Stop Name Conflict Dialog Box in Excel (3 Effective Ways)

How to Skip Lines in Excel (4 Suitable Ways)

Nov 11, 2025

Blank lines in a Microsoft Excel spreadsheet are rather common phenomena. Most of them are redundant, and they take up additional space on the ...

How to Skip Lines in Excel (4 Suitable Ways)

Excel If Two Cells Are Blank Then Return Value

Nov 11, 2025

In this article, we'll learn some easy and practical Excel techniques for returning comments or values in a third column if two cells are blank. ...

Excel If Two Cells Are Blank Then Return Value

How to Enter 20 Digit Number in Excel (2 Easy Methods)

Nov 11, 2025

If you are searching for solutions or some special tricks to enter 20 digit number in Excel then you have landed in the right place. There are 2 ways ...

How to Enter 20 Digit Number in Excel (2 Easy Methods)

How to Create a Dialog Box in Excel – 3 Examples

Aug 9, 2024

A dialog box is shown below. Example 1: Create a Simple Message Box Steps: Open the Microsoft Visual Basic for ...

How to Create a Dialog Box in Excel – 3 Examples

Why Is Excel Changing My Numbers to Zero: 4 Solutions

Jul 1, 2024

We're going to use the following dataset, into which we inputted numbers containing more than 15 digits. If you notice, the inputted number ...

Why Is Excel Changing My Numbers to Zero: 4 Solutions

How to Stop Excel from Changing the Last Number to 0 – 4 Easy Methods

Aug 4, 2024

Why Does Excel Change the Last Number to 0? Excel can not store numbers that have more than 15 digits. It changes the 16th digit to 0. The ...

How to Stop Excel from Changing the Last Number to 0 – 4 Easy Methods

How to Enter 16 Digit Number in Excel (3 Simple Ways)

Jul 29, 2024

We're going to use a dataset of Argentine Football Players’ salaries in club football. We have organized the data in the Name, Team, Salary, and ...

How to Enter 16 Digit Number in Excel (3 Simple Ways)

How to Display Long Numbers in Excel (4 Easy Methods)

Jun 18, 2024

Method 1 – Formating a Cell as Text to Display Long Numbers in Excel STEPS: Select the cells where you want to enter the long numbers. ...

How to Display Long Numbers in Excel (4 Easy Methods)

How to Highlight Cells in Excel but Not Print (2 Simple Ways)

Nov 11, 2025

Sometimes, we highlight cells in Excel depending on values or specific conditions by using some Fill Colors. But when printing, we do not want these ...