Latest Blog Posts

How to Change Marker Shape in Excel Graph (3 Easy Methods)

Excel automatically creates a shape for the marker when creating a Line, (XY) Scatter, and Radar chart. These data markers help to visualize the ...

[Solved!] Excel VBA: Status Bar Not Updating [4 Easy Solutions]

Status Bar in Excel can be useful for seeing the progress of certain actions, like page layout changes or printing. However, there are times when the ...

How to Convert Currency to Words in Excel – 2 Easy Methods

In the following dataset there are several amounts that you want to convert to words. Method 1 - Creating a User-Defined Function Using ...

How to Collapse Columns in Excel (6 Easy Ways)

The collapse columns feature in Excel hides the marked columns from being displayed. We will use the sample dataset below to collapse columns D, E, ...

How to Remove Page Border in Excel (2 Easy Methods)

Removing page borders in Excel refers to erasing borders from the outside cells of a page. In this Excel tutorial, you will learn how to remove ...

How to Print Excel with Lines on One Page (3 Easy Methods)

This tutorial will demonstrate how to print excel with lines on one page. When submitting the reports or bills update, it is essential to print the ...

How to Use Format Painter in Excel for Multiple Sheets

The Format Painter in Excel is like a quick copy-paste tool for formatting. You can copy formatting from one sheet and apply it to multiple sheets to ...

[Fixed!] Excel Spreadsheet Opening Larger Than Screen

If you are looking for some special tricks to solve the problem of "Excel spreadsheet opening larger than screen”, you've come to the right place. In ...

Mapping Data from Another Sheet in Excel (6 Useful Methods)

Suppose you have the following two datasets. Method 1 - Link Cells for Mapping Data from Another Sheet in Excel Steps: Insert an ...

How to Resize Checkbox in Excel (3 Easy Ways)

Consider the following Daily Tasks Checklist. The dataset contains Tasks and Status that contains a checkbox. We will resize the Checkbox. ...

How to Access and Create a Custom List of Currency Symbols in Excel

Overview of Currency Symbols The following overview image illustrates a list of currency symbols with its corresponding currency code, currency ...

How to Insert Comma Between Words in Excel (4 Simple Methods)

In this tutorial, I will show you 4 simple methods to insert a comma between words in Excel. When you have small datasets, inserting commas inside ...

How to Add Primary Minor Vertical Gridlines in Excel (2 Ways)

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

How to Add More Gridlines in Excel – 2 Methods

Use the dataset below to insert a Column chart: Select the entire dataset. Go to the Insert tab. In Insert Column or Bar Chart ...

How to Add Digits to a Number in Excel – 8 Easy Methods

The sample dataset contains 2 columns, Customer Name and Customer ID. Method 1 - Using the Ampersand(&) Operator to Add Digits to a ...

Close the CTA

Advanced Excel Exercises with Solutions PDF

 

 

ExcelDemy
Logo