Excel Basics

How to Convert Decimal to Fraction in Excel (4 Approaches)

Human beings like to decorate their things. They even like to reorganize their number format. Sometimes, they convert decimal numbers to fraction in ...

How to Change Excel Cursor Movement Logical vs Visual

Method 1: Using Excel Options Steps: ➤ Go to the File Tab. ➤ Select the Options Option. The Excel Options dialog box will open up. ➤ ...

How to Scroll One Row at a Time in Excel – 4 Methods

Observe the GIF: Why Is Excel Not Scrolling One Row at the Time? Row Height is manually specified. Mouse settings are set ...

How to Fix If The Excel Cursor Is Stuck on The White Cross (6 Possible Solutions)

  Solution 1 - Enable the Drag and Drop Option Steps: Open File > Options. When the Excel Options window appears, select ...

[Fixed!] Excel Cursor Stuck in Drag Mode (5 Possible Solutions)

The cursor getting stuck in drag mode can be annoying in our everyday usage, especially in spreadsheet software like Excel. From an unintentional ...

How to Stop Arrow Keys from Scrolling in Excel: 3 Easy Methods

Method 1 - Using Hardware Keyboard Scroll Lock Key to Stop Arrow Keys from Scrolling in Excel Steps: Press the SCROLL LOCK button on the ...

How to Fix the Excel Cursor That Changed to a Plus Sign (Quick Solution)

Dataset Overview To explain the steps of the solution, we will use a dataset that contains information about the sales amount for the first two ...

How to Insert Greater Than or Equal to Symbol in Excel (5 Quick Methods)

Let's use the following dataset that represents a student’s obtained grade and marks range to demonstrate how to insert the "greater than or equal" ...

Excel Not Responding When Opening File (8 Handy Solutions)

Microsoft Excel is by far the most broadly used form tool by enterprises or individuals for calculation, charting, graphing data, etc. Though Excel ...

How to Drag Formula in Excel with Keyboard (7 Easy Methods)

The following dataset table has 'Name', 'Salary', 'Increment', and 'Total Salary' columns. We will use a formula to calculate the 'Total Salary' in ...

How to Apply Retrospect Theme in Excel

Everyone is a fan of beauty. We admire the beautiful things. We even try to beautify our workbook. There are so many themes built-in Microsoft Excel ...

How to Type Diameter Symbol in Excel (4 Quick Methods)

  Method 1 - Use the Insert Tab to Type a Diameter Symbol in Excel Steps: Select cell C5. Go to the Insert tab and select ...

How to Insert Symbol in Excel Footer (3 Effective Ways)

If you are searching for ways to insert a symbol in the Excel Footer, then this article will be helpful for you. So, let’s get into the main article. ...

How to insert a Plus Sign in Excel without a Formula – 3 Methods

The dataset showcases employee information: Name, Department, and Phone.   Method 1- Using the Custom Format Feature to Insert a ...

How to Protect Formulas Without Protecting Worksheet in Excel

While working with Excel, we sometimes need to share files with others. Whenever the file is distributed with other authors and users, it allows the ...

Close the CTA

Advanced Excel Exercises with Solutions PDF

 

 

ExcelDemy
Logo