---
title: "How cell reference is useful in the calculation in excel?"  
description: "How cell reference is useful in the calculation in excel?"  
author: "Steilla Mitchel"  
published: 2022-03-25  
canonical: https://answers.mindstick.com/qa/96540/how-cell-reference-is-useful-in-the-calculation-in-excel  
category: "troubleshooting"  
tags: ["troubleshooting", "excel"]  
reading_time: 2 minutes  

---

# How cell reference is useful in the calculation in excel?

How cell [reference](https://www.mindstick.com/forum/34619/call-by-value-and-call-by-reference) is [useful](https://yourviews.mindstick.com/view/81558/media-is-how-much-useful-for-us) in the [calculation](https://yourviews.mindstick.com/view/81720/google-does-largest-chemistry-calculation-new-chapter-in-quantum-computing) in excel?

## Answers

### Answer by Hitesh Vohra

- You can refer to data in worksheet cells by providing **cell references** in the formula arguments when you build a basic formula or a formula that employs a function. When you enter or pick cell reference A2, for example, the formula calculates the result using the value of that cell. A range of cells can also be referred to.
- To enter a formula in a cell, click it.
- Type = Button picture in the formula bar (equal sign).
- Select the cell containing the desired value or type the cell reference.
- A single cell, a range of cells, a place in another worksheet, or a location in a different workbook can all be referenced.
- When picking a range of cells, you can relocate the selection by dragging the cell selection's border, or expand the selection by dragging the corner of the border.' The initial cell reference is B3, and the colour is blue, with a blue border and square corners around the cell range.
- The second cell reference is C3, which has a green border with square corners and a green colour.
- Press Enter.

\

**Read More:** [**How can you apply the same formatting to every sheet in a workbook in MS-Excel?**](https://answers.mindstick.com/qa/96538/how-can-you-apply-the-same-formatting-to-every-sheet-in-a-workbook-in-ms-excel)

\


---

Original Source: https://answers.mindstick.com/qa/96540/how-cell-reference-is-useful-in-the-calculation-in-excel

Copyright © MindStick Software Pvt. Ltd. This Markdown version is provided for developers, AI systems, and offline reading.