Latest Blog Posts

How to Change Gridlines in Excel (4 Suitable Ways)

An Excel gridline is the faint gray edge around each cell in the worksheet. In addition to making it easier to read the data, these gridlines help ...

How to Hide Chart Data in Excel – 6 Steps

The sample dataset contains information on sales amounts in three months. To hide the sales amount for February:   STEP 1 - Plotting a ...

How to Fix If Format Painter Not Working (3 Solutions)

  6 Reasons Why Your Format Painter May Not be Working If the Format Painter is not working in Excel, there are several potential reasons and ...

How to Add Leading Zeros to Make 10 Digits in Excel – 10 Methods

The dataset contains Employee Names and their Contact Number. To add leading zeros before the numbers to make 10 digits: Method 1 - Using ...

How to Change Alignment in Excel (5 Easy Methods)

We often face trouble while changing alignment according to our needs in Excel. If you are facing the same, this tutorial will show you 5 different ...

How to Insert Sequential Page Numbers Across Worksheets

Our sample Excel file has several Worksheets. We will insert sequential page numbers across the worksheets. Method 1 - Using Page Layout ...

How to Hide and Unhide Columns in Excel (7 Methods)

Dataset Overview To demonstrate these methods, we’ve prepared a dataset showing information about targets, sales, and profits for a set of products ...

How to Add Text to Beginning of Cell in Excel (7 Quick Tricks)

Method 1 - Using Ampersand(&) Operator to Add Text to the Beginning of a Cell in Excel Steps: Double-click on cell C5 and enter the ...

How to Remove Gridlines in Excel Pivot Table (with Easy Steps)

Looking for ways to know how to remove gridlines in an Excel pivot table? Sometimes, we want to remove gridlines in the Excel pivot table to see the ...

How to Determine What Is Causing a Large Excel File Size (10 Methods)

Method 1 - Check for Unnecessary Hidden Worksheet If you’ve received an Excel file from someone else or downloaded it from the internet, it may ...

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

Close the CTA

Advanced Excel Exercises with Solutions PDF

 

 

ExcelDemy
Logo