Forum Home
Press F1
 
Thread ID: 74583 2006-11-28 02:29:00 Excel Keyboard Shortcut mccauley (8734) Press F1
Post ID Timestamp Content User
502699 2006-11-28 02:29:00 I'm trying to find a keyboard shortcut to insert a blank line(s) in an Excel spreadsheet. mccauley (8734)
502700 2006-11-28 03:03:00 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.

hth
Parry (5696)
502701 2006-11-28 03:15:00 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. mccauley (8734)
502702 2006-11-28 05:15:00 Hi,

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$

HTH
pico (4752)
1