Excel Basics

How to Reference Comments in Excel (3 Easy Methods)

Sometimes we need to create comments in Excel because it helps to remember any information for the user or the other users. If you don’t know how to ...

How to Print Notes in Excel (2 Simple Methods)

This tutorial will demonstrate how to print notes in Excel. In Microsoft Excel 365, we use notes as reminders. The notes in Excel 365 look like ...

How to Change Background Color to Grey in Excel (Step by Step)

In this article, we will explain how to change the Excel background color to grey. Unfortunately we can’t simply change the Excel background color ...

How to Hide Notes in Excel: 3 Handy Approaches

Method 1 - Hiding Notes in Excel Through Review Tab 1.1 Hiding All Notes STEPS: Go to Review ➤ Notes. Select Show All Notes. All ...

Fill Handle Not Working in Excel (5 Solutions)

Solution 1 - Enable the Fill Handle Option When working with a dataset in Excel, you might encounter situations where the fill handle is not ...

How to Edit Footer in Excel: 3 Quick Methods

Method 1 - Edit Footer from Page Layout View Steps: Go to the View tab at the top of your screen. Select Page Layout to shift to the Page ...

How to Insert Degree Symbol in Excel (7 Methods)

The degree (°) symbol is used in different fields like temperature, geo-location, trigonometry, etc. When we use those fields in Excel, we need to ...

Vlookup to Copy Comments in Excel (with a UDF)

We want to look up a value along with the comments (if any) in the range B5:C9. The lookup value is given in cell E5. We'd typically use a VLOOKUP ...

How to Insert the Less Than or Equal to Symbol in Excel (5 Methods)

In the following picture, Sara got an A+ in Biology, but her marks are unknown. However, an A+ means she has received at least an 80, which we'll ...

How to Add Comment in Excel: 4 Handy Methods

Method 1 - Using Context Menu to Add Comment in Excel Steps: Select the cell you want to add a comment to. In this case, select cell D7. D7 is ...

[Solved!] Insert Comment Not Working in Excel (2 Simple Solutions)

Possible Reasons for Insert Comment Not Working in Excel You can insert a new comment or note from the Context Menu (see the image below). ...

How to Copy Comments in Excel: 2 Suitable Methods

Method 1 - Using Paste Special Tool to Copy Comments in Excel Steps: Click on the commented cell, which is the B6 cell, here. Hover over the ...

How to Save Multiple Sheets in Excel – 6 Methods

The dataset contains names, Residence and Company Name. Method 1 - Using a Keyboard Shortcut to Save Multiple Sheets in Excel Steps: ...

Excel Cursor Is Not Changing to Plus (5 Solutions)

Usually, when we select any cell and hover the cursor on the bottom right corner, the cursor changes into a thin black plus sign, namely the Fill ...

How to Write a Fraction in Excel (4 Methods)

Dataset Overview We have taken a dataset that consists of products with their amount (Weight) in Kg. Method 1 - Using Fraction Format ...

Close the CTA

Advanced Excel Exercises with Solutions PDF

 

 

ExcelDemy
Logo