Hello,
I recently updated Excel and am running into an error that I don't know how to fix.
I'm organizing data into columns and I'm only able to write formulas in the top cell of the column. When I try to drag the formula down as I normally would, I get a #SPILL! error.
When I mouse over the cells below the top cell in the column, the formula shows up in the formula box at the top (greyed out), but when I try to click it to edit it, the cell is actually empty. I thought this might be a quirky autofill setting, but I turned that off in my settings and this is still happening.
The formula is calculating mostly fine even though it's 'ghost' autofilled, but there are a couple of errors in random cells that I'd like to audit, but cannot because (as I said) Excel shows that the cell is empty, so I can't investigate that cell specifically.
What is going on here? How do I fix this? I just want it back the way it used to be, where I could click and drag formulas.
Thank you!
I recently updated Excel and am running into an error that I don't know how to fix.
I'm organizing data into columns and I'm only able to write formulas in the top cell of the column. When I try to drag the formula down as I normally would, I get a #SPILL! error.
When I mouse over the cells below the top cell in the column, the formula shows up in the formula box at the top (greyed out), but when I try to click it to edit it, the cell is actually empty. I thought this might be a quirky autofill setting, but I turned that off in my settings and this is still happening.
The formula is calculating mostly fine even though it's 'ghost' autofilled, but there are a couple of errors in random cells that I'd like to audit, but cannot because (as I said) Excel shows that the cell is empty, so I can't investigate that cell specifically.
What is going on here? How do I fix this? I just want it back the way it used to be, where I could click and drag formulas.
Thank you!