Q: Is there an easy way to copy formulas that are arranged horizontally across an Excel worksheet and paste them vertically down the page? When I try this using Excel’s Paste-Transpose command, the ...

Select the second range (Sheet2) Type = TRANSPOSE =TRANSPOSE (Sheet1!B2:H2) Confirm with CTRL + SHIFT + ENTER to obtain an array formula. Note: Only the content is copied, to the format of the ...

Q: To make an Excel table fit better on a page when I print it, I frequently have to transpose it—that is, move all the data from, say, rows 1, 2 and 3 and put them into columns A, B and C. To do that ...

One of our tips—the one about Excel's TRANSPOSE function—is useful in itself, but it's also a quick introduction to Excel's little-known but ultrapowerful array functions that make it possible ...