Excel Context Menu - 'Insert' functionality change over time?

[Matt]

I'd appreciate assistance or reminiscences from anyone with a good memory,
or who still uses an old (probably 98 or before) version of Office.

A couple of years ago now, we did an Active Directory and Windows/Office
2000 desktop refresh for one of our customers. I still keep in touch with
their support staff, and they pass any questions they can't answer on to me.

One of their users is convinced that in the previous version of Excel, if he
were to right-click on a cell, he would have a cascading 'Insert' option
which allowed him to choose to insert Cells, Rows, Worksheets, Pictures
etc - basically a relevant subset of the full insert menu.

Now, the insert option on the context menu just inserts a cell, and offers
choices as to the behaviour of surrounding cells.

I assume that this is a functionality change between versions (or faulty
memory in the user ) but would appreciate if anyone could help clear it
up?

I'm not looking to turn this into "OMG where did this amazing feature
go???!!!1!" - if it's gone, then its gone, and its not really far to move
the mouse to get the full insert menu anyway.

TIA,
Matt McNally.

 

[Bernard Liengme]

When I right click on cell in Excel 2003 the popup menu includes Entire Row
and Entire Column
Suggest he/she try it on new file in case the old one has some protection
set

Also, respectfully recommend you post Excel questions to
news://msnews.microsoft.com/microsoft.public.excel.misc

where more XLers lurk.

 

[Matt]

When I right click on cell in Excel 2003 the popup menu includes Entire
Row and Entire Column
Suggest he/she try it on new file in case the old one has some protection
set

Also, respectfully recommend you post Excel questions to
news://msnews.microsoft.com/microsoft.public.excel.misc

where more XLers lurk.

Bernard,

Many thanks for both suggestions - reposting now.

I'll also retry the popup menu - but he's insistent that it included the
ability to insert objects - I'll see what the Excel crowd have to say.

Regards,
Matt.