Excel Basics Archives - Page 95 of 176

How to Format Fraction to Percentage in Excel (2 Quick Methods)

Jul 12, 2024

We have some data in fraction format and need to convert the fractional numbers to the percentage format. Method 1 - Convert Fractions to ...

How to Format Fraction to Percentage in Excel (2 Quick Methods)

How to Add a Stacked Fraction in Excel: 5 Simple Methods

Jun 7, 2024

Method 1 - Using Fraction Format to Add a Stacked Fraction Steps: Select the cells C6:C10 and click Home > Number. Click on the drop-down ...

How to Add a Stacked Fraction in Excel: 5 Simple Methods

[Fixed] Excel Protected View Editing This File Type Is Not Allowed: 2 Solutions

Jul 3, 2024

Solution 1 - Disabling Protected View Settings ❶ Go to the File tab. ❷ Select Options. The Excel Options dialog box will pop up. ❸ ...

[Fixed] Excel Protected View Editing This File Type Is Not Allowed: 2 Solutions

How to Drag a Formula Horizontally with Vertical Reference in Excel

May 18, 2024

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 Drag a Formula Horizontally with Vertical Reference in Excel

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

May 8, 2024

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 Change Background Color in Excel (6 Easy Methods)

How to Find Backup Files in Excel – 5 Easy Methods

Aug 6, 2024

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

How to Find Backup Files in Excel – 5 Easy Methods

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

Jul 29, 2024

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

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

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

Nov 11, 2025

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 Apply a Theme to a Workbook in Excel (2 Suitable Ways)

How to Reduce Decimals in Excel (10 Easy Methods)

Jul 7, 2024

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 Reduce Decimals in Excel (10 Easy Methods)

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

May 4, 2025

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

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

Excel Files are Not Opening in Separate Windows – 4 Solutions

Aug 12, 2024

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

Excel Files are Not Opening in Separate Windows – 4 Solutions

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

Jun 24, 2024

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

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

How to Protect Formulas in Excel (Easy Steps)

Jul 21, 2024

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

How to Protect Formulas in Excel (Easy Steps)

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

Jun 18, 2024

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 Set Decimal Places in Excel with Formula (5 Ways)

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

Nov 11, 2025

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