Latest Blog Posts

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

How to Compare Two Sets of Data in an Excel Chart – 5 Examples

  The sample dataset showcases Name of Company, Branch Location, Sales, and Cost.   Example 1 - Using a 2-D Column Chart ...

How to Print a Full Page of an Excel Sheet in A4 Size (5 Methods)

Dataset Overview We’ll be working with a dataset containing employee information, including columns for Employee ID, Name, Gender, Department, and ...

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

Attendance Sheet in Excel with Formula for Half Day (3 Examples)

In this tutorial, we will assume you have an attendance sheet of 10 workers for the month of January in 2022. You have a record of the holidays of ...

How to Alternate Row Colors Based on a Group in Excel (6 Methods)

Dataset Overview To demonstrate these methods, let’s consider a dataset of 10 fruit consumers. The fruit item names are in column B, and the ...

[Solved]: Leading Zero Not Showing in Excel (9 Possible Solutions)

Sometimes, we need to input a number with the leading zeroes for our dataset. However if the proper settings are not used, we can face difficulties ...

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 Add a Word in All Rows in Excel (4 Methods)

Dataset Overview We'll use the below dataset that represents some people’s names. Our target is to add Mr.  before every name in all the rows. ...

How to Create a Checkbook Ledger in Excel (2 Useful Examples)

Looking for ways to keep track of your transactions in a checkbook ledger? Then you’ve come to the right place. In this article, we’ll show you 2 ...

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 to Add Data Markers in Excel (2 Easy Examples)

Example 1 - Adding Data Markers in a Line Chart  We have the following dataset shown in the B4:D13 cells below. The dataset shows the Month number, ...

Close the CTA

Advanced Excel Exercises with Solutions PDF

 

 

ExcelDemy
Logo