How do you make a row equal a column while keeping the formula consistent? I tried using the array command (CTRL-SHIFT-ENTER) but all it does is copy the 1st formula. I also tried using the $ commands but they don't work when you go from column to row or vice versa...why?!. Why would Excel limit...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.