Excel Basics

How to Drag a Formula Horizontally with Vertical Reference in Excel

We have a dataset, Sales Report of Fruit, which shows Product ID, Sales Rep, Fruits, States, and Sales. We will show you how to drag the formula ...

How to Change Background Color in Excel (6 Easy Methods)

Method 1 - Using Fill Color to Change the Background Color in Excel Steps: Select the cell in which you want to change the background color. ...

How to Find Backup Files in Excel – 5 Easy Methods

You created Book1 and stored in Sheet1 data of students' marks. Your computer is turned off but the file wasn't saved. Method 1 - Getting ...

Protect Excel Sheet but Allow Data Entry (2 Handy Approaches)

In this article, we present 2 handy approaches to protect an Excel sheet while still allowing data entry. We'll use the following dataset of some ...

How to Apply a Theme to a Workbook in Excel (2 Suitable Ways)

In Microsoft Excel, we make worksheets and save files that you may need to look good. For this, you can use different fonts and colors but at times, ...

How to Reduce Decimals in Excel (10 Easy Methods)

To reduce decimal points in Excel: Select the cell where you want to decrease decimal points. Go to Home tab > Number group > Decrease ...

How to Keep Track of Inventory in Excel (With Easy Steps)

What Is Inventory Tracking? Inventory tracking involves monitoring and managing a company’s inventory levels, movements, and status. The primary ...

Excel Files are Not Opening in Separate Windows – 4 Solutions

Solution 1 - Opening Separate Windows using the Taskbar Go to the Windows Search Bar and enter Excel. Click Pin to taskbar. Open an ...

How to Unlock Grayed out Menus in Excel (5 Effective Ways)

Reasons for Menus to Be Grayed Out Working on a cell / Editing a cell. Password-protected spreadsheet. Workbooks are safeguarded. ...

How to Protect Formulas in Excel (Easy Steps)

Dataset Overview Suppose you have a dataset containing sales data, and you’ve used formulas to calculate revenues. Step 1 - Unlock All ...

How to Set Decimal Places in Excel with Formula (5 Ways)

Suppose we have a dataset that contains values with five decimal places, but we want to only display two decimal places. In this article, we ...

How to Open Excel Files in Separate Windows by Default (4 Methods)

Microsoft Excel is a spreadsheet that organizes numbers and data with formulas and functions. Excel analysis is used all over the world for financial ...

Trouble Shooting Excel Files Not Opening in Protected View (8 Solutions)

Solution 1 - Disable Protected View Mode in Excel to Access Files Go to the File menu. Select Options. In the Excel ...

How to Protect a Formula in Excel Allowing Data Entry – 2 Methods

The dataset showcases of names of employees, their salaries and costs. Enter the salary and cost to calculate the savings without using the savings ...

How to Convert Hours to Decimal in Excel (3 Easy Methods)

A lot of times, we work with Time in Excel worksheets. The input of office entry time, exit time, and calculating working duration in a specific ...

Close the CTA

Advanced Excel Exercises with Solutions PDF

 

 

ExcelDemy
Logo