Latest Blog Posts

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

How to Change Currency Symbol in Excel (2 Ways)

Currency symbols act as visual cues, overcoming language barriers and offering a standardized way to interpret numerical information. Using currency ...

How to Hide Cells in Excel Until Data Entered (2 Easy Ways)

In this article, we will discuss how to hide cells in Excel until data is entered. We will use the dataset below, which contains some numeric and ...

Format Currency with 2 Decimal Places in Excel – 4 Methods

The following image shows an employee dataset consisting of Designation, Years of Service, and Salary. The Salary figures were converted to ...

How to Add Trailing Zeros in Excel (2 Easy Ways)

When adding trailing zeroes to the right of cell contents, you sometimes need to normalize the numbers so that they are all the same length. Other ...

Close the CTA

Advanced Excel Exercises with Solutions PDF

 

 

ExcelDemy
Logo