Excel Basics

[Fixed!] Why Is My Excel Formula Not Updating Automatically (8 Solutions)

This sample dataset holds the income and tax to be paid by each person. Here, income and tax on income are two dependent variables.   ...

[Fixed!] Excel File Not Opening on Double Click (8 Possible Solutions)

Solution 1 - Uncheck the “Ignore other applications that use DDE” Option The dynamic data exchange (DDE) protocol is one of the methods for ...

How to Protect Excel Sheet with Password (3 Quick Approaches)

Method 1 - Use the ‘Protect Sheet’ Button to Protect an Excel Sheet with Password STEPS: Select Review and choose Protect Sheet. A ...

[Fixed!] Excel Freezes When Copying and Pasting (13 Possible Solutions)

First and foremost, try checking the system requirements for your version of Microsoft office. If your system meets the requirements and Excel is ...

How to Convert Word to Excel with Columns (2 Methods)

We'll use a simple dataset to showcase converting Word tables to Excel datasets. Convert Word to Excel with Columns: 2 Easy Methods We ...

[Fixed!] Excel Files Open as Read Only from Network (8 Solutions)

Here are some of the most common reasons behind this error. Corrupted Excel Workbook Unsupported Add-ins Malware and Antivirus ...

How to Protect Excel File with Password (3 Quick Methods)

For a confidential workbook, we just need to protect it with a password for security purposes. Excel has several ways to do it easily. You can set ...

How to Protect Formulas but Allow Copy in Excel (3 Simple Methods)

This tutorial will demonstrate how to protect Excel formulas but will allow you to copy them. Suppose, we will share our Excel file with other users. ...

How to Prevent Formula from Being Deleted in Excel: 3 Methods

Method 1 - Locking Cells to Prevent Formula from Being Deleted in Excel STEPS: Select a cell in your dataset and press Ctrl + A to select all ...

[Fix:] Excel Formula Not Working Returns 0

If your Excel formula not working returns 0, this article will help you to solve the problem. Here, we’ll describe 4 reasons that are responsible for ...

Excel Not Responding When Running Macros (9 Possible Solutions)

Overview Getting the following pop-up when running macros? Large files, internal code issues, and complicated macros are just a few things that can ...

How to Undo Changes in Excel after Save and Close (2 Methods)

Let's use a sample dataset that contains columns for Employee Name, Department, and Salary data. We'll make some changes and undo them after you've ...

How to Recover Corrupted Excel File (8 Possible Ways)

Method 1 - Using the Open and Repair Tool of Microsoft Excel STEPS:  Go to the File tab > Open. Set the file destination in the ...

How to Copy Excel Table to Word with Gridlines (2 Simple Methods)

This article will show you how to copy table from Excel to Word with gridlines with proper illustrations. How to Copy Table from Excel to ...

[Fixed!] Excel Attachments Not Opening from Outlook (6 Quick Solutions)

The sample dataset contains the dataset of 10 fruit items and their amount. The name of the fruit items is in column B, their quantity is in column ...

Close the CTA

Advanced Excel Exercises with Solutions PDF

 

 

ExcelDemy
Logo