Excel Basics

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

Do you have a lot of files in your file explorer to copy the names in an Excel worksheet and searching ways to avoid manually copying them? Then we ...

How to Insert an Excel File into Another Excel File

Sometimes, we may deal with a lot of data in our worksheets. So it became very hard to maintain one worksheet for all the data. Maintaining two or ...

How to Attach Zip File in Excel (3 Quick Tricks)

While working on Excel sometimes we want to attach files to the worksheet. For example, we may wish to include a zip file in the worksheet. This ...

How to Save a Copy of an Excel File (3 Easy Ways)

This tutorial will demonstrate how to save a copy of an Excel file with a new name. If you have a particular Excel file that you need to use ...

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

While working in Microsoft Excel sometimes we need to insert digital signature to make the document authorized. Often users also add digital ...

How to Link Excel Cell to Word for Automatic Update

Excel is one of the most used spreadsheet applications to work with numbers and data. Microsoft Word, on the other hand, is a leading word-processing ...

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

After working in Excel, we often need to copy a table from an Excel worksheet to a Word file. You can think of creating the same table again in Word ...

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

When you make an Excel file and share it with a group of people, inserting a comment makes the Excel file very user-friendly. You may know how to add ...

How Do I Insert a Multiple Page PDF into Excel (2 Useful Methods)

Many times, while working in Excel, we need to insert data from a third-party file type such as a pdf in the workbook. This can be done either by ...

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

In every Microsoft Excel Worksheet, there is the name of the author of that file. However, we can change the author's name. It’s not a tough task at ...

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

In this article, I will show you how you can change the Excel column width in cm. For measurement purposes, you may need to change or set the column ...

How to AutoFit All Columns in Excel (3 Ways)

To autofit all columns in Excel, follow these steps: Select all cells by pressing Ctrl+A on your keyboard. Place your mouse cursor at the ...

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

Changing the column width in Excel is a must while working as the length of our input may be larger than the column width. In that case, the cell ...

[Fixed!] Cannot Insert Object in Excel

Have you ever faced a situation where you could not insert an object in Excel and you’re not sure how to fix it? Then, this article can help you ...

How to Export Facebook Comments to Excel (2 Easy Ways)

In this modern era, we need to extract Facebook comments data very frequently. Now, it is time-consuming and tiring to extract and store these data ...

Advanced Excel Exercises with Solutions PDF

 

 

ExcelDemy
Logo