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 discuss and show how to copy and paste into Excel. We will extensively explain the topic with examples for your better ...

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

Save in Excel (Complete Guideline)

In this article, we will learn how to save a workbook in Excel. We will also learn how to save your current Excel file after changing, modifying or ...

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

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)

Here's an overview of removing the gridlines from a dataset. Download the Practice Workbook Editing Gridlines.xlsx Removing ...

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

Show Gridlines in Excel 

In this article, you will learn the ins and outs of how to show gridlines in Excel. We will also discuss how to hide and change gridline's color, how ...

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