Latest Blog Posts

How to Reduce Excel File Size with Pivot Table

Excel file sizes can get bigger if we have a large amount of data inside them. Decreasing the file size is one of the most important tasks whenever ...

How to Insert Page Number in Excel Cell Not in Header

Method 1 - Inserting Page Number in Excel Cell Step 1: Open VBA Window VBA has its own separate window. You must insert the code in this window, ...

Excel VBA to Hide Columns Using Column Number (6 Examples)

This article will teach us to hide columns using the column number with VBA in Excel. Usually, excel expresses columns with alphabets. But we can ...

How to Hide Zero Values in Excel Pie Chart (3 Simple Methods)

In the sample dataset, we have a list of major subjects and the number of students who have taken them. No students have taken Human Resources and ...

How to Show Only Working Area in Excel (3 Quick Tricks)

Download Practice Workbook Show Only Working Area.xlsx Method 1 - Use Excel Page Break Preview to Show Only Working Area In the sample ...

How to Add Text to Cell Without Deleting in Excel: 8 Easy Methods

Method 1 - Applying CONCATENATE Function Steps: Select cell C5. Write down the following formula in the cell. Make sure that you input the ...

How to Use Formula for Page Number in Excel (6 Quick Ways)

Consider the dataset shown in cells B4:E26 below. The dataset is divided into two parts - the PC Shipment Tracker (which shows the Product names, the ...

How to Set the End of an Excel Spreadsheet (3 Effective Ways)

Say, you have a dataset of 10 employees’ salaries in an Excel spreadsheet. The end of the spreadsheet should be the last value of your dataset (C12 ...

How to Check If Cell Contains Special Character in Excel: 2 Ways

Method 1 - Using Simple User-Defined Function Steps: Go to the Developer tab and click on Visual Basic. If you don’t have that, you ...

How to Ignore Blank Cells in Excel Bar Chart (4 Easy Methods)

In this article, we will walk through 4 easy and effective methods to create an Excel Bar Chart that ignores blank cells. To illustrate our ...

How to Increase Excel Column Limit (2 Possible Ways)

If you are searching for a solution or some special tricks to increase the Excel column limit then you have landed in the right place. This article ...

What Is Datasheet View in Excel?

In Microsoft Excel, we generally work in a datasheet view. This type of view helps us perform many actions in Excel. Also, it helps us understand a ...

Unhide Columns in Excel Shortcut Not Working (6 Solutions)

This article illustrates how to fix the issue if the keyboard shortcut to unhide columns in Excel is not working. Assume you have the following ...

How to Change Theme Colors in Excel (with Quick Steps)

When you make a new Excel spreadsheet, you notice that it is usually in the MS office theme color with a built-in theme color. However, there are a ...

How to Make a Title Page in Excel (An Ultimate Guide)

Steps: Insert a header and footer in your Excel sheet. Go to the Insert Menu > Text > Header & Footer. Your sheet should look ...

Close the CTA

Advanced Excel Exercises with Solutions PDF

 

 

ExcelDemy
Logo