Excel Basics

What Can You Do with Cell Value If Checkbox Is Checked in Excel: 3 Methods

Method 1 - If Checkbox Is Checked, Set Cell Value Steps: Go to the Developer tab. If you don’t have it, enable the Developer tab on ribbon from ...

How to Align Shapes in Excel (5 Simple Methods)

Method 1 - Align Shapes in Same Plane in Excel We have four shapes that are on the same plane but are not arranged in a particular way. ...

How to Convert Text to Title Case in Excel (4 Methods)

Dataset Overview We'll use the data set below to demonstrate the methods. Method 1 - Using the PROPER Function The PROPER function is a ...

How to Center Accounting Format in Excel – 2 Methods

This is an overview.   The sample dataset showcases employees' names and their respective salary. The salary amounts are in ...

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

Advanced Excel Exercises with Solutions PDF

 

 

ExcelDemy
Logo