Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Copy & Paste converting rows to columns
With data in Sheet1 Row1 from colA to ColJ; try the below formula in Sheet2
and copy down as required... =INDEX(Sheet1!$A$1:$J$1,ROW(A1)) or for the entire row 1 in Sheet1 =INDEX(Sheet1!$1:$1,ROW(A1)) -- Jacob "MJC" wrote: I have an input worksheet for which the data is input across the page (ie. Column a,b etc). On the next worksheet I have made formulas that I want to copy down the page by rows. What i want to know is it possible to copy a formula and paste it down by rows but instead of changing the row number it changes the column letter leaving the row number the same? Thanks in advance |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
how do i paste rows/columns avoiding hidden rows/columns | Excel Discussion (Misc queries) | |||
Converting Rows to Columns | Excel Discussion (Misc queries) | |||
Converting columns into rows | Excel Discussion (Misc queries) | |||
(Again) Converting rows to columns | Excel Discussion (Misc queries) | |||
Converting Rows to Columns? | Excel Discussion (Misc queries) |