Excel Basics

How to Copy a Worksheet in Excel (5 Smart Ways)

In Excel, there are many ways to copy a worksheet in the same or different workbook. In this article, we will see many processes on how to copy a ...

How to Show Formula in Excel Cells Instead of Value (6 Ways)

In Excel, a lot of things are done using the functions that together make formulas. In this article, we are going to show you some tips on "How to ...

How to Copy and Paste Multiple Cells in Excel (7 Quick Ways)

In this article, we will analyze how to copy and paste multiple cells in Excel. It`s easy to copy and paste a single cell in Excel. When it comes to ...

Excel Formula Symbols Cheat Sheet (13 Cool Tips)

In this article, you are going to see some Excel formula symbols cheat sheet. This article will be helpful for learning about the process of ...

How to Insert Formula in Excel for Entire Column (5 Smart Ways)

It`s often occurred to everyone that after applying formula in a cell of Excel you needed to use that formula for the entire column. In this article, ...

How to Make an Excel File Read Only

If you do not like it without your permission no one can edit or update your Excel file, you can make your Excel file read-only. If you don't know ...

Top 10 ExcelDemy Blogs of 2017

2017 was a great year for Excel and Excellers (those of us who love using Excel for work or study purposes and can’t wait to learn more about this ...

How to Print Excel Spreadsheet with Grid 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? Well, look no further, since we ...

How to Apply Accounting Number Format in Excel! (Easy way)

The Accounting Format is similar to the Currency format and can be applied to numbers where needed. The difference between the Accounting format and ...

Creating and Editing Excel Comments to Cells – [An Ultimate Guide]!

Today’s post will be concerned with comments. We will be seeing how and when to use them. So let's get started. Firstly, you normally insert a ...

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

Hide and Unhide Excel Worksheets from a Workbook

Hi folks, we hope you are learning a great deal from our series on workbook and worksheet management. If you missed out on any information visit our ...

What is the Difference between a Table and a Range in Excel?

With this post, we shall be starting our Excel Table series. Today’s post, in particular, will give you an overview of the topic at hand and walk you ...

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

ExcelDemy
Logo