Option of merging cells unavailable... :(

[joencrystal]

Hello everyone! I'm new here and super excited to have found you! Hopefully someone can help...

I have a shared workbook that won't allow me to merge any of the cells in any of the worksheets... I'm pretty sure it has something to do with being a shared document as the toggle button and option to merge cells under the formatting cells option is unavailable.

I'm just trying to merge several titles to go across the whole worksheet...

Any ideas why?

The merge options works just fine in other Excel docs and I don't have the cell highlighted for editing...? I'm at a loss so any advice anyone can offer would be sincerely appreciated!

Thanks,
Crystal

[JBeaucaire]

Try this:

1) Select the cells in question.
2) Select FORMAT > CELLS > Alignment
3) Select Horizontal > Center across selection

Does that work for you?

[joencrystal]

YAY! IT WORKED! Thank you so very very much

[JBeaucaire]

Great! If that takes care of your need, be sure to EDIT your original post, click Go Advanced and mark the PREFIX box [SOLVED].


(Also, use the blue "scales" icon in our posts to leave Reputation Feedback, it is appreciated)