View original (French)

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

  1.
    Raymond PENTIER Posted messages 58213 Registration date   Status Contributor Last intervention   17 482
     
    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
    1. 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
  2. Raymond PENTIER Posted messages 58213 Registration date   Status Contributor Last intervention   17 482
     


    Hi.

    Your file works perfectly well
    on my computer...

    --
    Retirement is great!
    Especially in the Caribbean...
    Raymond (INSA, AFPA)
    0
    1. 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
    2. Raymond PENTIER Posted messages 58213 Registration date   Status Contributor Last intervention   17 482
       
      Sorry: I've never had to deal with this kind of problem...
      0
  3. gyrus
     
    Hello,

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

    Best regards.
    0
    1. 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