But after a while, you must start using excel shortcut keys Using Excel Shortcut Keys An Excel shortcut is a technique of performing a manual task in a quicker way. #2 – Using Shortcut Key (ALT + H + M + C) Do the same thing for one more category as well.Now, press the “F4” key to repeat the previous action of “ Merge & Center.”.After merging first category cells, next, we must select second category cells.Instead, we can use the “F4” function key.

Once the “Merge & Center” formatting is applied for the first category cell for the other two, we need not use the “Merge & Center” formatting option again. Similarly, we have the other two categories to merge, so repeat the same action for the other two. The “ Merge & Center” option is highlighted, which means the active cell is applied with a merge option.Consequently, it will instantly merge the selected cell and make the alignment as “ Center.”.Under the “ HOME” tab, we have an option called “ Merge & Center in Excel,” so click on this option.In this case, we need to merge the “ Furniture” category to B1 and C1 cells, so select B1 and C1 cells. Before we merge, we must first select the value cell for the cells we need to merge.

Microsoft excel shortcut keys 2007 pdf