Excel Basics

How to Remove Gridlines in Excel When Printing – 6 Methods

The sample dataset showcases Student ID, Test Score, and Status. Method 1 - Using the Page Layout Tab to Remove Gridlines in Excel When ...

How to Add Cell Borders Inside and Outside in Excel (5 Methods)

Suppose we have a dataset of some Student’s Name, ID, and specific Departments. Let's add borders inside and outside the cells using Excel’s built-in ...

How to Remove Vertical Line in Excel: 5 Ideal Examples

Method 1 - Removal of Excel Frozen Pane Vertical Line Steps: Go to the View tab. Select the Freeze Panes option. Click on Unfreeze ...

How to Show Negative Numbers in Brackets and in Red in Excel (2 Methods)

Dataset Overview We will use a dataset containing 10 numbers of which 3 are negative. Method 1 - Using Excel's Format Cells Option  The ...

How to Remove Automatic Page Break in Excel: 3 Easy Ways

Method 1 - Using Excel Built-in Option to Remove the Automatic Page Break Steps: Open the worksheet and then go to Files in the top ...

How to Save an Image from Excel as a JPG (4 Methods)

Dataset Overview Let's use a dataset containing annual exam results for a school, with columns corresponding to Student, Physics, Chemistry, and ...

How to Center a Chart in Excel (2 Useful Methods)

In this article, we’ll discuss how to center a chart in Excel. To illustrate, suppose we have the dataset below named Sales in Different Branches. ...

How to Change the Background from Black to White in Excel (3 Ways)

Microsoft Excel has no built-in option to toggle a sheet’s background from black to white or vice versa. But here are 3 simple methods to change the ...

How to Hide and Unhide Status Bar in Excel (2 Easy Methods)

In this Excel tutorial, we will demonstrate how to hide and unhide the status bar. Reasons for hiding or unhiding the status bar in Excel mostly ...

How to Hide Highlighted Cells in Excel (2 Ways)

We will use the following data set. We have some student names, their grade percentages, and their attendance percentages. In the Student Name ...

Applying a Title Cell Style in Excel – 4 Methods

The image below showcases the difference between a normal cell style and a Title cell style in Excel.   Method 1 - Applying a ...

How to Insert Page Number in Excel (7 Easy Methods)

Method 1 - Using Page Layout View Style to Insert Page Number Steps: Go to the View tab and from the Workbook Views section, select Page ...

How to Convert Entire Column to Number in Excel (9 Methods)

Let's use the following dataset, which contains some Subject and Marks. The numbers are showing errors (or error suggestions) because the format is ...

How to Show Print Area in Excel: 4 Easy Methods

Method 1 - Using File Tab Option Steps: Select the whole data table. Go to the File tab option. Select the Print option. Go to ...

How to Apply All Borders in Excel (3 Methods)

The All Borders option is a formatting feature that allows you to apply a border around the entire selected range of cells. This means that a border ...

Advanced Excel Exercises with Solutions PDF

 

 

ExcelDemy
Logo