Excel Basics

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

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 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 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 Change Accounting Format in Excel?

There are a lot of variations in currencies. Throughout the whole world, every country maintains a fixed currency. Sometimes, we face the necessity ...

How Do I Stop 255 Character Limit in Excel (4 Ways)

Method 1 - Using CONCATENATE Function Steps: If we need to use a formula that involves a character length greater than 255, we will face a ...

How to Hide a Part of Text in Excel Cells (2 Methods)

Dataset Overview Let's assume we have a dataset of 5 employees’ phone numbers. But we don’t want to show it to everyone. So, we need to hide some ...

Difference Between Accounting and Currency Format in Excel

The article will show you the difference between Accounting and Currency format in Excel. These two number formats seem similar to each other, ...

How to Remove Data Bars in Excel (3 Simple Ways)

While working in Microsoft Excel we need to highlight cells or highlight data inside a chart. Sometimes, we use data bar rules of conditional ...

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

Close the CTA

Advanced Excel Exercises with Solutions PDF

 

 

ExcelDemy
Logo