Excel Basics

How to Paste in Excel – A Complete Guide

This is an overview. Download Practice Workbook Download the following file and practice. Paste in Excel.xlsx How to ...

How to Copy and Paste in Excel

In this article, we will comprehensively discuss and demonstrate how to copy and paste in Excel. Download Practice Workbook Copy and ...

How to Sort in Excel – 6 Examples

Download Practice Workbook Download the free Excel worksheet. Sort.xlsx Example 1 - Sort in Ascending Order To sort the dataset ...

Save in Excel (Complete Guideline)

In this article, we will comprehensively discuss how to save a workbook in Excel. Saving your file is essential if you don't want to lose your ...

How to Recover an Excel File? (Overwritten and Deleted Files)

This is an overview. Click the image for a detailed view Download Practice Workbook Recover Files.xlsx Method 1 - Recover ...

Excel AutoSave (Including VBA Macro)

Here's an overview of using the AutoSave option for Excel. Download the Practice Workbook Excel AutoSave.xlsm What Is ...

[Fixed!] Excel Is Not Opening Files (14 Solutions)

Method 1 - Open File with MS Excel It is possible to open some spreadsheet with different applications. However, you must open .xlsx, .xlsm, or .csv ...

How to Add, Format & Remove Titles in Excel (Complete Guideline)

Dataset Overview We will use the following dataset containing the sales report of a company. What Is a Title in Excel? A title in Excel ...

All About Excel Files (Types, Extensions, Open, Merge, Etc. )

What Are the Available File Types That Are Supported in Excel? Excel supports 3 file formats. Their names, extensions, and details are in separate ...

Edit Gridlines in Excel (Add, Remove, Change, and Print)

This is an overview: Download the Practice Workbook Editing Gridlines.xlsx Removing Gridlines in Excel Worksheets Go to ...

Formatting Worksheet in Excel: 11 Examples

1. Turning Off Gridline in an Excel Worksheet Go to the View tab. Uncheck the Gridlines option to disable it. The gridlines will turn off ...

How to Show the Gridlines in Excel – 3 Methods

This is an overview. Download Practice Workbook Download the practice workbook. Show Gridlines in Excel.xlsx Method 1 - ...

How to Hide Cells in Excel – 3 Methods

This is an overview. Download Practice Workbook Hide Cells.xlsx Method 1 - Using the Keyboard Shortcut to Hide Cells ...

Excel Cell Size (Change and Adjust)

In this Excel tutorial, you will learn everything about adjusting and changing cell size in Excel. Here's an overview of one of the 10 methods we'll ...

Spell Check in Excel – 4 Methods

This is an overview: Download Practice Workbook Download the practice workbook. Spell Check.xlsm 1. Using the Spelling ...

Advanced Excel Exercises with Solutions PDF

 

 

ExcelDemy
Logo