Center Text Between Multiple Cells

May 05, 2014

0 comments

center   center text   Excel on Mac   Excel Resources   Excel Shortcuts for Mac   Excel Skin   merge   merge cells  



We’re a team of problem solvers, world travelers, idea guys, and doers, working to make using Excel on a Mac a better experience.

That’s enough about us -- whether you are new to Excel for Mac or an experienced user, you probably want to spend less time manipulating data and more time thinking. The Excel Skin will help you do that. If you are a PC user hesitant about switching to Mac because you don’t want to give up your customized menus and shortcuts, well, the Excel Skin just might be the myth-buster you need. Excel for Mac is just as capable as it is for the PC. And with the Excel Skin, you’ll relearn your old shortcuts in no time.

The Excel Skin makes it easy to be as proficient and efficient in Excel for Mac as on any other platform. Powerful shortcuts are presented intuitively on an elegant silicone keyboard skin. Shortcut and modifier keys are printed by color and heat fused onto our high quality silicone to ensure durability.

The Excel Skin a small product that will make a big difference in your life.

 

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.