Excel Basics

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

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

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

How to Protect Columns in Excel (6 Easy Methods)

Method 1 – Using the Context Menu  Steps: Select all cells in the spreadsheet by clicking on the triangular sign where row headers and column ...

Cannot Edit Excel File in Protected View (3 Reasons with Solutions)

We'll use a simple dataset to showcase the most common fixes for not being able to edit a file in Protected View. Cannot Edit Excel File in ...

How to Open Excel in Safe Mode (3 Handy Methods)

Method 1 - Start Excel in Safe Mode Using CTRL Modifier Key Steps: Click on the Excel icon or your Excel file. Hold the CTRL-key and press ...

How to Unprotect Excel Sheet If Forgot Password (4 Effective Methods)

We will use the following dataset that contains several different food types and their average price. Many commands under the Home tab are not ...

How to Backup Excel Files to a Flash Drive – 4 Methods

This is the sample dataset. Method 1- Manually Backup Excel Files to a Flash Drive Steps: Click File. Select Save As. ...

Advanced Excel Exercises with Solutions PDF

 

 

ExcelDemy
Logo