Excel Basics Archives - Page 3 of 146

Excel Basics

How to Turn on Autocomplete in Excel (3 Easy Ways)

Oct 4, 2022 Excel Basics

In MS Excel, users often need to enter a lot of data. Entering each data manually is a laborious task. The autocomplete feature of Excel lessens ...

How to Swap Text in Excel (4 Easy Methods)

Oct 2, 2022 Excel Basics

In this article, we will learn to swap text in Excel. Sometimes, an Excel sheet may contain texts in the wrong order. To understand them, you need to ...

How to Swap Axis in Excel (2 Simple Ways)

Oct 2, 2022 Excel Basics

While working in Excel, sometimes we need to swap axis to gain better visibility of our data in a chart. Often we encounter some charts, where all ...

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

Sep 25, 2022 Excel Basics

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

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

Sep 22, 2022 Excel Basics

Representing data clearly and concisely is an essential skill in this data-driven world. As a result, representing data in a table has become crucial ...

How to Cut Multiple Cells in Excel (3 Simple Methods)

Sep 25, 2022 Excel Basics

When we work in Excel sometimes we need to move data from one or multiple cells to another cell or multiple cells. There is no move option in Excel. ...

How to Add Draft Watermark in Excel (3 Easy Ways)

Oct 4, 2022 Excel Basics

When we share any Excel file then someone can use that file under his name. But if we use a watermark then we can keep our copyright easily. There ...

How to Swap Columns and Rows in Excel (6 Easy Methods)

Oct 2, 2022 Excel Basics

Microsoft Excel is a powerful software. We can perform numerous operations on our datasets using excel tools and features. There are many default ...

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

Oct 2, 2022 Excel Basics

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 Move Watermark in Excel (with Easy Steps)

Sep 25, 2022 Excel Basics

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 Export HTML Table with Formatting to Excel

Sep 21, 2022 Excel Basics

Sometimes you may need to export HTML table to Excel with formatting for the convenience of your work. To gain a clear grasp of this topic, you have ...

How to Check Spelling and Grammar in Excel (4 Ways)

Sep 20, 2022 Excel Basics

We are using Excel sheets with people from a wide range of backgrounds. It will be pretty annoying and can create an embarrassing situation if the ...

How to Copy a Sheet If Name Already Exists in Excel

Sep 20, 2022 Excel Basics

Sometimes, when we try to copy a sheet from one workbook to another, you may notice Excel will show you a warning due to the same range. We have to ...

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

Oct 2, 2022 Excel Basics

When you try to move or copy one or more worksheets to a destination sheet in Excel, the Name Conflict dialog box may appear referring to an error in ...

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

Sep 21, 2022 Excel Basics

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