Excel Basics

How to Merge and Center a Title in Excel (with Shortcuts)

Excel Merge and Center - in database programming, the merge cell function allows neighboring cells to be combined into one larger one. You finish the ...

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 Use Number with Filter in Excel (5 Useful Methods)

If you are looking for how to use number with filter in Excel, then you are in the right place. In our practical life, we often need to filter our ...

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

How to Hide Data in Excel (All Things You Need to Know)

In this Excel tutorial, we will learn how to - Hide the Entire row and column - Hide data using different features from the toolbar - Hide ...

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 Add Gridlines for Specific Cells in Excel (3 Easy Methods)

While working in Microsoft Excel, we might find files with no gridlines in the workbook. In that scenario, we might feel the need to add gridlines ...

How to Change Page Orientation in Excel (2 Simple Methods)

If you are looking for simple ways to change page orientation in Excel, this article will serve the purpose. Excel by default uses the Portrait ...

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 Remove Gridlines from Table in Excel (2 Examples)

There may be some instances where you need to remove gridlines from tables. In Microsoft Excel, you can do this type of task within seconds. This ...

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

Close the CTA

Advanced Excel Exercises with Solutions PDF

 

 

ExcelDemy
Logo