Ask Questions, Get Answers
2
Points
Asked by hhhjkkjjlljljl - 3 years ago
All Answers
Sort By
Show
Richard Level 73 / Retired Dentist
Answered 3 years ago
-
In a spreadsheet you can refer to another cell in a formula by using a 'cell reference' such as A1. This refers to column A, row 1. The simplest formula would look like
=A1

But spreadsheets allow you to drag that formula down or across or even copy it to another cell. Normally the formula you end up with in each cell is different. For example the next cell down would have =B1

If you want to stick to the same cell, regardless of how you drag or copy it then you use an 'Absolute cell reference' like this

=$A$1

The $ tells the spreadsheet not to alter the formula as you drag or copy it to another cell.

Please remember to select a best answer button.
Related Questions
Need Answers Instantly?
About this Question
Open Question
1 Compliment
1 Answer
867 Views
Question Discussion
from Richard 3 years ago
Top Users this Week
faxman Level 18 Middle School
+1K
Exp
labarca Level 61 PhD
+1K
Exp
joensf Level 75 PhD
+1K
Exp
morrie Level 48 Grad School
+929
Exp
Sparky5458 Level 63 PhD
+917
Exp
Additional Links