View original (French)

Table cell merge grayed out, impossible to use

Polo141 Posted messages 215 Status Member -  
Raymond PENTIER Posted messages 58213 Registration date   Status Contributor Last intervention   -
Hello,

I am using Excel 2010, but I believe it's the same in other versions.

When I have a formatted table automatically, I cannot merge 2 cells, the "merge and center" button is grayed out. How can I work around this issue since I don't want to count the value twice when I apply a filter?

Configuration: Windows / Opera Next 46.0.2597.32

2 answers

  1.
    Raymond PENTIER Posted messages 58213 Registration date   Status Contributor Last intervention   17 482
     
    Without having the file at our disposal, it's difficult to offer you a solution... 
     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 displays, with the link in bold; right-click on it and choose "Copy link"
     5) Return to your discussion on CCM, and in your message, press "Paste".
    =>See the guide https://www.commentcamarche.net/faq/29493-utiliser-cjoint-pour-heberger-des-fichiers

    --
    Retirement is great! Especially in the West Indies... :-)
    Raymond (INSA, AFPA, CF/R)
    -1