Center across selection

January 27, 2009 | By David In Excel, format, hints |

This is my preferred method of showing text across a selection of cells. Use this instead of merging cells. Merging cells can play havoc with some other excel functions.
My theory about why “Center across selection” is not widely used is the placement in the dialog box.

Format Dialog box showing center across selection

Format Dialog

You see it is at the bottom of the list.
This option will center the text across a selection of cells without merging any cells

Other Related Posts:

No Comments

Leave a reply

You must be logged in to post a comment.