Excel 2010 and Insert Lines

[James Silverton]

Hi!
In my previous version of Excel (2003, I think), I could readily insert
a set of blank lines by blocking out an area of the required size below
the desired point. I don't seem to be able to do that any more. Am I
missing a new command or something?

TIA

 

[GS]

James Silverton used his keyboard to write :

Hi!
In my previous version of Excel (2003, I think), I could readily insert a set
of blank lines by blocking out an area of the required size below the desired
point. I don't seem to be able to do that any more. Am I missing a new
command or something?

TIA

Did you try right-clicking your selection and choosing 'Insert...' from
the popup menu?

 

[James Silverton]

James Silverton used his keyboard to write :

Did you try right-clicking your selection and choosing 'Insert...' from
the popup menu?

That was a new method for me but it worked. I can't check that it worked
in 2003.

Many Thanks!

 

[GS]

James Silverton was thinking very hard :

That was a new method for me but it worked. I can't check that it worked in
2003.

Many Thanks!

You're welcome! AFAIK, it's been on that menu forever.