Excel Basics

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

[Fixed!] Excel Keeps Crashing When Opening File (11 Possible Solutions)

  Solution 1 - Start Excel in Safe Mode    Steps: Press and hold down the Ctrl key when starting Excel. Press 'Windows ...

How to Fix Excel Not Responding Without Closing (16 Possible Solutions)

Method 1 - Wait till Excel Responds Again You may not want to close excel when it stops responding because you do not want to lose your unsaved ...

[Fixed!] Protect Workbook in Excel Not Working (with Quick Solution)

In the dataset, we have a .csv file that contains sales information of a store in a week. We will apply protection on this file. Protect ...

Close the CTA

Advanced Excel Exercises with Solutions PDF

 

 

ExcelDemy
Logo