Ask Question
22 August, 07:53

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. 22 August, 08:18
    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 and Technology if you're in doubt about the correctness of the answers or there's no answer, then try to use the smart search and find answers to the similar questions.
Search for Other Answers