Excel Basics Archives - Page 138 of 176

How to Print Worksheet with Comments in Excel (5 Easy Ways)

Nov 11, 2025

Excel is a powerful tool to enter all sorts of data. Sometimes, we need to add comments to our worksheets and print them. In this article, we will ...

How to Print Worksheet with Comments in Excel (5 Easy Ways)

How to Remove Compatibility Mode in Excel (2 Easy Ways)

Jun 17, 2024

Opening an Excel file that was originally saved in an older version of Excel (i.e., Excel 1997 to 2003) will require Excel to open the workbook in ...

How to Remove Compatibility Mode in Excel (2 Easy Ways)

How to Remove #DIV/0! Error in Excel (5 Methods)

Jun 14, 2024

Excel shows the Divided by Zero(#DIV/0!) error when the denominator of any formula is zero or empty. Let's replace this with custom text, with the ...

How to Remove #DIV/0! Error in Excel (5 Methods)

How to Copy Hyperlink in Excel (4 Easy Methods)

Aug 6, 2024

Method 1 - Use the Mouse Click to Copy a Hyperlink in Excel In the following dataset, we will copy the hyperlink of the company “Exceldemy”. ...

How to Copy Hyperlink in Excel (4 Easy Methods)

How to Edit Hyperlink in Excel :5 Quick & Easy Methods

Aug 6, 2024

1. Edit Hyperlink through a Simple Right-Click in Excel Steps: Right-click on Cell B5 and select the Edit Hyperlink. The Edit ...

How to Edit Hyperlink in Excel :5 Quick & Easy Methods

How to Sort by Month in Excel – 4 Methods

Aug 6, 2024

This is an overview. Method 1 - Using a Custom Sort Option to Sort by Month in Excel Step 1: Select C4:C13, and go to: Home → ...

How to Sort by Month in Excel – 4 Methods

How to Remove Panes in Excel (4 Methods)

Nov 11, 2025

Panes allow you to freeze one portion of your Excel datasheet and scroll the other portion separately. Though it is a useful feature, you may need to ...

How to Remove Panes in Excel (4 Methods)

How to Sort Merged Cells in Excel: 2 Easy Methods

Jul 5, 2024

Method 1 - Unmerge First to Sort Merged Cells in Excel 1.1 Single Column Steps: Part-1 Select the cells that we need to sort. Click on the ...

How to Sort Merged Cells in Excel: 2 Easy Methods

Fix: Excel Remove Duplicates Not Working (3 Solutions)

Jun 18, 2024

Reasons Why Excel Is Not Recognizing Duplicates Digits After Decimal: For example, 5 and 5.00 are the same. But MS Excel counts them as two ...

Fix: Excel Remove Duplicates Not Working (3 Solutions)

How to Merge Text from Two Cells in Excel (7 Methods)

Jul 3, 2024

We’ll use the following dataset, with a list of first and last names. We'll merge those into full names in column D. Method 1 - Merging ...

How to Merge Text from Two Cells in Excel (7 Methods)

How to Remove Header and Footer in Excel (6 Methods)

Jun 16, 2024

Consider you have the following dataset with a Header. The dataset also has a Footer. Let's remove the Header and Footer from this ...

How to Remove Header and Footer in Excel (6 Methods)

How to Remove Hyperlink from Excel (7 Methods)

Aug 6, 2024

Method 1 - Remove a Single Cell’s Hyperlink from Excel We will remove the hyperlink only for “Exceldemy”. STEPS: Select cell C5. ...

How to Remove Hyperlink from Excel (7 Methods)

How to Insert a Column Shortcut in Excel (4 Methods)

Jun 17, 2024

Method 1 – Using Shortcut Keywords 1.1 Using SHIFT + CTRL + Equal (=) Shortcut To add a column left of the “Name” column, Select all of ...

How to Insert a Column Shortcut in Excel (4 Methods)

How to Remove Comments in Excel (7 Methods)

Jul 12, 2024

Dataset Overview We have a dataset containing student details (Name, ID, Scores). In Cell B8 and C12, there are two notes. Additionally, in Cell D7 ...

How to Remove Comments in Excel (7 Methods)

Shortcuts to Insert New Row in Excel (6 Quick Methods)

Nov 11, 2025

Rows run horizontally along the worksheet. In Excel rows are denoted by numerical values like 1,2,3,4 etc. In this tutorial we will see 6 methods to ...