Knowledge is power - if you don't know what's available you can miss an opportunity or spend hours trying to jury-rig a solution by cobbling together other functions. You can relieve yourself lots of timeyou don’t need to combine them by hand.

Now you know how to combine columns in Excel. For more than information on this, read our article on how to merge and unmerge cells in Excel. You can't add these to any favourites list but you can make your own 'Check these out' list Merge & Center button (or use the dropdown arrow next to it). Similarly, open the Function Wizard window and check out the functions available (made easier bc you can do so by category). Split text from one cell into multiple cells.

If you need to reverse a cell merge, click onto the merged cell and then choose Unmerge Cells item in the Merge & Center menu (see the figure above). If so, add it to your QAT and try it out.Ģ. To merge cells without centering, click the arrow next to Merge and Center, and then click Merge Across or Merge Cells. open the Customize Quick Access Toolbar window and just scroll through the list of commands available (Note: some are only available thru customisation as they are not on the inbuilt menu!) and see what each tool does and whether it may be useful to you. I'm from the same era: Learned 123 in 1984/85 from a 5.25' floppy tutorial, & Multiplan, then progressed thru Symphony, Supercalc, back to 123, and then Excel 4 & 5 in 1995 - and have never looked back! That's the beauty and ugliness of Excel - there are more tools & features than you can ever learn or know about!

What is merge and center in excel