Excel Basics Archives - Page 61 of 176

[Fixed!] Table Border Not Showing in Print Preview (2 Solutions)

Nov 11, 2025

In order to decorate our data while working with Microsoft Excel, we often use tables. Normally, the data are organized in different rows and columns ...

[Fixed!] Table Border Not Showing in Print Preview (2 Solutions)

2 Ways to Add the Fill Color Icon to Quick Access Toolbar in Excel

Aug 2, 2024

Here's the overview of adding the Fill Color command to the Quick Access Toolbar. Method 1 - Using the Context Menu of the Excel Ribbon ...

How to Use Sheet View in Excel (with Simple Steps)

Jul 29, 2024

We have made a dataset to use the Sheet View ribbon. It has column headers: Branch Name, Sales Rep, Product Name, and Sales. Step 1 - ...

How to Use Sheet View in Excel (with Simple Steps)

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