Excel: Unable to select a row or column from a table

Solved
Grizzly02934 Posted messages 5 Status Member -  
Grizzly02934 Posted messages 5 Status Member -
Hello everyone,

I have a small problem with Excel that I would like to share with you:
I have a classic table (8 columns, 200 rows, named "Table1") and for a few days I haven't been able to select rows or columns in this table with the mouse using the little black arrow at the top of a column or to the left of a row, like in this example:

http://www.mdf-xlpages.com/modules/publisher/item.php?itemid=189

The famous little black arrow no longer appears, and thus I can no longer select a column or row except with the right-click.

Does anyone have an idea, a manipulation, or a keyboard shortcut that would allow me to recover this black arrow?

Best regards.

3 answers

Raymond PENTIER Posted messages 58207 Registration date   Status Contributor Last intervention   17 476
 
Please send your file, or that of an example table showing the same malfunction.
 1) Go to https://www.cjoint.com/ 
2) Click on [Browse] to select your file (max 15 MB)
3) Scroll down to click on the blue button [Create Cjoint link]
4) After a few seconds, the second page appears, with the link in bold; right-click on it and choose "Copy link"
5) Return to your discussion on CCM, and in your message, do "Paste".
=>See the guide https://www.commentcamarche.net/faq/29493-utiliser-cjoint-pour-heberger-des-fichiers
There are also:
1) https://mon-partage.fr/
2) https://www.transfernow.net/

--
Retirement is great! Especially in the Caribbean...
Raymond (INSA, AFPA)
0
Grizzly02934 Posted messages 5 Status Member
 
Thank you for your response.
Here is the file in a lighter version.

https://www.cjoint.com/c/IGyuJB0tf4M

The table that is causing problems is in the account tab, while there is another table that works very well in the list tab.
0
Raymond PENTIER Posted messages 58207 Registration date   Status Contributor Last intervention   17 476
 


Hi.

Your file works perfectly well
on my computer...

--
Retirement is great!
Especially in the Caribbean...
Raymond (INSA, AFPA)
0
Grizzly02934 Posted messages 5 Status Member
 
Hello,
Thank you for your reply, however, it is not this selection method that interests me, but rather when the mouse cursor is positioned over the header of the table, at the top of cell C2 in the accounts tab for example.
0
Raymond PENTIER Posted messages 58207 Registration date   Status Contributor Last intervention   17 476
 
Sorry: I've never had to deal with this kind of problem...
0
gyrus
 
Hello,

Copying the table to another sheet seems to solve the problem ...
https://www.cjoint.com/c/IGzgNieraCj

Best regards.
0
Grizzly02934 Posted messages 5 Status Member
 
Hello,

Indeed, in the original, a cut/paste allows to maintain the links with the formulas, which is perfect.

It will remain a mystery, but thank you nonetheless :)
0