Don't use Merge Across.
Unmerge the cells. Highlight the range you want it to center on.
Right click it and select Format Cells to bring up the Format cells dialog box.
Click on the alignment tab. Under Horizontal, use the drop-down to select Center Across Selection.
Bookmarks