Latest Blog Posts

How to Sort in Excel by Number of Characters (2 Methods)

Method 1 - Using the LEN Function and a Helper Column Steps: Create a Helper column left to the main data table. Enter the following formula ...

Excel VBA to Select Used Range in Column (8 Examples)

In the following image, we can see the dataset that we will use for all the examples. The dataset contains the names of Salespeople, their Location, ...

Excel VBA: R1C1 Formula with Variable (3 Examples)

While working in Excel, you might hear the absolute and relative cell references. We can use both types of reference in the R1C1 formula with ...

How to Show Gridlines after Using Fill Color in Excel (4 Easy Methods)

Gridlines, the horizontal and vertical gray-colored lines that differentiate between cells in a worksheet, are displayed by default in an Excel ...

How to Not Print Empty Cells in Excel (3 Simple Methods)

In this article, we will learn how to not print empty cells in Excel. Sometimes, we import or download a dataset that contains empty cells. Often, we ...

Excel VBA: How to Set Print Area Dynamically (7 Ways)

Method 1 - Setting Print Area Using a Dynamic Named Range Step 1: ➤ Go to the Formulas Tab >> Defined Names Group >> Name Manager ...

Why Do Gridlines Disappear in Excel? (5 Reasons with Solutions)

Solution 1 - Gridlines Disappear in Excel If Those Are Turned off If Gridlines are turned off then the Gridlines will not be visible in Excel. ...

How to Extract Text between Two Spaces in Excel (5 Easy Ways)

For illustration, we will extract First Names from the sample dataset shown. Method 1 - Extract Text between Two Spaces Using MID and FIND ...

How to Autofilter Values Not Equal to a Certain Value with VBA in Excel

In this article, I’ll show you how you can auto-filter values that are not equal to a certain value with VBA in Excel. You’ll learn to auto-filter ...

How to Fix Cell Size in Excel (11 Quick Ways)

Sometimes we need to fix cell size in Excel to make the dataset more attractive. By default, every Excel worksheet contains the same-sized cells. We ...

How to Use Filter in Protected Excel Sheet (With Easy Steps)

This article illustrates how you can allow people to use filter in your protected Excel sheet. You may need to do this to create a user-friendly ...

How to Wrap Text across Multiple Cells without Merging in Excel

Method 1 –  Using the Format Cells Feature Steps: Highlight the cells along with the text you want to wrap text across. Go to the Home tab ...

How to Print Excel Sheet in Full Page (7 Ways)

In this article, we’ll discuss seven different methods to print an Excel sheet on a one page. To illustrate these methods, we'll use the dataset ...

Excel VBA: Format Currency with Two Decimal Places – 3 Methods

Entering the Code in the Visual Basic Editor Go to the Developer tab. Click Visual Basic. Click Insert and select Module. ...

How to Find First Occurrence of a Value in a Column in Excel (5 Ways)

We are using a dataset that contains IDs and Names of some guys. The dataset contains some duplicates, so we'll find only the first occurrence of ...

Close the CTA

Advanced Excel Exercises with Solutions PDF

 

 

ExcelDemy
Logo