Excel Basics

How to Create Column Headers in Excel (3 Easy Methods)

Spreadsheets are used in many jobs to keep track of, organize, and look at data. By adding column headers to your data in Excel, you can organize it ...

How to Change Page Number in Excel (With Easy Steps)

If you are working in Microsoft Excel and your work involves printing your workbook then you might feel the need to insert page numbers and change it ...

How to Change Column Headings in Excel (2 Ways)

In Excel, a cell is represented by the combination of a column and a row. Generally, in Excel, the column headings are in alphabetical order. But, we ...

How to Set Print Area with Blue Line in Excel (5 Easy Ways)

You may have printed the whole workbook in your Excel file. But sometimes, for business purposes or some other reasons, you may need to print a ...

How Do You Fix Missing Gridlines in Excel (5 Easy Ways)

Without gridlines, Excel sheets look empty. Here, we will discuss 5 solutions to fix missing gridlines in Excel. Fix 1 - Enable Gridlines ...

How to Convert Currency to Words in Excel (2 Easy Ways)

Crafting invoices, financial reports, or official documents requires the use of expressing currency to words. This practice makes it easy for anyone ...

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

List of Currency Symbols in Excel

Excel allows you to insert various currency symbols as required. With the help of this set of currency symbols, users may accurately represent and ...

How to Add More Gridlines in Excel (2 Easy Methods)

In Excel, we can display 3 types of gridlines, they are horizontal gridlines and vertical gridlines, and for 3D charts, we have depth gridlines. ...

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

Format Currency with 2 Decimal Places in Excel (4 Easy Ways)

An understanding of currency formatting is essential for navigating the complexities of financial data in Excel and producing reports that are ...

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

How to Insert Subtitle in Excel (2 Effective Methods)

If you want to insert a subtitle in Excel, there are a few ways you can go about it. No matter which method you use, inserting a subtitle in Excel is ...

Advanced Excel Exercises with Solutions PDF

 

 

ExcelDemy
Logo