Latest Blog Posts

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

Excel VBA: Protect Sheet with Password and Allow Filter

In this article, I’ll show you how can protect an Excel sheet with a password and also allow the filter there using VBA. Excel VBA: Protect ...

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

Macro to Convert Excel to Pipe Delimited Text File (3 Methods)

We have the following dataset. The contents of the dataset are relatively irrelevant to the code we'll use. Method 1 - Macro to Transfer ...

How to Protect Excel Cells from Being Edited (6 Suitable Methods)

When you work with an important dataset in your Excel including formulas, you need to protect those cells from being edited. Any alteration of your ...

How to Split Column in Excel Power Query: 5 Easy Methods

Method 1 - Using Delimiter Command to Split Column in Excel Using Power Query Step 1: Select your entire data range from your dataset. Select ...

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

How to Convert Excel to PDF without Converter (5 Effective Methods)

In Microsoft Excel, you may face the need to convert an Excel file to a PDF file to share and print without any changes. Convert excel to PDF without ...

How to Lock Cell Value Once Calculated in Excel (3 Simple Ways)

In Excel, users execute sensitive calculations which need to be unaltered once calculated. As a result, the Excel lock cell value once calculated is ...

How to Separate Time Using a Formula in Excel (7 Ways)

The dataset contains some employees’ office entry details for a particular company date in column B. We want to split the time in column C using ...

How to Unlock Cells in Excel When Scrolling (4 Easy Ways)

Sometimes, we lock a certain cell or a range of cells in the Excel worksheet for our convenience. However, it could also happen accidentally or ...

Close the CTA

Advanced Excel Exercises with Solutions PDF

 

 

ExcelDemy
Logo