Greyed out Merge option figured out!
I just had this issue and found out that my excel worksheet was set to be shared. Apparently this formating function is not available for shared worksheets. Go to Tools>share workbook...> and uncheck the box "allow changes by more than one user..."
Thats...