Excel Basics

Excel Status Bar Not Showing Sum (2 Possible Solutions)

By default, in Excel, when the user selects a range of numbers, the count, sum, and average value of the selection are shown in the status bar on the ...

How to Count Checkboxes in Excel (3 Easy Methods)

We'll use the following data set, which contains 3 columns (Name, ID, and Attendance) to count the checkboxes. Method 1 - Using Properties ...

How to Apply Accounting Number Format to Selected Cells in Excel

When you are working with a dataset, and you need to represent some cells as money, then you need them to show as the accounting number format. It ...

How to Apply Double Accounting Underline Format in Excel

The following image gives an overview of this Excel tutorial. On the right side of the image, you can see the outcome of the methods explained in ...

How to Color Scale Per Row with Conditional Formatting in Excel (2 Methods)

Dataset Overview We'll use the following Annual Profit Record for various companies to demonstrate these methods. In the Company column, there is a ...

How to Create a Number Sequence with Text in Excel (5 Methods)

Watch Video – Create a Number Sequence with Text in Excel   Method 1 – Using Excel TEXT and ROW Functions to Create a Number ...

[Fixed] Excel Column Numbers Instead of Letters (2 Solutions)

The article will demonstrate how to solve the issue of Excel columns being designated in numbers instead of letters. Excel displays column numbers as ...

How to Add a Title to a Table in Excel (with Simple Steps)

While making a dataset it is very important to make a title of the dataset. But sometimes it becomes critical when we have already made our dataset ...

How to Increment the Row Number in an Excel Formula – 6 Methods

The dataset shows Category and Item names. Method 1 - Adding 1 to Increment the Row Number in Excel Steps: Enter 1 in B5 and press ...

How to Sort Multiple Headings in Excel – 2 Methods

The dataset showcases Product Sales data. It has multiple headings.   Method 1 - Enabling the Filter Feature to Sort ...

Keep Row Headings in Excel When Scrolling Without Freeze (2 Ways)

We have selected a dataset with four columns detailing the Product, Brand, Model, and Price. The dataset has 24 rows of data. When scrolling down, ...

Subtotal Formula in Excel for Serial Number: 3 Suitable Methods

Method 1 - Use of SUBTOTAL Function for Serial Number Steps: Select Cell B5 and type the formula below. =SUBTOTAL(3,$C$5:C5) ...

How to Create a Number Sequence in Excel Without Dragging

Dragging is a quick and easy way to create a number sequence in Excel. But there are scenarios where you might want to create one without dragging ...

How to Group Checkboxes in Excel (3 Easy Ways)

Looking for ways to know how to group checkboxes in Excel? Usually, we use checkboxes to select or unselect an option in Excel. Here, you will find ...

How to Add Bullet Points to an Excel Text Box – 4 Methods

You have a list of four tasks. To add bullet points inside the text box: Method 1 - Add Bullet Points in Excel Text Box from Right-Click ...

Close the CTA

Advanced Excel Exercises with Solutions PDF

 

 

ExcelDemy
Logo