Latest Blog Posts

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

How to Share Excel File for Multiple Users

We have an Excel file named Sales Report of Frutis.xlsx and need to share the file with multiple users. Method 1 - Share the Excel File ...

How to Send Bulk Email from Outlook Using Excel (3 Ways)

We will use the sample list below and try to send emails to these email ids with the help of Excel, Outlook, Word, and Power Automate using 3 ...

How to Convert CSV to Excel with Columns (5 Methods)

  Method 1 - Applying Save As to Convert CSV Files to Excel with Columns We have opened our sample CSV file in Notepad. The data in the file ...

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

Excel VBA: Unprotect Workbook with Password: 7 Practical Methods

Method 1 - Unprotect a Single Workbook with a Password in Excel VBA Task: Unprotect the workbook named workbook_1.xlsx inside the Exceldemy folder ...

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 Transpose Rows to Columns Based on Criteria in Excel (2 Ways)

Download the Practice Workbook Transpose Rows to Columns with Criteria.xlsm 2 Handy Approaches to Transpose Rows to Columns Based on ...

Copy Table from PDF to Excel with Formatting (2 Effective Ways)

The table is in a PDF, and our goal is to copy the table from PDF to Excel with formatting. Method 1 - Importing Data from PDF and Copy a ...

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

Close the CTA

Advanced Excel Exercises with Solutions PDF

 

 

ExcelDemy
Logo