How do you copy a formula in Excel vertically?

Originally Posted by Dave O 1. Highlight the vertical region that contains your formulas.2. Do a search and replace: search for the equal sign, and replace itwith your initials. T

How do you copy a formula in Excel vertically?
Quote

Originally Posted by Dave O

View Post

1. Highlight the vertical region that contains your formulas.
2. Do a search and replace: search for the equal sign, and replace it
with your initials. This converts all your formulas to text.
3. Copy the vertical region, and >Paste special >Transpoze. This
converts the vertical region to horizontal.
4. Search and replace again, but this time search for your initials
and replace with the equal sign.

When you converted the formulas to text the formulas became static. By
replacing your initials with the = sign in step 4 you converted them
back to dynamic formulas.

Video liên quan