Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Copying cell References from Columns to Rows
Without manually having to enter every cell reference I need ot copy multiple
cells from a column into various rows Eg : I want to copy Comunm M : M162:M166 (M168:M172 ...............) etc to Row 138 : C138, D138, E138, F138, G138 Row 139 : C,D,E,F,G Row 140 etc Is there a quick copy and paste method for this Or do you have to refernce every cell Regadrs, Michael Regadrs, Mick |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
prevent changes to cell references when copying and pasting | Excel Discussion (Misc queries) | |||
Copying Spreadsheet with Cell References Into A Different Workbook | Excel Discussion (Misc queries) | |||
How to control cell references when copying a formula? | Excel Discussion (Misc queries) | |||
copying sheet references that refer to a cell in the preceding she | Excel Worksheet Functions | |||
Copying linked cell references. | Excel Worksheet Functions |