## 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 comment to a certain cell when you wish to explain ...

## 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. It has three worksheets. The first worksheet is ...

## 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 archives as we have already discussed viewing ...

## 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 through the basics. Do let us know in the ...

## 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 range. Press CTRL and T on my keyboard. “Create ...

## Best 12 MS Excel Books for Beginners & Intermediate Users

So, you're a beginner or intermediate user of Excel and searching for the best Excel books that will take you to somewhere from nowhere. You're at the right place. Truly speaking, I was at your ...

## How to Use the Excel DAYS Function with a Practical Example

Excel has a variety of date and time functions that are very useful when working with calculations involving dates and times. The DAYS function, not to be confused with the DAY function, returns ...

## How to Insert or Delete Rows and Columns from Excel Table

In this post, we shall learn how you can add new rows or columns in a table and how you can delete existing rows or columns from a table. You can add a new row or new column in a table in two ...

## Date & Time in Excel – How to Enter Them in Worksheet Cells Effectively?

Date System in Excel An Excel date is simply a serial number. The earliest date that Excel can understand is January 1, 1900. This date has the serial number of 1. January 2, 1900, has the serial ...

## 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 in the worksheet. They are quite handy when you ...

## Viewing and Scrolling Multiple Excel Workbooks at the Same Time

Sometimes we work with more than one Excel workbook at a time. In this short article, I will show how you can view and scroll multiple Excel workbooks at the same time. At any given time, one and ...

## What is the Order & Precedence of Operations in Excel?

Understanding the order and precedence of operations in mathematical formulas or in an Excel Formula is very important. Excel has total 17 operators that you can use them to build complex Excel ...

## Exponential Notation in Excel & How to Turn Off Auto Scientific Notation!

This article will at first introduce you to the scientific number system and number precision definition. Then you will know about the highest and lowest number limitations in Excel. At the end of ...