![]() ![]() ![]() Press the ALT key to highlight the short cut alphabets for each ribbon.There is no default shortcut key to “Merge & Center,” but let’s discover it now. Manual methods are to start the things off, but after a while, you must start using excel shortcut keys to work efficiently. #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 select second category cells.Instead, we can simply use the F4 function key. Once the “Merge & Center” formatting 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. As you can see now “ Merge & Center” option is highlighted, which means the active cell is applied with a merge option.This 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.In this case, we need to merge the “ Furniture” category to B1 & C1 cells, so select B1 & C1 cells. Before we merge, we need to first select the value cell for cells we need to merge.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |