View Full Version : Excel Keyboard Shortcut

28-11-2006, 03:29 PM
I'm trying to find a keyboard shortcut to insert a blank line(s) in an Excel spreadsheet.

28-11-2006, 04:03 PM
Could be wrong but I dont believe there is one. However, you can select a whole row then right click and select Insert. If your wanting to insert more than one row then select however many rows you want to insert (starting from the row you want to insert) then insert row at that point.


28-11-2006, 04:15 PM
I thought as much, which seems strange because there is just about a keyboard shortcut for every other conceivable function except this one which would be handy. Thanks for your reply.

28-11-2006, 06:15 PM

I think that the ins key works but the one that I have gotten accustomed to is [ctrl]and[+] (the plus key). Just select the row(s) you want to insert rows after and use that shortcut.

Also [ctrl]and[-] deletes a row(s) as you would expect. Its nice when things make sense esp from M$