Excel Basics Archives - Page 47 of 176

[Fixed!] Excel Cutting Off Text When Printing to PDF

Nov 11, 2025

If you are looking for some special tricks to solve the problem of “Excel cutting off text when printing to PDF”, you've come to the right place. In ...

[Fixed!] Excel Cutting Off Text When Printing to PDF

How to Create a Table with Merged Cells in Excel (4 Easy Methods)

Jul 4, 2024

One of the major drawbacks of an Excel table is that you can not create a table with merged cells. Let's assume you have a data set that consists of ...

How to Create a Table with Merged Cells in Excel (4 Easy Methods)

How to Swap Non-Adjacent Cells in Excel (3 Easy Ways)

Nov 11, 2025

If you are looking for ways to swap non-adjacent cells in Excel, this article is for you. Swapping values can be time-saving for correcting any ...

How to Swap Non-Adjacent Cells in Excel (3 Easy Ways)

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