Excel Basics

How to Print Excel Sheet with Table (4 Methods + Tricks)

Method 1 - Print Only Table from an Excel Sheet Our sample dataset is in the B4:I79 cell range. The worksheet has a chart, the table, and the ...

How to Remove Percentage Symbol in Excel (7 Ways)

The dataset below will be used to demonstrate how to remove percentage symbols in Excel. Method 1 - Use Custom Formatting to Remove the ...

[Fixed!] Name Manager Delete Option Greyed out in Excel (3 Reasons with Solutions)

We name ranges in Excel to make workbooks simpler to understand, formulae quicker to enter and analyze, and to construct variable-size ranges to keep ...

Removing the Drop-Down Arrow in Excel: 6 Methods

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

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

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 Sort in Excel by Number of Characters (2 Methods)

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 Show Gridlines after Using Fill Color in Excel (4 Easy Methods)

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

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

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

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

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

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

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 Use Filter in Protected Excel Sheet (With Easy Steps)

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 Wrap Text across Multiple Cells without Merging in Excel

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 Print Excel Sheet in Full Page (7 Ways)

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 Change Lowercase to Uppercase in Excel Without Formula (5 Methods)

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 Print an Excel Sheet in A4 Size – 4 Methods

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

Close the CTA

Advanced Excel Exercises with Solutions PDF

 

 

ExcelDemy
Logo