Have you ever wondered how to merge and center text in between two or more cells with a quick shortcut? Unfortunately this shortcut doesn't exist, but in a few quick clicks you can have your text centered wherever you like. This tip for Microsoft Excel on Mac can be useful in sprucing up your spreadsheet and giving it a more refined look.
The trick is to make it look like the cells have merged together, but not actually merge them. Merging the cells together can inhibit specific Excel functions.
Step 1: Select the cells you wish to have the text centered in
Step 2: Click the Format menu on the toolbar
Step 3: Click Format Cells under the Format Menu. This will open a dialog box
Step 4: In the dialog box click the Alignment Tab (2nd Tab). In the Alignment Tab select the following options: Horizontal - Center Across Selection.
Step 5: Click OK. Your text will now be centered in the selected cells.
Leave a comment
Comments will be approved before showing up.