Latest Blog Posts

How to Use XLOOKUP to Return Blank Instead of 0 -12 Methods

The following dataset contains the names of Sales Reps, Product Names, and Sales.   Method 1 - Utilizing an Optional Argument of ...

How to Use Trendline Equation in Excel: 8 Suitable Examples

Method 1 - Adding Trendline Equation in Excel Steps: Select the chart in which you want to add the trendline. Go to Chart Elements. ...

How to Leave Cell Blank If There Is No Data in Excel (5 Ways)

The sample dataset contains the columns Product ID, Quantity, Unit Price, and Cost columns where some of the values for quantity are missing. This ...

How to Use Excel VBA to Hide Columns Based on Cell Value (15 Examples)

To demonstrate, we have a dataset of 5 students. Their name, department, examination marks, grades, DOB, and retake examination marks are in the ...

How to Convert Text with Spaces to Number in Excel (4 Ways)

Below is a dataset with personal information in the Name, City, and Phone columns. Method 1 - Using the SUBSTITUTE Function to Convert ...

How to Remove Unused Cells in Excel (10 Methods)

Method 1 - Using the Go To Special Command Steps: Select the data range (B4:E12). Press F5 or Ctrl + G to bring up the Go To dialog box. ...

How to Insert Multiple Page Breaks in Excel – 2 Methods

This is the sample dataset. Method 1 - Utilizing the Page Layout tab to Insert Multiple Page Breaks in Excel Step 1: Choose the ...

Hide Columns with No Data in Excel – 4 Methods

This is the sample dataset. To hide all columns except for the first 3:   Method 1 - Hide Columns with No Data Using the Format ...

How to Show Only One Page in Excel Page Layout View (4 Ways)

To demonstrate how to display the page layout view on one page in Excel, we'll use the following large dataset that includes the order date, customer ...

How to Insert Page Break Between Rows 39 and 40 in Excel

Sometimes, we want to manage our data in a customized way and print them on different pages. For this reason, we insert page breaks between different ...

[Solved]: Page Break in Excel Not Working Error

We have three different data tables, each containing the names, IDs, and joining dates of employees of three different companies. We'll solve the ...

How to Hide Confidential Data in Excel – 5 Methods

The dataset contains employees' information. To hide sensitive information like phone numbers:   Method 1 - Applying Custom Cell ...

How to Print Gridlines with Fill Color in Excel (4 Useful Ways)

Gridlines are a classical feature of spreadsheets. In Excel, gridlines help the user to distinguish between cells and navigate within the rows and ...

How to Print Titles in Excel Except for Last Page (2 Easy Macros)

Printing titles on every page in Excel is much easier as there is a built-in command in Excel to do that. But if we want to print titles on every ...

How to Remove Gridlines in Excel Using VBA

In this article, we will demonstrate 3 quick ways to remove Gridlines in Excel using VBA. To demonstrate our methods, we will use the following ...

Close the CTA

Advanced Excel Exercises with Solutions PDF

 

 

ExcelDemy
Logo