ابدأ بالتواصل مع الأشخاص وتبادل معارفك المهنية

أنشئ حسابًا أو سجّل الدخول للانضمام إلى مجتمعك المهني.

متابعة

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

user-image
تم إضافة السؤال من قبل Hossam Ahmed , مساعد مدير الموارد البشرية والشئون الإدارية HR Specialist , JPF - Jeddah Paints Factory
تاريخ النشر: 2017/05/10
Firas Shahadi
من قبل 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

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

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

md saood manzar
من قبل 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
من قبل 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

المزيد من الأسئلة المماثلة

هل تحتاج لمساعدة في كتابة سيرة ذاتية تحتوي على الكلمات الدلالية التي يبحث عنها أصحاب العمل؟