Excel Basics Archives - Page 75 of 176

How to Title a Column in Excel – 5 Methods

Aug 12, 2024

The dataset showcases Sales Person, Product, and Sales. Method 1 - Title a Column using the Cell in Excel There are blank cells in B4:D4. ...

How to Title a Column in Excel – 5 Methods

How to Return the Column Number of a Match in Excel – 5 Methods

Aug 3, 2024

Consider the following dataset. Method 1 - Using the MATCH Function to Return Column Number of Match Steps: Enter this formula ...

How to Return the Column Number of a Match in Excel – 5 Methods

How to Simultaneously Apply Accounting Number Format in Excel?

Nov 11, 2025

This article illustrates how to apply accounting number format in Excel simultaneously. This is a very widely used number formatting in Excel. Unlike ...

How to Simultaneously Apply Accounting Number Format in Excel?

How to Align Text in Excel (3 Quick Methods)

Nov 11, 2025

Sometimes we need to align text in the cells of Excel worksheets. Excel has some quick features and functions for this. In this article, we'll see ...

How to Align Text in Excel (3 Quick Methods)

Print Titles Must Be Contiguous and Complete Rows or Columns: 3 Possible Solution

Jul 5, 2024

Method 1 - Change 'Cell Errors As' Option Steps: Go to the Page Layout tab on your ribbon. Select Print Titles from the Page Setup group or ...

Print Titles Must Be Contiguous and Complete Rows or Columns: 3 Possible Solution

How to Add Multiple Bullet Points in Excel Cell (5 Suitable Ways)

Jun 16, 2024

We have multiple names in a single cell. We will add bullet points with each line of that cell. Method 1 - Using the Symbol Option to Add ...

How to Add Multiple Bullet Points in Excel Cell (5 Suitable Ways)

How to Left Align in Excel (3 Handy Ways)

Nov 11, 2025

In many cases, you might need to align cells to the left in Excel. It is very easy to choose or change alignment in Microsoft Excel. Also, you can do ...

How to Left Align in Excel (3 Handy Ways)

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

Jun 29, 2024

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

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

How to Align Shapes in Excel (5 Simple Methods)

Jun 26, 2024

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 Align Shapes in Excel (5 Simple Methods)

How to Promote a Row to a Column Header in Excel (2 Ways)

Nov 11, 2025

If you are looking for some special tricks to promote a row to a column header in Excel, you've come to the right place. There are two ways to ...

How to Promote a Row to a Column Header in Excel (2 Ways)

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

Jul 24, 2024

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 Convert Text to Title Case in Excel (4 Methods)

How to Center Accounting Format in Excel – 2 Methods

Aug 11, 2024

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

How to Center Accounting Format in Excel – 2 Methods

Excel Status Bar Not Showing Sum (2 Possible Solutions)

Jun 18, 2024

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

Excel Status Bar Not Showing Sum (2 Possible Solutions)

How to Count Checkboxes in Excel (3 Easy Methods)

Jun 16, 2024

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 Count Checkboxes in Excel (3 Easy Methods)

How to Apply Accounting Number Format to Selected Cells in Excel

Nov 11, 2025

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