Merge and Center in Excel

M

Mykee Nodalo

I've been a long time excel user and just recently, I need to merge and
center a lot of selected cells. I do not use the mouse that often, so, is
there a keyboard shortcut for this?
Aside from: Ctrl+1, A, Alt+M, Alt+H+C.
I also don't need a VB code, I can make a VB code for this, but this
question is pure curiousity.
Thanks.
 
M

Marsh

I posted a question about a problem I was having, the problem was caused by
merged cells. Gord Dibben MS Excel MVP sent the following reply:

Welcome to the wonderful world of merged cells which cause no end of
problems and should be banned from existence.

If cells are merged. the row will not autofit even with line-feeds and wrap
text enabled without using VBA. The Alt+Enter key combination was not
working in the vacinity of merged cells. Merged cells can also create other
problems.
Best practice, it was pointed out is to use "Center across selection". You
get the same effect, but not the problems of Merge and Center

marsh
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

merge and center not merging and centering 6
Merge Problems 1
Remove Merge and Center for entire spreadsheet 3
what is the keyboard shortcut key for merge and center cell in ex. 1
Excel Excel macro and passwords 3
center and merge 1
merge and center in Excel not highlighted 1
Tax Form with Merge and Center 7

Top