How to Hide VLOOKUP Source Data in Excel (5 Easy Ways)

Often, it is desired to hide the source data in Excel. This will keep the users from accidentally or willingly editing the source data. In this ...

How to Insert a Subtitle in Excel – 2 Methods

Method 1 - Using the Merge & Center feature to Insert a Subtitle in an Excel Sheet Select a blank cell on the top of your data table. ...

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

Close the CTA

Advanced Excel Exercises with Solutions PDF

 

 

ExcelDemy
Logo