Shortcut Key for Merging Cells

C

Chelle19

Hi All -

In my everyday work life I often have to build plans in an excel sheet and I
need to merge or unmerge cells. Is there a shortcut key to merge and unmerge
cells without having to go to format cell and select the align tab, and then
click or unclick the merge option?

Thanks!
 
G

Glenn

Chelle19 said:
Hi All -

In my everyday work life I often have to build plans in an excel sheet and I
need to merge or unmerge cells. Is there a shortcut key to merge and unmerge
cells without having to go to format cell and select the align tab, and then
click or unclick the merge option?

Thanks!
Click to expand...

You could also just click the "Merge and Center" button on the Formatting toolbar.
 
R

ryguy7272

Be careful of merging cells. It's not common to see this in practice. I
almost never do this. I'd certainly never do it for people who are not very
Excel savvy because it causes many more problems than it fixes.

HTH,
Ryan--
 
A

Ashish Mathur

Hi,

Instead of merging cells across columns, use Format > cells > Alignment >
Horizontal > Centre across selection

--
Regards,

Ashish Mathur
Microsoft Excel MVP
www.ashishmathur.com
 

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

Merging from an Excel file with graphics 1
VBA: Programmatically clear a one-key shortcut bound to a document 2
VBA for Dependents shortcut menu 0
Cannot copy the merge cells 4
Word macro that can call cells out of Excel for a find and replace 0
Sorting with merged cells in the worksheet 1
Merging cells in a Protected Sheet 3
Cannot Change Back to Previous Settings After Clicking "Try the new Outlook" 0

Top