Excel Basics

How to Apply All Borders in Excel (3 Methods)

The All Borders option is a formatting feature that allows you to apply a border around the entire selected range of cells. This means that a border ...

How to Create Column Headers in Excel: 3 Methods

Method 1 - Creating Column Headers by Freezing a Row Steps: Click the View tab. Choose the frame right inside the row and column to ...

How to Change Page Number in Excel (With Easy Steps)

Download the Practice Workbook Change Page Number.xlsx 2 Easy Steps to Change the Page Number in Excel We have a dataset of some Product ...

How to Change Column Headings in Excel (2 Ways)

Here's a sample dataset containing PC parts, prices, and available quantities. We'll change the column headings in the file from letters to numbers. ...

[Solved:] Print Area Is Grayed Out in Excel (2 Easy Solutions)

Excel is the most useful tool to deal with massive datasets. We can perform myriads of tasks of multiple dimensions in Excel. While working in Excel, ...

Unhide Columns Is Not Working in Excel (4 Issues & Solutions)

In many cases, you might find that the unhide columns option is not working in Excel. Sometimes, the solutions to this problem are very easy but hard ...

How to Add Minor Gridlines in Excel (3 Easy Ways)

Need to learn how to add minor gridlines in Excel? Minor gridlines are horizontal and vertical lines that run through your chart layout to represent ...

How to Set Print Area with Blue Line in Excel: 5 Easy Ways

Method 1 - Set Print Area from Page Layout Tab Select the area you want to print> go to the Page Layout tab> click Print Areas> select ...

How to Change Border Color in Excel (3 Suitable Ways)

In Microsoft Excel, cells are distinguished by cell borders. But sometimes border colors are not visible. In that case, we need to change it. In ...

[Fixed!] Why Is My Excel Not Opening Files?

There may be some instances where your Excel will not respond to opening files. Sometimes, the solutions are very easy but hard to find. This article ...

How Do You Fix Missing Gridlines in Excel (5 Easy Ways)

Without gridlines, Excel sheets look empty. Here, we will discuss 5 solutions to fix missing gridlines in Excel. Fix 1 - Enable Gridlines ...

How to Convert Currency to Words in Excel – 2 Easy Methods

In the following dataset there are several amounts that you want to convert to words. Method 1 - Creating a User-Defined Function Using ...

How to Collapse Columns in Excel (6 Easy Ways)

The collapse columns feature in Excel hides the marked columns from being displayed. We will use the sample dataset below to collapse columns D, E, ...

How to Remove Page Border in Excel (2 Easy Methods)

Removing page borders in Excel refers to erasing borders from the outside cells of a page. In this Excel tutorial, you will learn how to remove ...

How to Print Excel with Lines on One Page (3 Easy Methods)

This tutorial will demonstrate how to print excel with lines on one page. When submitting the reports or bills update, it is essential to print the ...

Close the CTA

Advanced Excel Exercises with Solutions PDF

 

 

ExcelDemy
Logo