Wikiposts
Search
Computer/Internet Issues & Troubleshooting Anyone with questions about the terribly complex world of computers or the internet should try here. NOT FOR REPORTING ISSUES WITH PPRuNe FORUMS! Please use the subforum "PPRuNe Problems or Queries."

Excel keystroke shortcuts?

Thread Tools
 
Search this Thread
 
Old 31st Mar 2009, 14:53
  #1 (permalink)  


Moderator
Thread Starter
 
Join Date: Mar 2003
Location: Orlando, Florida
Age: 69
Posts: 2,586
Likes: 0
Received 0 Likes on 0 Posts
Excel keystroke shortcuts?

Heyas,

I'm trying to "Insert New Row" with a keystroke in Excel 2007.

I've found lots of keystrokes in my Google search - but this never seems to be mentioned.

Anybody know one?

=^..^=
Keygrip is offline  
Old 31st Mar 2009, 15:12
  #2 (permalink)  
Spoon PPRuNerist & Mad Inistrator
 
Join Date: Sep 2003
Location: Twickenham, home of rugby
Posts: 7,417
Received 281 Likes on 179 Posts
I don't think there is a single keystroke, but you can do it with ALT+I followed by enter (assuming that you have already positioned the cursor in the row below where you want to insert the new row.

It is almost as easy to just Rt-click the row number on the LHS which immediately opens a menu, then just click insert.

If you then wish to insert more rows, just press F4 as many times as necessary.

This is with Office XP (2002) and 2003. I have no idea what MS have done with Orifice 2007

SD
Saab Dastard is offline  
Old 31st Mar 2009, 15:50
  #3 (permalink)  
bnt
 
Join Date: Feb 2007
Location: Dublin, Ireland. (No, I just live here.)
Posts: 733
Received 8 Likes on 7 Posts
In Excel 2007, I just to Alt-I R to insert a row. There is a shortcut to select a row: Alt-Space. (Ctrl-Space to select a column).
bnt is offline  
Old 31st Mar 2009, 17:33
  #4 (permalink)  


Moderator
Thread Starter
 
Join Date: Mar 2003
Location: Orlando, Florida
Age: 69
Posts: 2,586
Likes: 0
Received 0 Likes on 0 Posts
Thankees, folks - exactly what I was looking for.

It did need three keys, SD. Alt I and then R.

Data entry MUCH quicker now.
Keygrip is offline  

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

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



Contact Us - Archive - Advertising - Cookie Policy - Privacy Statement - Terms of Service

Copyright © 2024 MH Sub I, LLC dba Internet Brands. All rights reserved. Use of this site indicates your consent to the Terms of Use.