Excel Basics

How to Adjust Print Settings in Excel (8 Suitable Tricks)

Whenever you want to print any documents or any things in Excel, you may adjust the default print settings for getting the best output based on your ...

Excel Hyperlink with Shortcut Key (3 Uses)

Sometimes you may need to refer to a web page for the data you’ve used in your Excel sheet. Hyperlink in Excel allows you to visit a web page or ...

How to Remove Watermark in Excel (3 Ways)

There are multiple ways to insert a watermark in Excel. Depending on the methods, you’ve inserted a watermark, multiple methods are available to ...

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

In this article, we demonstrate how to remove Compatibility Mode in Excel. Compatibility Mode is a viewing mode in Excel for all versions of Excel ...

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

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 Copy Hyperlink in Excel (4 Easy Methods)

In this article, we will explain how to copy a hyperlink in Excel. While working in Excel, it is a very common piece of work to copy a hyperlink. ...

How to Edit Hyperlink in Excel (5 Quick & Easy Ways)

In this tutorial, I will explain how to edit a hyperlink in excel. Usually, we use hyperlinks often to serve different purposes such as: to go to a ...

How to Sort by Month in Excel (4 Methods)

Excel, as everyone's favorite spreadsheet program, mercifully has several tools for sorting data, including the sort feature and functions like SORT ...

How to Sort Merged Cells in Excel (2 Easy Methods)

This article illustrates how to sort merged cells in Excel with step-by-step examples. The default sorting feature prevents sorting merged cells in a ...

Fix: Excel Remove Duplicates Not Working (3 Solutions)

Trying to remove duplicates and it’s not working in your Excel worksheet? This article will explain the possible reasons behind the issue and will ...

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

Sometimes we need to merge multiple cells into one to get the desired output. Undoubtedly, Excel provides some quickest features to do that. In this ...

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

Header and Footer contains different information of a document such as chapter name, author name, page number, publisher logo etc. in the top and ...

How to Remove Hyperlink from Excel (7 Methods)

In this article, we will discuss the process to remove the hyperlink from Excel. In Microsoft Excel, we use hyperlinks to directly go to a particular ...

Shortcuts to Insert Column in Excel (4 Easiest Ways)

We are often required to insert a column to an existing dataset in Excel. This is a really easy task and you can do it in various ways. In this ...

How to Remove Comments in Excel (7 Quick Methods)

In this tutorial, I will describe some easy and quick ways to remove comments from Excel sheets. Comments are useful while drafting Excel files. ...

Advanced Excel Exercises with Solutions PDF

 

 

ExcelDemy
Logo