Excel Basics Archives - Page 61 of 176

How to Change the Conditional Formatting Icon Set Color in Excel – 4 Steps

Aug 9, 2024

This is an overview. You can see the different colors of the icons in the columns "Before Changing" and "After Changing." In the image ...

How to Change the Conditional Formatting Icon Set Color in Excel – 4 Steps

How to Add Negative Numbers in Excel – 4 Methods

Aug 10, 2024

The sample dataset contains Categories and Expenses. Method 1 - Using the SUMIF Function to Add Negative Numbers in Excel Steps: ...

How to Add Negative Numbers in Excel – 4 Methods

How to Make Negative Accounting Numbers Red in Excel – 3 Methods

Aug 2, 2024

The sample dataset contains monthly expenses, their amount and the balance after the expenses. Method 1 - Using Excel Conditional ...

How to Make Negative Accounting Numbers Red in Excel – 3 Methods

How to Create a Contact List in Excel – 2 Steps

Aug 2, 2024

Step 1: Create a Dataset A table with “First Name” and “Last Name” was created. Insert two columns to enter “Mail ...

How to Create a Contact List in Excel – 2 Steps

How to Change Gridlines to Dash in Excel (with Easy Steps)

Jun 16, 2024

Microsoft Excel opens by default showing solid gridlines like in the following picture. Let's change the gridlines from solid to dash. ...

How to Change Gridlines to Dash in Excel (with Easy Steps)

How to Fix an Excel File That Is Open but Not Visible

Jun 18, 2024

In the following dataset, we have the Monthly Sales Data of ABC Foodcourt. If our Excel file is open but not visible, then it will look like ...

How to Fix an Excel File That Is Open but Not Visible

Troubleshooting Excel Print Area Issues (2 Possible Solutions)

Jul 16, 2024

Solution 1 - Using Page Break Preview If the Excel Set Print Area feature isn’t working as expected, try this first solution. Page Break Preview ...

Troubleshooting Excel Print Area Issues (2 Possible Solutions)

How to Move Page Breaks in Excel (With Easy Steps)

Nov 11, 2025

If you are looking for ways to move Page Breaks in Excel, this article will serve the purpose. Moving Page Breaks gives you a customized outlook of ...

How to Move Page Breaks in Excel (With Easy Steps)

How to Keep Gridlines When Copy and Paste in Excel (2 Ways)

Nov 11, 2025

Instead of writing the same thing again and again, we often use Copy and Paste command. It saves both time and hustle. In Microsoft Excel, we can ...

How to Keep Gridlines When Copy and Paste in Excel (2 Ways)

How to Draw Arrows in Excel – 3 Methods

Aug 13, 2024

Consider the dataset below. It showcases Product names and Sales in January and in February. Insert an up or a down arrow to indicate the increase ...

How to Hide Header and Footer in Excel (2 Easy Methods)

Jul 28, 2024

We have a dataset of some Student Names and their respective Departments. We will add the header and footer to this workbook. While in the ...

How to Hide Header and Footer in Excel (2 Easy Methods)

How to Hide Columns Without Right Click in Excel (3 Ways)

Nov 11, 2025

In terms of using Microsoft Excel, we can keep unnecessary or confidential data hidden. We can even hide the entire data. While hiding the entire ...

How to Hide Columns Without Right Click in Excel (3 Ways)

How to Create Table of Contents Without VBA in Excel

Nov 11, 2025

While working with Microsoft Excel, you may have dealt with several sheets in your workbook. However, if you need to create a table of contents with ...

How to Create Table of Contents Without VBA in Excel

How to Insert Logo in Excel Header (4 Easy Ways)

Nov 11, 2025

Looking for ways to know how to insert logo in Excel header? We want to insert a logo of a company or institute in Excel header. Here, you will find ...

How to Remove the Page Number from the Page Break Preview in Excel – 2 Methods

Aug 6, 2024

When you view a worksheet in Page Break Preview, Excel displays page breaks as dashed lines. By default, the page number appears at the center of ...