Suddenly Unable to Select Entire Table or Entire Column (but I can still select an entire table row)

jase71ds

Board Regular
Joined
Oct 23, 2006
Messages
137
Office Version
  1. 365
Platform
  1. Windows
Within an Excel table, you can mouse over the top of a heading and you will get a downward-pointing arrow and the ability to select the entire column.
You can mouse over the top leftmost cell, and you will get a diagonally-pointing arrow and the ability to select the entire table.

I've lost both of these features ☹

However I can hover my mouse at the leftmost of a row and I still do get the left-pointing arrow and the ability to select the entire row.

I am running the business version of MS365 and I have other tables within this same *.xlsx workbook that are working entirely as expected. It's just this one particular table that I've lost 2 of the 3 "arrow" select options.

I've poured through settings looking for a wayward toggle. Nothing.

Has anyone encountered this? Any thoughts on what is going on or how to fix it??

Thanks.
Jase.
 

Excel Facts

What do {} around a formula in the formula bar mean?
{Formula} means the formula was entered using Ctrl+Shift+Enter signifying an old-style array formula.

Forum statistics

Threads
1,224,829
Messages
6,181,224
Members
453,025
Latest member
Hannah_Pham93

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top