You plan to use the Fill Down feature on a formula and you need to keep a cell reference the same. Which one of the following fo

Question

denis-greek [22]

3 years ago

7

You plan to use the Fill Down feature on a formula and you need to keep a cell reference the same. Which one of the following fo

rmats will allow you to keep the same cell reference

Computers and Technology

1 answer:

viva [34] · Answer 1 · 2022-05-02T22:22:00+03:00

viva [34]3 years ago

3 0

You have to use this format for example $A$2
The format for absolute reference is designated with a dollar sign ($). If both column and, put a dollar sign before and in between the row and column. By doing this, column and row do not change when copied.