Excel Basics

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

Step 1 - Enable Form by Customizing Quick Access Toolbar First we need to customize the quick access toolbar so that the Form tab will appear in it. ...

How to Perform Numbering in One Cell in Excel (3 Smart Ways)

Sometimes we need to organize a set of data in a single cell to decorate our data. Numbering in Excel in One cell may be a very effective skill to ...

How to Insert Page Number in Excel Cell Not in Header

Method 1 - Inserting Page Number in Excel Cell Step 1: Open VBA Window VBA has its own separate window. You must insert the code in this window, ...

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

Download Practice Workbook Show Only Working Area.xlsx Method 1 - Use Excel Page Break Preview to Show Only Working Area In the sample ...

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

Consider the dataset shown in cells B4:E26 below. The dataset is divided into two parts - the PC Shipment Tracker (which shows the Product names, the ...

What Is Datasheet View in Excel?

In Microsoft Excel, we generally work in a datasheet view. This type of view helps us perform many actions in Excel. Also, it helps us understand a ...

Unhide Columns in Excel Shortcut Not Working (6 Solutions)

This article illustrates how to fix the issue if the keyboard shortcut to unhide columns in Excel is not working. Assume you have the following ...

How to Change Theme Colors in Excel (with Quick Steps)

When you make a new Excel spreadsheet, you notice that it is usually in the MS office theme color with a built-in theme color. However, there are a ...

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

Steps: Insert a header and footer in your Excel sheet. Go to the Insert Menu > Text > Header & Footer. Your sheet should look ...

How to Hide Multiple Columns in Excel: 5 Easy Methods

Method 1 - Using Keyboard Shortcuts to Hide Multiple Columns in Excel Steps: Select columns D and E that contain marks in Physics and ...

How to Remove Bullets and Numbering in Excel – 3 Methods

Method 1 - Using the Find and Replace Feature to Remove Bullets Select all the cells with bullets. Press CTRL + H to open the Find and ...

How to Change the Background in an Excel Sheet (4 Ways)

Method 1 –  Using the Page Layout Tool  Steps: Go to the desired sheet. Click on the Page Layout tab. Choose Background from the Page ...

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

Step 1 - Create an Excel Table Create a table in excel using the CTRL+T shortcut. Step 2 - Copy the Table as Picture Select the ...

Close the CTA

Advanced Excel Exercises with Solutions PDF

 

 

ExcelDemy
Logo