Latest Blog Posts - Page 171 of 411

How to Put Comma After 2 Digits in Excel (9 Quick Methods)

Jul 12, 2024

We will use a sample dataset of products and their quantities. Method 1 - Applying LEFT and MID Functions to Put a Comma After 2 Digits in ...

How to Put Comma After 2 Digits in Excel (9 Quick Methods)

How to Change Column Headings in Excel (2 Ways)

Jun 19, 2024

Here's a sample dataset containing PC parts, prices, and available quantities. We'll change the column headings in the file from letters to numbers. ...

How to Change Column Headings in Excel (2 Ways)

How to Compare Two Sets of Data in an Excel Chart – 5 Examples

Aug 2, 2024

The sample dataset showcases Name of Company, Branch Location, Sales, and Cost. Example 1 - Using a 2-D Column Chart ...

How to Compare Two Sets of Data in an Excel Chart – 5 Examples

How to Print a Full Page of an Excel Sheet in A4 Size (5 Methods)

Jul 17, 2024

Dataset Overview We’ll be working with a dataset containing employee information, including columns for Employee ID, Name, Gender, Department, and ...

How to Print a Full Page of an Excel Sheet in A4 Size (5 Methods)

Attendance Sheet in Excel with Formula for Half Day (3 Examples)

Apr 30, 2024

In this tutorial, we will assume you have an attendance sheet of 10 workers for the month of January in 2022. You have a record of the holidays of ...

Attendance Sheet in Excel with Formula for Half Day (3 Examples)

How to Alternate Row Colors Based on a Group in Excel (6 Methods)

Jul 18, 2024

Dataset Overview To demonstrate these methods, let’s consider a dataset of 10 fruit consumers. The fruit item names are in column B, and the ...

How to Alternate Row Colors Based on a Group in Excel (6 Methods)

How to Set Print Area with Blue Line in Excel: 5 Easy Ways

Jul 4, 2024

Method 1 - Set Print Area from Page Layout Tab Select the area you want to print> go to the Page Layout tab> click Print Areas> select ...

How to Set Print Area with Blue Line in Excel: 5 Easy Ways

How to Add a Word in All Rows in Excel (4 Methods)

Jul 13, 2024

Dataset Overview We'll use the below dataset that represents some people’s names. Our target is to add Mr. before every name in all the rows. ...

How to Add a Word in All Rows in Excel (4 Methods)

How to Add Data Markers in Excel (2 Easy Examples)

Jul 12, 2024

Example 1 - Adding Data Markers in a Line Chart We have the following dataset shown in the B4:D13 cells below. The dataset shows the Month number, ...

How to Add Data Markers in Excel (2 Easy Examples)

How Do You Fix Missing Gridlines in Excel (5 Easy Ways)

Apr 25, 2024

Without gridlines, Excel sheets look empty. Here, we will discuss 5 solutions to fix missing gridlines in Excel. Fix 1 - Enable Gridlines ...

How Do You Fix Missing Gridlines in Excel (5 Easy Ways)

How to Change Marker Shape in Excel Graph (3 Easy Methods)

May 19, 2024

Excel automatically creates a shape for the marker when creating a Line, (XY) Scatter, and Radar chart. These data markers help to visualize the ...

How to Change Marker Shape in Excel Graph (3 Easy Methods)

How to Convert Currency to Words in Excel – 2 Easy Methods

Aug 4, 2024

In the following dataset there are several amounts that you want to convert to words. Method 1 - Creating a User-Defined Function Using ...

How to Convert Currency to Words in Excel – 2 Easy Methods

How to Collapse Columns in Excel (6 Easy Ways)

Jul 7, 2024

The collapse columns feature in Excel hides the marked columns from being displayed. We will use the sample dataset below to collapse columns D, E, ...

How to Collapse Columns in Excel (6 Easy Ways)

Mapping Data from Another Sheet in Excel (6 Useful Methods)

Jun 7, 2024

Suppose you have the following two datasets. Method 1 - Link Cells for Mapping Data from Another Sheet in Excel Steps: Insert an ...

Mapping Data from Another Sheet in Excel (6 Useful Methods)

How to Resize Checkbox in Excel (3 Easy Ways)

Jul 6, 2024

Consider the following Daily Tasks Checklist. The dataset contains Tasks and Status that contains a checkbox. We will resize the Checkbox. ...