Excel Basics Archives - Page 114 of 176

Removing the Drop-Down Arrow in Excel: 6 Methods

Jun 16, 2024

Method 1 - Use the Filter Feature Steps: Select the range of cells for which you want to remove the arrow, e.g. columns B through E. ...

Removing the Drop-Down Arrow in Excel: 6 Methods

How to Find and Delete Rows in Excel (5 Methods)

Jul 18, 2024

Dataset Overview In this article, we'll illustrate five simple methods to locate and remove rows from your datasheet. We'll work with a dataset ...

How to Find and Delete Rows in Excel (5 Methods)

How to Sort in Excel by Number of Characters (2 Methods)

Jul 5, 2024

Method 1 - Using the LEN Function and a Helper Column Steps: Create a Helper column left to the main data table. Enter the following formula ...

How to Sort in Excel by Number of Characters (2 Methods)

How to Show Gridlines after Using Fill Color in Excel (4 Easy Methods)

Jul 2, 2024

Gridlines, the horizontal and vertical gray-colored lines that differentiate between cells in a worksheet, are displayed by default in an Excel ...

How to Show Gridlines after Using Fill Color in Excel (4 Easy Methods)

How to Not Print Empty Cells in Excel (3 Simple Methods)

Nov 11, 2025

In this article, we will learn how to not print empty cells in Excel. Sometimes, we import or download a dataset that contains empty cells. Often, we ...

How to Not Print Empty Cells in Excel (3 Simple Methods)

Why Do Gridlines Disappear in Excel? (5 Reasons with Solutions)

Jul 3, 2024

Solution 1 - Gridlines Disappear in Excel If Those Are Turned off If Gridlines are turned off then the Gridlines will not be visible in Excel. ...

Why Do Gridlines Disappear in Excel? (5 Reasons with Solutions)

How to Fix Cell Size in Excel (11 Quick Ways)

Nov 11, 2025

Sometimes we need to fix cell size in Excel to make the dataset more attractive. By default, every Excel worksheet contains the same-sized cells. We ...

How to Fix Cell Size in Excel (11 Quick Ways)

How to Use Filter in Protected Excel Sheet (With Easy Steps)

Nov 11, 2025

This article illustrates how you can allow people to use filter in your protected Excel sheet. You may need to do this to create a user-friendly ...

How to Use Filter in Protected Excel Sheet (With Easy Steps)

How to Wrap Text across Multiple Cells without Merging in Excel

Jun 17, 2024

Method 1 – Using the Format Cells Feature Steps: Highlight the cells along with the text you want to wrap text across. Go to the Home tab ...

How to Wrap Text across Multiple Cells without Merging in Excel

How to Print Excel Sheet in Full Page (7 Ways)

Jul 6, 2024

In this article, we’ll discuss seven different methods to print an Excel sheet on a one page. To illustrate these methods, we'll use the dataset ...

How to Print Excel Sheet in Full Page (7 Ways)

How to Change Lowercase to Uppercase in Excel Without Formula (5 Methods)

May 15, 2024

Here, we have a simple dataset containing two columns. Let's change the lowercase text in the left column to uppercase in the empty right column. ...

How to Change Lowercase to Uppercase in Excel Without Formula (5 Methods)

How to Print an Excel Sheet in A4 Size – 4 Methods

Jun 17, 2024

The following sample dataset has a large column width. Method 1 - Printing an Excel Sheet in A4 Size Using the Page Layout Tab Steps ...

How to Print an Excel Sheet in A4 Size – 4 Methods

How to Set a Row as Print Titles in Excel (4 Methods)

Nov 11, 2025

If you are looking for some special tricks to set a row as print titles in Excel, you've come to the right place. In Microsoft Excel. There are ...

How to Set a Row as Print Titles in Excel (4 Methods)

How to Filter Column Based on Another Column in Excel (5 Methods)

Apr 23, 2024

In this article, we’re going to show you 5 methods of how to use Excel to Filter a column based on another column. To demonstrate these methods, ...

How to Filter Column Based on Another Column in Excel (5 Methods)

How to Print an Excel Spreadsheet on Multiple Pages (3 Methods)

Jul 21, 2024

Dataset Overview For describing the methods, we will use a dataset of 80 householders' income and expenditure reports of a city. The dataset is in ...