Hi,

Alt+F11 to open VB editor. Right click 'This Workbook' and insert module and
paste this in on the right

Sub insert()
Selection.EntireRow.insert
End Sub

Back on the worksheet:
Tools|Macro|Macros
From the dropdown select 'This Workbook' and highlight the macro name
Click 'Options'
Enter a letter to call your macro

Back on the worksheet CTRL+(Letter) will insert an entirerow.

Mike

"cravingmad" wrote:

Ages ago I set up a function (ctrl + 2 I think) so I could easily add a row
into an excel sheet without right clicking loads of times - unfortunatly I
need to do it again on another pc and can't remember how to do it - can
anyone help please - thank you.
Helen.