Latest Blog Posts

How to AutoFill in Excel with Repeated Sequential Numbers

In this article, we will demonstrate four simple approaches to Autofill a series of sequential numbers repeatedly in Excel. The dataset below has 3 ...

How to Filter Checkboxes in Excel (with Easy Steps)

In this article, we will demonstrate how to add checkboxes in Excel and then Filter them. Step 1 - Enable Developer Tab Before we delve into ...

How to Fix All Numbers Stored as Text in Excel – 6 Easy Methods

This is the sample dataset. Method 1 - Using the Flash Fill Feature Steps: Add a new column. Enter the three first numbers ...

How to Print Avery 5160 Labels from Excel (with Detailed Steps)

  Step 1 - Prepare Dataset Enter the Name, Address, and Column in the following dataset. In the Name column, enter each person’s name. ...

How to Make a Pareto Chart Using Pivot Tables in Excel

What Is a Pareto Chart? A Pareto chart combines columns sorted in descending order with a line representing cumulative total percentages. It’s a ...

How to Set Multiple Rows as Print Titles in Excel (4 Handy Ways)

Wouldn't it be great to have the Titles at the top of every page when printing in Excel? With this in mind, this article demonstrates how to set ...

How to Adjust Page Size for Printing in Excel (6 Quick Tricks)

A common problem when printing from Excel is that the page size or printing area does not look the way we want. This article will present 6 quick ...

How to Put a Title Across Cells in Excel (With Easy Steps)

While working in Microsoft Excel, we need to put a title across cells so that we can understand the dataset easily. Putting a title across cells in ...

Convert Number to Hours and Minutes in Excel (2 Easy Methods)

The following table has the Days and Number columns. We will use the Number column of this table to convert number to hours and minutes in Excel. ...

How to Convert Number to Text in Excel with Apostrophe

In this tutorial, we will demonstrate a quick but useful method to convert numbers to text format in Excel using the apostrophe. Furthermore, this ...

Convert 3 Letter Month to Number in Excel (8 Suitable Methods)

We'll use the following simple dataset with income over a few months. Method 1 - Using the MONTH Function to Convert a 3-Letter Month to ...

[Fixed!] Print Preview in Excel Does Not Show All Pages

In Microsoft Excel, sometimes print preview does not show all pages. It may occur due to the size of the print area. Today, we will show a ...

Excel VBA to Display Print Preview for Multiple Sheets

Microsoft Excel is a powerful software. We can perform numerous operations on our datasets using Excel tools and features. Sometimes, we need to ...

How to Add Labels with Lines in an Excel Pie Chart (Easy Steps)

What Is a Pie Chart? A Pie Chart is a circular graph divided into sectors, each representing a proportion of the whole. The area of each portion ...

How to Find Slope of Trendline in Excel (2 Easy Methods)

We have an independent variable in Column C marked as X and a dependent variable in Column B marked as Y. We will use this dataset to determine the ...

Close the CTA

Advanced Excel Exercises with Solutions PDF

 

 

ExcelDemy
Logo