Excel Basics

How to Collapse Columns in Excel (6 Easy Ways)

Need to learn how to collapse columns in Excel? The feature in Excel to collapse columns makes them disappear from the display. You may have a lot of ...

How to Remove Page Border in Excel (3 Methods)

Sometimes, we apply Borders in Excel cells to make them stand out. But we also need to Remove those Borders when they are not useful or necessary ...

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

Looking for ways to know how to use Format Painter in Excel for multiple sheets? Sometimes, we have to copy the format into multiple sheets. We can ...

How to Resize Checkbox in Excel (3 Easy Ways)

Checkboxes are often used while working with excel. The main focus of this article is to explain how to resize checkbox in Excel. Here, I will show 3 ...

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 Easy Methods)

In Excel, we can display 3 types of gridlines, they are Horizontal gridlines, Vertical gridlines, and for 3D charts, we have Depth gridlines. Excel ...

How to Change Currency Symbol in Excel (2 Handy Ways)

If you are working with several currencies in an Excel worksheet, you will need to change the currency symbol. This article will show you how to ...

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

Sometimes, in Excel, we need to hide cells or hide entire rows or columns. We want to input data into those cells later. Or sometimes, we have to ...

Currency with 2 Decimal Places in Excel (with Quick Steps)

If you are searching for the solution or some special tricks to apply Currency format with 2 decimal places in Excel then you have landed in the ...

How to Change Accounting Format in Excel (4 Simple Ways)

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

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

During the many calculations phase, we encounter that text in cell formulas needs to be under 255 characters, which is annoying. In most cases, we ...

How to Fix Image in Excel Cell (2 Quick Solutions)

After inserting a picture in a cell, we often face some problems in Excel. Like while inserting a column or row, the picture is not moving with the ...

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

When working with Excel, it might be needed sometimes to hide some part of a text. Now, if you are looking for ways to do so, you have landed in the ...

Difference Between Accounting and Currency Format in Excel

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

ExcelDemy
Logo