PDA

View Full Version : Excel Keyboard Shortcut



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

Parry
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.

hth

mccauley
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.

pico
28-11-2006, 06:15 PM
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