Ask Question
12 January, 14:26

For Excel:

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 formats will allow you to keep the same cell reference?

+2
Answers (1)
  1. 12 January, 14:29
    0
    I'm not sure what the 'following formats' are, but simply putting a $ in front of the letter will lock the column reference, and putting a $ in front of the number will lock the row reference. Putting a $ in front of both will allow you to keep the cell reference the same. For example:

    A1 should be A$1$ in an equation to keep the reference as A1 for all 'filled down' equations.
Know the Answer?
Not Sure About the Answer?
Find an answer to your question 👍 “For Excel: 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 ...” in 📗 Computers & Technology if the answers seem to be not correct or there’s no answer. Try a smart search to find answers to similar questions.
Search for Other Answers