Excel Basics

How to Attach Documents in Excel (3 Suitable Ways)

Undoubtedly, Excel is a popular and useful tool for summarizing large sets of data. Now, wouldn’t it be great if we could attach documents in Excel? ...

How to Select an Entire Column in Excel (5 Quick Methods)

While working in Microsoft Excel sometimes we need to select an entire column so that we can edit and organize data according to our choice. It might ...

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

Metabolic Age Calculator in Excel (3 Applications)

We all know the numerical age from our date of birth. However, metabolic age indicates a different type of number that indicates the body is ...

How to Reply to a Comment in Excel (3 Easy Ways)

Looking for ways of how to reply to a comment in Excel? Then, this is the right place for you. Sometimes, an Excel worksheet is used by several ...

How to Format Comments in Excel (2 Easy Ways)

Most likely, you know the ways of adding comments in Excel but get troubled while formatting the comments in Excel. Is that correct? If the answer is ...

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

Anchoring Comment Boxes in Excel (3 Easy Ways)

In this article, we will demonstrate anchoring the comment boxes in Excel. Anchoring comment boxes in a specific location is a tricky task. In Excel ...

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

How to Clear Cache in Excel (7 Ways)

  Method 1 - Disabling a Recent Document List Steps: Select the File tab on your Excel ribbon. Select Options from the left side of ...

How to Rename Files in a Folder in Excel (2 Easy Ways)

Here, we will need some files instead of a data set to perform my task. We will rename the following files which all are located in the same folder. ...

How to Apply Top and Bottom Border in Excel (3 Efficient Ways)

In this Excel tutorial, we will explain how to apply Top and Bottom border. In the image below, the cells on the left don't have borders, but on ...

Close the CTA

Advanced Excel Exercises with Solutions PDF

 

 

ExcelDemy
Logo