Communiquez avec les autres et partagez vos connaissances professionnelles

Inscrivez-vous ou connectez-vous pour rejoindre votre communauté professionnelle.

Suivre

What shortcut for marge more than one cell in Microsoft Excel?

user-image
Question ajoutée par Hossam Ahmed , مساعد مدير الموارد البشرية والشئون الإدارية HR Specialist , JPF - Jeddah Paints Factory
Date de publication: 2017/05/10
Firas Shahadi
par Firas Shahadi , Training And Development Director , Muhayal Assir National Hospital

Thank you for your question.

Here is the fastest way you can use. Use the below shortcut

Alt+H+M+C

to Unmerge use the same shortcut.

 

Regards

اسماعيل ابوطه
par اسماعيل ابوطه , عامل انتاج , شركة صناعات الاغذية العربية نون

This image is a shortcut to the merge tool that merges more than one cell

md saood manzar
par md saood manzar , Lab Researcher Air Pollution Lab , university of dammam

 

Merging cartels two or more cells to generate a new, larger cell. This is a prodigious way to create a label that spans numerous columns.

 

1. Select two or more adjacent cells that you want to merge.

2. On the HOME tab, JUST select Merge & Center.

 

 

 

 

 

If  "Merge & Center" is dimmed, make sure that you’re not editing a cell and the cells you want to merge aren’t formatted as an Excel table. Cells formatted as a table usually have alternating shaded rows and filters on the column headings.

To merge cells without centering, click the arrow next to Merge and Center, and then click Merge Across or Merge Cells.

 

 

 

 

 

 

 

Hossam Elewa
par Hossam Elewa , CEO Office Manager/Executive Assistant , Leha Group

Excel allows you to merge cells together in two ways: using the Merge and Center tool on the ribbon or toolbar, or by using the controls in the Alignment tab of the Format Cells dialog box. If you merge cells quite a bit, you might long for a shortcut that will merge whatever cells you've selected.

Unfortunately, Excel doesn't include such a shortcut. You can, however, create one using a macro. The following is a simple macro to merge whatever cells you've selected:

Sub MergeCells1() Selection.Merge End Sub

After you create the macro, you can assign it to a keyboard shortcut and you are set to go. If you instead want a macro that is a shortcut for the Merge and Center tool, then you can use the following:

Sub MergeCells2() With Selection .HorizontalAlignment = xlCenter .Merge End With End Sub

More Questions Like This

Avez-vous besoin d'aide pour créer un CV ayant les mots-clés recherchés par les employeurs?