Excel: Find peace with merged cells and calculations–two natural enemies — Business Management Daily: Free Reports on Human Resources, Employment Law, Office Management, Office Communication, Office Technology and Small Business Tax Business Management Daily

Excel: Find peace with merged cells and calculations–two natural enemies

by on
in Excel Training,Office Technology

There is a way to get the look of Merge and Center without the inconvenience.

Select the cell containing the text you want centered and the adjacent cells across that you want centered. Using Ctrl+1 to access the Format Cells dialog box, click on the Alignment tab. You can also click on the dialog box launcher in lower right corner of the Alignment group on the Home tab. Click the dropdown arrow in the Horizontal field at the top and select Center Across Selection.

{ 1 comment… read it below or add one }

Terry Thomas February 21, 2012 at 6:34 pm

Need to learn all that I can with Excel.

Reply

Leave a Comment