Latest Blog Posts

How to Hide Unused Cells in Excel (3 Quick Ways)

Excel has a large built-in spreadsheet to input data. However, most of the time, many of the cells remain unused. To prevent the entry of any scatter ...

How to Add Gridlines in Excel After Highlighting (3 Easy Methods)

Excel worksheets and workbooks display gridlines by default. But, the gridlines disappear as soon as we highlight the cells. And many times, this is ...

How to Hide Extra Cells in Excel (with Quick Steps)

If you are searching for a solution or some special tricks to hide extra cells in Excel then you have landed in the right place. Often you want to ...

How to Compress Excel File to Smaller Size (7 Easy Methods)

Method 1 - Removing Irrelevant Worksheets/Data Steps: We arranged our desired Excel file. Check how many worksheets it contains and ...

How to Check Character Limit in Excel (With Easy Steps)

Excel is the most widely used tool for dealing with massive datasets. We can perform myriads of tasks of multiple dimensions in Excel. Sometimes, ...

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

Close the CTA

Advanced Excel Exercises with Solutions PDF

 

 

ExcelDemy
Logo