Excel Basics

How to Convert Numbers to Words in Excel Without VBA

This guide will use the following dataset: Step 1: Build a Formula to Convert From Numbers to Words The following formula is huge but it ...

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

Gridlines help to show axis divisions in a chart plot. For large and complicated charts, gridlines provide valuable indications to the viewer. These ...

How to Hide Blank Cells in Excel (5 Easy Methods)

We will use a dataset containing information about some sellers' sales amounts. The dataset has some blank cells. As we can’t hide the blank cells ...

How to Unhide Columns in Excel All at Once (4 Quick Ways)

Take a look below for an example of a dataset where a number of columns are hidden. If you want to unhide columns simultaneously, you can use three ...

How to Make an Excel Spreadsheet Look Like a Form

Sometimes you need to add numerous data in Excel. In that case, you can turn your Excel spreadsheet into a form. You may make some mistakes while ...

How to Insert Page Number in Excel Cell Not in Header

While printing an extended dataset, Microsoft Excel normally breaks it into different pages. You can also print a large one on one page. But it ...

How to Show Only Working Area in Excel (3 Quick Tricks)

In this tutorial, I am going to show you 3 quick tricks on how to show only the working area in excel. Removing the unused cells from the worksheet ...

How to Use Formula for Page Number in Excel (6 Quick Ways)

Looking for ways to insert page numbers when printing your worksheets in Excel? Then, you’ve come to the right place. In this article, I’ll introduce ...

How to Make a Title Page in Excel (An Ultimate Guide)

While making a report in Excel, you don’t need to make the title page for your report in Microsoft Word, you can easily do that in Excel. You will ...

How to Hide Multiple Columns in Excel (5 Easy Methods)

You might want to hide multiple columns in Microsoft Excel to conceal personal or perplexing data. We can easily hide multiple columns in Excel by ...

How to Remove Bullets and Numbering in Excel (3 Effective Ways)

The usage of bullet points and numbering are pretty rare in MS Excel. You may find the bullets and numbering in your Excel sheets when you brought ...

How to Change Background in Excel Sheet (4 Suitable Ways)

Excel has a default background to present data with a great view. But sometimes we need to customize the background. There are some ways to change ...

Save Excel Table as Image with High Resolution (with Easy Steps)

This article illustrates how to save an Excel table as an image with high resolution. If you print an Excel table, it will stay sharp no matter how ...

How to Add Double Quotes in Excel Concatenate (5 Easy Ways)

Here, we have a dataset containing the First Name, Last Name, and Age of some people. Now, we will show you how to add double quotes in Excel ...

How to Insert a Page Break in Excel (4 Easy Ways)

While working with a big data set, users may need to separate their data into different segments for the purpose of individual analysis as well as ...

Advanced Excel Exercises with Solutions PDF

 

 

ExcelDemy
Logo