Excel Basics

How to Make a Cell Read-Only in Excel – 2 Methods

This is the sample dataset. Method 1 - Making a Cell Read-Only by Using the 'Format Cells' Command STEPS: Go to the file location ...

Excel Not Responding When Deleting Rows: 4 Solutions

Method 1 - Sort Data before Deleting Steps: Add Index to observe the Sort effect. Go to Data and select Sort. In the Sort by ...

[Fixed!] This Excel Workbook Was Opened in Read-Only Mode

Method 1 - Enabled Read-Only Attribute Makes Excel Workbook Open in Read-Only Mode STEPS: Select the Excel file and right-click your mouse. ...

How to Change Default Currency in Excel (4 Simple Methods)

The following Employee List contains ID, Name and Salary columns. We can see in the Salary column that there is a dollar sign ($). This dollar sign ...

How to Copy from Excel to Word Without Losing Formatting: 4 Methods

Method 1 - Use Copy and Paste Feature Steps: Select the data in the Excel workbook. Press CTRL+C to copy the Excel data. Place the ...

Fix Excel Not Responding and Save Your Work

  How to Understand If Excel Is Not Responding While using Microsoft Excel, the software may hang or freeze. If this occurs, wait for a bit. ...

Unable to Open Excel Files Directly by Clicking the File Icon – 7 Solutions

Solution 1 - Turn Off Excel Add-ins Steps: Go to File. Select Options. Click Add-ins. Choose either Excel Add-ins or COM ...

How to Remove Protected View in Excel (3 Quick Methods)

To explore the methods, we’ll use the following dataset representing the hourly rate of some ExcelDemy content writers. Method 1 - Remove ...

How to Break Links in Excel (3 Quick Methods)

In this article, we will present some quick methods to Break Links in Excel. To Break Links means to end the connection to the external references in ...

How to Convert Excel Data into Word Labels (Easy Steps)

Step 1 - Prepare an Excel File with Labels Data Organize the data for your mailing labels in an Excel spreadsheet. For instance, include fields ...

How to Open Two Excel Files Side by Side (3 Methods)

For Excel 2010 and Older Version Users In Excel 2010 and earlier versions, the Multiple Document Interface (MDI) allows you to work with multiple ...

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

Advanced Excel Exercises with Solutions PDF

 

 

ExcelDemy
Logo