Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Adding or pasting a row, but having info shift upwards not down??
Hello I would like to know if there is a way to add a row or insert
copied/cut cells in one row then have that row shift upwards not down. example: paste item #1 into line 10, then... paste item #2 into line 10, moving line 10 up not down so it reads as follows #1 not #2 #2 #1 there is information below line 10 that I cannot paste over. Am I over thinking this and there is an easy solution? |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Adding or pasting a row, but having info shift upwards not down??
To insert a row during a paste process, press <Ctrl<Shift<+. Row 10 will
become Row 11 "j. martinez" wrote: Hello I would like to know if there is a way to add a row or insert copied/cut cells in one row then have that row shift upwards not down. example: paste item #1 into line 10, then... paste item #2 into line 10, moving line 10 up not down so it reads as follows #1 not #2 #2 #1 there is information below line 10 that I cannot paste over. Am I over thinking this and there is an easy solution? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
pasting a range of info based on the value in a particular cell | Excel Discussion (Misc queries) | |||
Excel - give users option to keep info in clipboard after pasting | Excel Discussion (Misc queries) | |||
Adding info in the row at the bottom using macro? | Excel Discussion (Misc queries) | |||
Adding rows of different info from separate worksheets into summar | New Users to Excel | |||
Adding info onto a "permanent" form | Excel Worksheet Functions |