the new way is from microsoft help for excel 2007 note; remember that you highlite a cell in arow and when you insert a row it goes above the highlitted cell in that row. now saying that the new way is. highlite as many rows as you would like to insert example lets say you wish to add 20 rows and you wish to insert them above row9 1 highlite a cell in row 9 2 hold down the shift key and arrow down 20 times to ighlite 20 cells / rows 3 hit your apps key and arrow down to insert and arrow to add row and hit enter and it will add 20 rows above the 9th row in your sheet. From: John W. Carty [mailto:[email protected]] Sent: Wednesday, June 23, 2010 06:52 To: '[email protected]' Subject: excel 2007 OT Please forgive the OT question. I'm using win xp WE 7.2 and excel 2007. In excel 2007 I can insert a single row by pressing alt+I followed by r. However, I need the ability to insert 50 or 60 rows at a time to save lots of tiresome keystrokes. In excel 2003 I could press alt+I arrow down to row then tab across and type in a number then press enter and the desired rows would be inserted. Is there any such ability in 2007? What are the key strokes for this function? Thanx, John If you reply to this message it will be delivered to the original sender only. If your reply would benefit others on the list and your message is related to GW Micro, then please consider sending your message to [email protected] so the entire list will receive it. GW-Info messages are archived at http://www.gwmicro.com/gwinfo. You can manage your list subscription at http://www.gwmicro.com/listserv.
If you reply to this message it will be delivered to the original sender only. If your reply would benefit others on the list and your message is related to GW Micro, then please consider sending your message to [email protected] so the entire list will receive it. GW-Info messages are archived at http://www.gwmicro.com/gwinfo. You can manage your list subscription at http://www.gwmicro.com/listserv.
