Excel Basics Archives - Page 72 of 176

How to Remove Page 1 Watermark in Excel (4 Easy Methods)

Jul 4, 2024

Method 1 - Change Workbook Views to Remove the Page 1 Watermark in Excel In many situations, a page 1 watermark appears in an Excel workbook because ...

How to Remove Page 1 Watermark in Excel (4 Easy Methods)

How to Make Excel Look Pretty (16 Easy Formats)

May 14, 2024

The following data table represents the monthly data of a company. The Month, Employee Name, Total Assigned Leave, Leave Taken, and Salary are the ...

How to Make Excel Look Pretty (16 Easy Formats)

How to Hide Row and Column Headings in Excel (2 Suitable Ways)

Nov 11, 2025

When using Microsoft Excel, sometimes we need to hide row and column headings to represent our dataset. This is a very basic Excel operation. Are you ...

How to Hide Row and Column Headings in Excel (2 Suitable Ways)

How to Select Column A as Titles to Repeat on Each Page

Nov 11, 2025

Need to learn how to select column A as titles to repeat on each page in Excel? If you are looking for such unique kinds of tricks, you’ve come to ...

How to Set Print Titles to Repeat in Excel (2 Ways)

Jul 31, 2024

Example 1 - Setting Column Titles to Repeat in Excel The sample dataset contains data up to Week 47 which will come to more than one page when ...

How to Set Print Titles to Repeat in Excel (2 Ways)

How to Change the Default Background Color in Excel

Jun 22, 2024

Below is a dataset that contains information about several Sales Representatives of the Armani group. Columns B, C, D, and E give the names of the ...

How to Change the Default Background Color in Excel

How to Copy the Sum from the Status Bar in Excel – 3 Steps

Aug 14, 2024

The sample dataset showcases Employee Names. Step 1 - Make the SUM Data Visible in the Excel Status Bar Prepare the dataset by ...

How to Copy the Sum from the Status Bar in Excel – 3 Steps

How to Convert Peso Number to Words in Excel (With Easy Steps)

Dec 19, 2023

This tutorial will demonstrate how to convert peso number to words in Excel. Undoubtedly it is very important to convert the currency numbers into ...

How to Convert Peso Number to Words in Excel (With Easy Steps)

How to Create Excel Table with Row and Column Headers (3 Ways)

Nov 11, 2025

In this tutorial, I am going to show you 3 effective ways to create an Excel table with row and column headers. Headers help to make tables more ...

How to Create Excel Table with Row and Column Headers (3 Ways)

How to Fix Background Color Not Changing in Excel (6 Solutions)

Jul 21, 2024

Reason Behind Background Color Not Changing in Excel By default, the fill color of cells in an Excel worksheet cannot be modified. Each cell starts ...

How to Fix Background Color Not Changing in Excel (6 Solutions)

How to Automatically Insert Serial Numbers in Excel Based on Another Column (4 Examples)

Jul 28, 2024

Example 1 - Combination of COUNTIF and IF Functions To create auto serial numbers with specific criteria, we’ll use the SUM, IF, and COUNTIF ...

How to Automatically Insert Serial Numbers in Excel Based on Another Column (4 Examples)

Auto Numbering in Excel After Row Insert (5 Suitable Examples)

Jun 20, 2024

Example 1 - Using the ROW Function Steps Select the range of cells B4:F12. Go to the Insert tab in the ribbon. From the Tables ...

Auto Numbering in Excel After Row Insert (5 Suitable Examples)

How to Make Excel Easier on the Eyes (12 Quick Tips)

Aug 1, 2024

This tutorial will guide you on how to make Excel spreadsheets easier on the eyes and pleasing to work with. 12 Quick Tips to Make Excel ...

How to Make Excel Easier on the Eyes (12 Quick Tips)

How to Make First Row as Header in Excel (4 Simple Methods)

Jul 6, 2024

Method 1 - Create First Row as Header by Freezing in Excel Steps: Click on the View tab from the ribbon. Click on the Freeze Panes. ...

How to Make First Row as Header in Excel (4 Simple Methods)

How to Make a Row Header in Excel (4 Easy Ways)

Jun 14, 2024

Here, we have provided a sample dataset that we will use to make a header row in Excel. As you can see, it's not particularly distinct from the data. ...