why is Merge cells mot working???

[yomero]

This is weird. The Merge functionality is not working, the Button is grayed down.

The sheet/workbook are not protected, nor shared, there is no VBA code in the file...

Does anyone knows what else can it be? Everything else is working fine!!!

thanks

 

[VoG]

Merged cells are a bad idea anyway. Have you tried Format > Cells > Alignment tab > Center across selection?

 

[rob.barnes01]

@VoG,

Would you mind elaborating a bit on the benefits of Center Across Selection vs. merging cells?

Thanks!
Rob

 

[lenze]

http://www.officearticles.com/excel/merged_cells_in_microsoft_excel.htm

lenze

 

[yomero]

Thx guys.
As I always say "Mege cells are Excel's worse enemy"
however for this particulary case, i need to, and I am unable to.

I appreciate any potentioal solution

Jacob