ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   'select table row' (https://www.excelbanter.com/excel-discussion-misc-queries/237249-select-table-row.html)

dmgrant

'select table row'
 
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

Shane Devenshire[_2_]

'select table row'
 
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



All times are GMT +1. The time now is 05:33 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com