Open the Excel file you would like to edit ... Under the Text alignment section, go to Horizontal heading. Click the drop-down arrow and choose the Center Across Selection option.