Excel Basics

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

How to Remove Notes in Excel (5 Easy Ways)

Notes are used as reminders or explainers in Excel 365, replacing the Comments used in previous versions of Excel. In this article, we will use ...

How to Change Decimal Places in Excel (3 Effective Ways)

Method 1 - Using Increase Decimal and Decrease Decimal Buttons to Change Decimal Places in Excel We'll use a single number as an example. ...

How to Apply Parallax Theme in Excel (With Easy Steps)

Step 1 - Create a Dataset and a Table We'll use a sample dataset for a company's quarterly sales in 2022. This contains employee names and the ...

Close the CTA

Advanced Excel Exercises with Solutions PDF

 

 

ExcelDemy
Logo