| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
skip rows
How can I drag value from A1 to B1, from A6 to B2, from A12 to B3,....etc
|
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
skip rows
Select the cell (or range) to copy, and Ctrl/C, then select the first cell to be copied to, and hold the CTRL key to select other cells or cell ranges. Ctrl/V to complete the copy. -- marat Wrote: How can I drag value from A1 to B1, from A6 to B2, from A12 to B3,....etc -- Bryan Hessey ------------------------------------------------------------------------ Bryan Hessey's Profile: http://www.excelforum.com/member.php...o&userid=21059 View this thread: http://www.excelforum.com/showthread...hreadid=532876 |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
skip rows
On second reading, did you want column B to be set with the contents of A1, A6, A11, A16, A21 etc, (ie, every 5th cell taken to the next column), and what of the remaining cells, do these go to column C, D, E and F ? -- Bryan Hessey Wrote: Select the cell (or range) to copy, and Ctrl/C, then select the first cell to be copied to, and hold the CTRL key to select other cells or cell ranges. Ctrl/V to complete the copy. -- -- Bryan Hessey ------------------------------------------------------------------------ Bryan Hessey's Profile: http://www.excelforum.com/member.php...o&userid=21059 View this thread: http://www.excelforum.com/showthread...hreadid=532876 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| auto expand rows | Excel Worksheet Functions | |||
| Rows & Columns in Excel | Excel Worksheet Functions | |||
| Automatically inserting rows | Excel Worksheet Functions | |||
| Hiding Rows if the linked rows are blank | Excel Discussion (Misc queries) | |||
| flexible paste rows function that inserts the right number of rows | Excel Discussion (Misc queries) | |||
Linear Mode
