r/excel 14h ago

Automatically copy formula from previous cell? unsolved

I have tried google which only tells me =B1 will copy A1. This is annoying if I need to make a change down the road and have to go back to the original cell to copy the formula. I want the formula to more or less be copy-pasted automatically in B1 whenever I make a change in A1. Is this possible? It's in tables.

1 Upvotes

10 comments sorted by

View all comments

1

u/Shiba_Take 80 13h ago

If you use Format as Table before making/editing formula it may happen.