Excel Basics

Open Excel Files (Multiple Windows and Instances)

In this article, I am going to show you various methods that you can use to open Excel files in different setups, such as opening the same Excel file ...

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

Add Gridlines in Excel (Complete Guideline)

In this article, you will learn all things you need to know about how to add gridlines in Excel and also ways to remove them. Gridlines in Excel ...

How to Skip Cells in Excel

Skip Cells in Excel: Knowledge Hub Skip Cells in Excel Formula Skip to the Next Cell If a Cell Is Blank in Excel Skip Cells When ...

Visible Cells Only Excel

This article will explain the importance of using visible cells only, how to use them effectively, and how it affects your Excel calculation. Excel ...

Swap Cells in Excel

This blog post will walk you through the process of swapping individual cells, rows, or columns, highlight its importance in data management, and ...

How to Unprotect Excel Sheets and Workbooks

Sometimes, we need to protect our Excel sheets or workbooks containing important data or calculations for security issues. If you remember the ...

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

How to Move Cells in Excel

  Move Cells in Excel: Knowledge Hub Move Cells in Excel with Arrow Keys Move Cells with Keyboard in Excel Move Filtered Cells in ...

Select Cells in Excel (A Complete Overview)

In this article, I will try to give a complete overview of select cells in Excel. This article will also include the selection of rows, columns, and ...

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

Working with Blank Cells in Excel

Excel Blank Cells: Knowledge Hub Remove Blank Cells in Excel Find If Cell is Blank in Excel Ignore Blank Cells in Range in Excel ...

Close the CTA

Advanced Excel Exercises with Solutions PDF

 

 

ExcelDemy
Logo