How to use cell references with multiple worksheets in Excel

Before understanding this topic, you have to understand cell reference in a formula. Say I have a formula like this ‘=B3*C3+D3’. In this formula there are three cell references, they are B3, C3 and...

Absolute cell references in Excel

Before understanding absolute cell references, you have to understand cell reference in a formula. Say I have a formula like this ‘=B3*C3+D3’. In this formula there are three cell references, they are B3, C3,...

Relative cell references in Excel

Before understanding relative cell references, you have to understand cell reference in a formula. Say I have a formula like this ‘=B3*C3+D3’. In this formula there are three references, they are B3, C3, and...

What is active cell in Excel

Active cell is also referred to as cell pointer, or selected cell. An active cell refers to a cell in Excel spreadsheet that is currently selected by clicking mouse pointer or keyboard keys. Remember...

what is cell in excel definition

Every Excel worksheet/spreadsheet consists of columns and rows. Intersection of columns and rows make cells in Excel. Columns are labeled from A to XFD and rows range from number 1 to 1,048,576. Columns are...

What is cell in Excel

Every Excel worksheet/spreadsheet consists of columns and rows. Intersection of columns and rows make cells in Excel. Columns are labeled from A to XFD and rows range from number 1 to 1,048,576. Columns are...

Keyboard Shortcuts for Moving around Excel Spreadsheets

We shall discuss here the various ways and keyboard shortcuts to move the cells in an Excel Spreadsheet. Every Excel worksheet/spreadsheet consists of columns and rows. Columns are labeled from A to XFD and...

Understanding Excel spreadsheets

You will do all your works in a workbook file. You can add as many worksheets as you need in a workbook file. Each worksheet appears in its own window. By default, Excel workbooks...

New in Excel? Start Here

Hey! Nice to meet you and welcome to ExcelDemy.com. I am Kawser, the founder and main author of this blog. ExcelDemy.com is designed for beginning, intermediate and advanced level users of Microsoft Excel. All...

Excel 2013 New Features

The new version of an application comes with new features. Microsoft Excel 2013 (part of Microsoft Office 2013 suite) also has come with some unique and up-to-date features. Online Storage of Excel 2013 Excel...

What Excel is good for

Excel has been the world standard for many years. Excel is popular as it is versatile. ‘Excel is versatile’- means that you can do many things with Excel. Excel is best in numerical calculations,...

What is spreadsheet and how it works

A spreadsheet is basically a worksheet which is divided into rows and columns to store data; data from business inventories, income-expense report, and debit-credit calculations. Today’s business world uses electronic spreadsheets in the place...