Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
j. martinez
 
Posts: n/a
Default 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   Report Post  
Posted to microsoft.public.excel.worksheet.functions
kassie
 
Posts: n/a
Default 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
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
pasting a range of info based on the value in a particular cell vsmith Excel Discussion (Misc queries) 0 February 10th 06 10:57 PM
Excel - give users option to keep info in clipboard after pasting Philipm Excel Discussion (Misc queries) 0 October 11th 05 06:29 PM
Adding info in the row at the bottom using macro? Carrie Excel Discussion (Misc queries) 1 April 14th 05 04:18 PM
Adding rows of different info from separate worksheets into summar Barry P New Users to Excel 1 February 8th 05 02:47 PM
Adding info onto a "permanent" form Howeey Excel Worksheet Functions 1 December 25th 04 08:12 PM


All times are GMT +1. The time now is 11:41 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"