Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
how do I insert a blank row when pasting?
Hi: I have a column of numbers which I want to copy and paste to another column, but I would like to insert a blank row after each number, for example I would like to copy the number from A1 into B1, then A2 into B3 (B2 becomes blank), A3 into B5 (B4 becomes blank) etc. hope this is clear thanks -- mimmo ------------------------------------------------------------------------ mimmo's Profile: http://www.excelforum.com/member.php...o&userid=26724 View this thread: http://www.excelforum.com/showthread...hreadid=508239 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How to quickly insert a blank row every 5 rows? | Excel Discussion (Misc queries) | |||
How to delete blank rows | Excel Discussion (Misc queries) | |||
blank cell turns to 0 | New Users to Excel | |||
HOW CAN I AUTOMATICALLY INSERT ALTERNATE BLANK ROWS IN A LIST? | Excel Discussion (Misc queries) | |||
Function to automatically insert a new sheet as a result of data entry? | Excel Worksheet Functions |