• We’re currently investigating an issue related to the forum theme and styling that is impacting page layout and visual formatting. The problem has been identified, and we are actively working on a resolution. There is no impact to user data or functionality, this is strictly a front-end display issue. We’ll post an update once the fix has been deployed. Thanks for your patience while we get this sorted.

Quick Excel Question

C

cchen

Diamond Member
I have data thats in a horizontal row, but i want it to be in a vertical column.

I tried referencing the first cell in the row (b$1) but when i drag the formula down it won't increment the b....

any ideas?
 
Are you saying you have a row of cells that you want to put in one column instead?

Select the cells in the row, click Copy.
Somewhere outside the area you just copied, click the cell you want to be the upper-left one for the paste. Go to Edit -> Paste Special and turn on Transpose before you click OK.
 
You must log in or register to reply here.

TRENDING THREADS

Back
Top