Latest Blog Posts

Excel Gridlines are Not Showing by Default – 3 Solutions

This is the sample dataset. There is no gridline in the Excel sheet. Solution 1 - Enabling the Show Gridlines Option Steps: Go to ...

How to Find Special Characters in Excel – 3 Easy Methods

Method 1 - Using the Power Query to Find Special Characters in Excel Steps: This sample table contains Global Trade Item Number in Column B and ...

How to Make Excel Open Faster (16 Possible Ways)

Excel is capable of processing 6.6 million formulas per second, yet sometimes it can become very slow. In this article, we will discuss some of the ...

How to Add Text to End of Cell in Excel (6 Easy Methods)

Method 1 - Utilizing Flash Fill to Add Text to the End of Cell We have a dataset with a list of employees and their respective ages. We want to add ...

How to Hide Selected Columns in Excel (5 Useful Examples)

Excel is the most widely used tool for dealing with massive datasets. When we work in a group and share any Excel files, we often need to hide and ...

How to make Gridlines visible in Excel – 5 Solutions

In the sample dataset gridlines are not visible: Solution 1 - Using the View Tab STEPS: Go to the View tab. In Show, check ...

What Are Data Labels in Excel (Uses & Modifications)

Adding data labels to data points of a chart will make it easier to identify a data series in the chart. Data labels are connected to worksheet ...

How to Start Page Numbers at Different Number in Excel

We'll use the following dataset to add page numbers and have them start with a different number. Example 1 - Inserting the Page Number in ...

How to Adjust Gridlines in Excel Chart: 3 Methods

Method 1 - Use Chart Elements Option to Adjust Gridlines in Excel Chart 1.1 Add Horizontal and Vertical Gridlines Steps: Our created chart is ...

Excel Hide Columns Based on Cell Value without Macro

Looking for ways to know how Excel hides columns based on cell value without a macro? Sometimes, we want to hide columns based on cell value. We can ...

How to Convert Numbers to Words in Excel Without VBA

This guide will use the following dataset: Step 1: Build a Formula to Convert From Numbers to Words The following formula is huge but it ...

How to Add Primary Major Vertical Gridlines in Excel (2 Ways)

What Are Major Gridlines? Major gridlines divide the chart axis into major units. Major gridlines are vertical or horizontal lines that represent ...

How to Add Vertical Line in Excel Graph (6 Suitable Examples)

In this article, we will detail 6 ways to add a vertical line in an Excel graph. To illustrate, we'll use the following sample dataset, which ...

How to Convert 8 Digit Number to Date in Excel (3 Effective Ways)

Method 1 - Using the Text to Columns Wizard to Convert 8-Digit Numbers to Dates Select the numbers. Go to the Data tab. Select the Text to ...

How to Hide Blank Cells in Excel (5 Easy Methods)

We will use a dataset containing information about some sellers' sales amounts. The dataset has some blank cells. As we can’t hide the blank cells ...

Close the CTA

Advanced Excel Exercises with Solutions PDF

 

 

ExcelDemy
Logo