[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 Send an Email to an Address in a Cell using an Excel Macro- 2 Methods

This is an overview: Sub Send_Email_with_Attachment() Dim MyOutlook As Object Set MyOutlook = CreateObject("Outlook.Application") Dim MyMail ...

How to Fill Blank Cells with Formula in Excel (2 Easy Methods)

While working with Excel worksheets sometimes you will find blank cells between the dataset. For working advantages or while printing the dataset you ...

How to Restore Ribbon in Excel (5 Quick Ways)

You may find your Excel ribbon hidden for several reasons. In this article, you will learn 5 quick methods to restore your ribbon back in Excel with ...

Create a Report That Displays Quarterly Sales in Excel (With Easy Steps)

We have a worksheet that contains information on sales representatives, products, selling dates, and sales. Here's the overview of the sheet we'll ...

How to Round a Formula Result in Excel (6 Easy Methods)

How to Round a Formula Result in Excel: 6 Easy Ways 1. Applying ROUND Function Steps: Select an empty cell. Enter the ROUND ...

How to Make MIS Report in Excel for Sales: 3 Methods

Method 1 - Utilizing a PivotTable to Make a MIS Sales Report Steps: Select the cell range B4:F12. From the Insert tab, select PivotTable. ...

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 Turn Off Flash Fill in Excel (2 Easy Methods)

When Excel recognizes a pattern or sequential value, it suggests filling in the data to make our job easier. When the Flash Fill functionality is ...

Unprotect Excel Sheet Without Password Using VBA: 3 Simple Steps

Method 01 - Opening Visual Basic Editor Window We have a sheet VBA where we have some records of the products, and we have protected it with a ...

Excel VBA to Print As PDF and Save with Automatic File Name (9 Methods)

  Method 1 - Print Workbook to PDF & Save File Name Automatically in Excel In this example we will print the whole workbook and save the ...

How to Divide Without Using a Function in Excel (with Quick Steps)

In Microsoft Excel using multiply, divide, and sum are the most common tasks to do. Microsoft Excel provides many simple ways to divide numbers and ...

How to Create a Timeline with Dates in Excel (4 Easy Ways)

  Watch Video – Create a Timeline with Dates in Excel The dataset below contains information about a company's projects. It ...

How to Get Regression Statistics in Excel (3 Easy Ways)

Sometimes, we need to apply regression statistics in our dataset to know which factors impact the dataset. We can also find the relation between two ...

[Fixed!] Excel Files Not Opening from File Explorer (7 Quick Solutions)

There are several issues for which the excel file does not open properly and It’s bothering us if we can’t open a file. So here, I’ll try to ...

Close the CTA

Advanced Excel Exercises with Solutions PDF

 

 

ExcelDemy
Logo