![]() ![]() ![]() 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. Archives
December 2022
Categories |