Excel Basics

How to Create a Double Row Header in Excel (3 Easy Ways)

We have the Scores on the Midterm Test. Also, Row 5 includes ID, Name, English, Maths, and Social Science column headers. In the following figures, ...

How to Change Background Color Based on Value in Excel (6 Ways)

While working in Microsoft Excel, it may be necessary to change the background color of a cell based on its value. In fact, this adds visual depth ...

How to Make Excel Spreadsheet Colorful (6 Simple Tricks)

When you work on multiple datasets with various information, you may find it difficult to present them in the default format. Because this bulk of ...

Guide to Why Excel Status Bar Not Showing Count

Solution: Change the Status Bar Option to Display the Count Value Right-click on the status bar at the bottom of the worksheet interface. ...

How to Make the Picture Background Transparent in Excel -2 Methods

Method 1. Using the Context Menu Steps: Go to the Insert tab and select Shapes in Illustrations. Select Rectangle. Draw the ...

How to Insert Picture in Excel Cell with Text: 2 Easy Methods

Method 1 - Insert Picture Using Pictures Option Steps: Go to the Insert. Go to Illustrations. Choose Pictures. Insert images from This ...

How to Remove Background in Excel (2 Practical Cases)

What Is a Background in Excel? Usually, the default background in an Excel sheet is set to rectangular cells of equal width and height separated by ...

Saving Pictures from Excel to a Folder – 3 Simple Methods

This is the sample dataset. Method 1 - Format the Excel File as a Web Page to Save Pictures to a Folder Steps: Go to the File tab on ...

How to Grey Out Unused Cells in Excel (3 Quick Methods)

Suppose you have a worksheet that contains data in cells of the B2:D12 range, and you want to grey out the remaining cells of the worksheet. Let's ...

How to Center Text in a Cell in Excel (3 Easy Methods)

Method 1 - Using Ribbon to Center Text in a Cell in Excel 1.1 Use Center Align Option Steps: Select the whole data table and go to the Home ...

How to Apply Center Horizontal Alignment in Excel (3 Quick Tricks)

In our daily life, we have to deal with lots of data. Microsoft Excel is an excellent place to store those data. In order to store data or create a ...

How to Convert Time to Number in Excel (5 Easy Methods)

Suppose you have a list of time ranges. It contains the Times to Convert into Numbers. Method 1 - Using Format Cells Option to Convert ...

How to AutoFill in Excel with Repeated Sequential Numbers

In this article, we will demonstrate four simple approaches to Autofill a series of sequential numbers repeatedly in Excel. The dataset below has 3 ...

How to Filter Checkboxes in Excel (with Easy Steps)

In this article, we will demonstrate how to add checkboxes in Excel and then Filter them. Step 1 - Enable Developer Tab Before we delve into ...

How to Fix All Numbers Stored as Text in Excel – 6 Easy Methods

This is the sample dataset. Method 1 - Using the Flash Fill Feature Steps: Add a new column. Enter the three first numbers ...

Close the CTA

Advanced Excel Exercises with Solutions PDF

 

 

ExcelDemy
Logo