Excel Basics

How to Make Excel File Read Only (2 Quick Methods)

If you want no one can edit or update your Excel file without your permission, you can make your Excel file read-only. No problem if you don't know ...

How to Print Excel Spreadsheet with Lines and Change Its Color

Have you ever wanted to change the color of the gridlines in Excel or perhaps print the gridlines in your worksheet? Look no further since I will ...

How to Apply Accounting Number Format in Excel (4 Easy Ways)

If you are looking for how to apply the accounting number format, then you are in the right place. In this article, we'll try to discuss how to apply ...

Creating and Editing Comments in Excel (4 Practical Examples)

While working in Microsoft Excel Sometimes we feel the need to create and edit comments so that other users can see and reply according to them. I ...

Viewing Excel Worksheets in Multiple Ways

In this tutorial, we will be discussing how you can view worksheets of an Excel workbook in multiple ways. For example, look at this workbook. ...

How to Hide and Unhide Excel Worksheets from a Workbook

If you are looking for how to hide and unhide Excel worksheets from a workbook, then you are in the right place. In some situations, while using ...

Excel Table vs. Range: What Is the Difference?

There is a great deal of confoundment regarding Table and Range in Excel. Especially, the new Excel users often mistake a table for a range and vice ...

Excel Table Formatting Tips – Change the Look of the Table

When we create a table, Excel applies the default table style. Say I want to make the following range into a table. I just select any cell within the ...

How to Add or Remove Cell Borders in Excel

In the last edition of our posts, you read about aligning contents in the cells in all directions possible. Today we will be focusing on cell borders ...

Viewing Multiple Workbooks: Synchronous Scrolling in Excel

Sometimes we work with more than one Excel workbook at a time. In this short article, I will show how you can view and use Excel Synchronous ...

What Is the Order of Operations in Excel (An Ultimate Guide)

Everything in this world run in order. In terms of working with Microsoft Excel, you also need to maintain the order of operations. Understanding the ...

How to Use Paste Special Command in Excel (5 Suitable Ways)

We are all familiar with Cut/Copy and Paste commands. They’ve been around since the early days of word processing, and they are universal across ...

How to Use Microsoft Excel for Beginners (25 Common Tasks)

Microsoft Excel is one of the most widely used applications worldwide. It is very popular with medium and small enterprises. But this article is for ...

How to Copy Formula in Excel to Other Cells (2 Easy Ways)

While you are working with Excel, you will have to copy formulas frequently from one cell to another cell. This article will show you how to copy ...

What Is Contextual Tab in Excel? (With Easy Examples)

This tutorial will demonstrate how to use the contextual tab in Excel. In case of insert any charts, tables, or shapes, then you will notice that you ...

Advanced Excel Exercises with Solutions PDF

 

 

ExcelDemy
Logo