Excel Basics

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

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 Display Long Numbers in Excel (4 Easy Methods)

  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 Highlight Cells in Excel but Not Print (2 Simple Ways)

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

Why Is Excel Changing My Numbers: 4 Methods

Method 1 - Enabling Auto-Insert Decimal Point Option is Changing the Numbers in Excel Make a marks list of a subject for the student. In ...

How to Stop Excel from Changing Numbers to Scientific Notation (7 Methods)

Dataset Overview Looking at the Sales Data in cells B4:D14, where we have the Customer Name, Invoice Number, and Sales in USD. The Invoice Number, ...

How to Edit AutoComplete in Excel (4 Easy Methods)

Excel has some auto features that save a lot of time and give more speed while we are typing or inputting data. AutoComplete is one of them and we ...

[Fixed!] Excel Changing Dates to Random Numbers (3 Solutions)

Sometimes, when we input dates or do some operation with the dates, they change into random numbers. As a result, we cannot see the original dates. ...

How to Stop Excel from Auto Formatting Numbers (3 Easy Ways)

As can be observed in the animation below, by default Excel changes the format of numbers after they've been input. It can become tiresome having to ...

How to Stop Autocorrect in Excel for Dates (3 Quick Ways)

Excel has extraordinary autocorrect features. When you type some data in Excel cells, it auto-corrects the data type sometimes which might create ...

[Solved!] Long Numbers Are Displayed Incorrectly in Excel

Working with long numbers (more than 11 digits) can be a problem in Excel. There are some auto formatting options in the program to keep the ...

How to Stop Excel from Rounding 16 Digit Numbers (2 Easy Ways)

The Reasons Behind Excel Rounding Numbers Excel maintains IEEE 754 in storing numbers. Numbers containing digits up to 15 will be displayed as ...

Why is Excel Changing My Numbers to Decimals? (2 Solutions)

Consider the following dataset where students' marks are entered in column C. While entering 62 in cell C5, it unexpectedly becomes 0.62. We have ...

How to Turn Off Spell Check in Excel (with Easy Steps)

Excel or other Microsoft Office applications has some intelligent features. Spell Check is one of them. While writing in an Excel sheet, you can make ...

How to Color Code Cells in Excel (3 Methods)

We'll use a sample dataset of students and their grades to color code cells. Why Is Color Coding Cells in Excel Important? Visual ...

How to Flip Table in Excel (2 Quick Ways)

Although Excel offers no direct ways to do so, in this article we will demonstrate how to flip data by columns and rows using Excel’s built-in ...

Close the CTA

Advanced Excel Exercises with Solutions PDF

 

 

ExcelDemy
Logo