Table cell merge grayed out, impossible to use

Polo141 Posted messages 215 Status Membre -  
Raymond PENTIER Posted messages 58546 Registration date   Status Contributeur 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 réponses

Raymond PENTIER Posted messages 58546 Registration date   Status Contributeur Last intervention   17 474
 
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