Some of my workbooks have the option 'select' and then dropdown to 3 choices,
one of which is 'table row', in the right-click (contextual) menu.

Others do not have the 'select' available.
I am not the original author of these sheets and I use that function a lot.

Any ideas why some have the option and others do not?

They are all xlsx format.

Thx

David Grant

Hi,

You must be in a table to see this command on the context menu. Even if a
range looks like a table, if it is not, you will not have these options. You
can tell if a range is a table by placing your mouse in it and seeing if the
Table supertab appears.

--
If this helps, please click the Yes button.

Cheers,
Shane Devenshire


"dmgrant" wrote:

Some of my workbooks have the option 'select' and then dropdown to 3 choices,
one of which is 'table row', in the right-click (contextual) menu.

Others do not have the 'select' available.
I am not the original author of these sheets and I use that function a lot.

Any ideas why some have the option and others do not?

They are all xlsx format.

Thx

David Grant