Excel Basics

How to Copy File Names from Folder to Excel (4 Easy Methods)

Here’s our sample dataset which contains 5 files in a folder named ExcelDemy. We'll copy the names to an Excel sheet. Method 1 - Using the ...

How to Insert an Excel File into Another Excel File

To demonstrate how to insert one Excel file inside another, we'll use the following two Excel files. The first contains Sales of Febuary for some ...

How to Attach Zip File in Excel (3 Methods)

Method 1 - Attach Zip File as an Icon Select a cell in the worksheet where you want to place the zip file. Go to the ribbon and choose ...

How to Save a Copy of an Excel File: 3 Easy Methods

Method 1 - Applying Keyboard Shortcuts to Save a Copy of an Excel File Steps: Create an Excel file like the below screenshot. Ppress  ...

How to Insert Digital Signature in Excel (3 Quick Methods)

Suppose we have a dataset of a company’s Product Name and the Remaining Stock for the products. Let's insert a digital signature, using 3 different ...

How to Link Excel to Word for Automatic Updates

Dataset Overview Assume you have the following Excel dataset containing store-wise sales. Step 1 - Enable “Update Automatic Links at ...

How to Copy Table from Excel to Word (3 Easy Ways)

In this article, we’ll demonstrate 3 easy methods to copy a table from Excel to Word. To illustrate our methods, we'll use the following dataset, a ...

How to Insert Picture in Excel Comment (with Easy Steps)

  We'll use a dataset of some Students along with their Country of origin. Note: In the Microsoft Excel 365 version, Comments are ...

How to Insert a Multiple Page PDF into Excel – 2 Methods

Method 1 - Inserting a Multiple Page PDF File as a Text Object Steps: Open an excel file. In the Insert tab, click Text and select Object. ...

How to Change Author Name in Excel Comments (3 Easy Ways)

Here are 3 simple methods to change the author name in Excel Comments. Method 1 - Changing Author Name from the User Name Box This is a very simple ...

How to Set Excel Column Width to cm Unit (with Easy Steps)

To demonstrate how to change the column width into cm (centimeters) in Excel, we'll use a dataset of order details with multiple columns. ...

How to AutoFit All Columns in Excel (3 Methods)

  Method 1 - Double-Clicking Column Headers   To autofit all columns using double-click, follow these steps. Select the triangle ...

How to Change Excel Column Width in Pixels (3 Easy Methods)

  Method 1 - Change the Column Width with the Mouse We want to change the width of column C. Put the mouse cursor between column C and ...

Cannot Insert an Object in Excel – 5 Solutions

The 2021 Quarterly Sales Data showcased in B4:F14 contains the Location, and the four Quarters. You want to insert an object and Excel shows the ...

How to Export Facebook Comments to Excel: 2 Easy Methods

Method 1 - Use the Export Comments Website Steps: Write export comments and search on Google. Click on the exportcomments.com website link. ...

Advanced Excel Exercises with Solutions PDF

 

 

ExcelDemy
Logo