Excel Basics

How to Insert Date in Footer in Excel (3 Ways)

Footer is often used in our professional life. Some people use their organization's name as a signature mark while some use their own name. Sometimes ...

How to Hyperlink to Cell in Same Sheet in Excel (5 Methods)

To demonstrate our methods, we’ll use the following dataset. Method 1 - Using Insert Link Feature Steps: Select cell B12. From the ...

How to Print Horizontally in Excel (4 Methods)

When users have a larger dataset it’s convenient to print horizontally in Excel. Though Excel by default prints worksheets in Portrait Page ...

How to Insert a Column to the Left in Excel (6 Methods) 

We'll use a simple dataset where the Number of Visits for each website is provided along with the Names and Categories of the Sites. We want to add a ...

Extract Filtered Data in Excel to Another Sheet: 4 Methods

Method 1 - Extract Filtered Data to Another Sheet Using Copy-Paste Method in Excel If you don’t need to perform additional table transformations ...

How to Space Down in Excel: 3 Methods

Method 1 - Using Shortcut to Space Down in Excel Steps: Double-click on Cell C5 and click before the text 1994 as we want to space it down, and ...

How to Remove Filter by Color in Excel (5 Methods)

We have a dataset where we already applied Filter by Color. We want to remove the Filter by Color execution. In this case, we only applied the Filter ...

How to Delete Blank Cells and Shift Data Left in Excel (3 Methods)

If you want to Delete Blank Cells and Shift Data Left in Excel, this article will be very helpful for you. Here, we will walk you through 3 effective ...

How to Sort by Column Without a Header – 5 Methods

This is an overview: This is the sample dataset. To sort the dataset by names or sales. If Excel can identify headers, it will ...

How to Activate Multiple Hyperlinks in Excel (4 Ways)

In the following dataset, we have a list of some famous e-commerce sites and their website addresses. The website links are not activated so they ...

How to Print Excel Sheet with Header on Every Page in Excel (3 Methods)

There are many kinds of print types in Microsoft Excel. The print Excel sheet with the header on every page is one of them. It is an eye-catching ...

How to Sort Data in Alphabetical Order in Excel: 8 Methods

Method 1 - Sort Value in Alphabetical Order in Excel with Sort Featur STEPS: Select the range B5:D10. Go to Home ➤ Editing ➤ Sort & ...

The Sort and Filter is Not Working in Excel

The sample dataset showcases Number of Visits of websites, their Name and Category. Dates and Platforms are also given. Solution 1 - There ...

How to Print Gridlines with Empty Cells in Excel (2 Methods)

Microsoft Excel does not print with gridlines automatically. Gridlines are helpful with viewing data as it separates row and column from one another. ...

How to distribute Columns Evenly in Excel – 5 Methods

The sample dataset showcases players, age, and countries. Method 1 - Distribute Columns Evenly Using the Format Option Steps Click ...

Close the CTA

Advanced Excel Exercises with Solutions PDF

 

 

ExcelDemy
Logo