

It includes Classic Menu for Word, Excel, PowerPoint, OneNote, Outlook, Publisher, Access, InfoPath, Visio and Project 2010, 2013, 2016, 2019 and 365. One other option available to you is to use the CONCATENATE function.

You can then click the arrow to the right of the Merge & Center button and choose the Merge Across option. Supports all languages, and all new commands of 2007, 2010, 2013, 2016, 2019 and 365 have been added into the classic interface. If you want to merge columns in Excel 2010 then you can click and drag to select the column letters that you wish to merge. You can use Office 2007/2010/2013/2016 immediately without any training.

Then you will view the Merge and Center button there.įigure 2: Merge & Center button in Microsoft Excel Ribbon.The following figure may offer your vivid help:įigure 1: Merge & Center button in classic toolbarįind out Merge and Center button in Ribbon if you do not have Classic Menu for OfficeĪlthough there is no toolbar any longer, you can also find out the Merge and Center button in Microsoft Excel 2007/2010/2013/2016/2019 Ribbon: So follow your use habit adopted in Excel 2003 to easily seek for the Merge and Center button quickly in the toolbar. If you have installed Classic Menu for Office on your computer, you will find the same toolbar under Menus tab as that in Microsoft Excel 2003. Classic Menu for Office Home and Businessįamiliar way to find out Merge and Center button if you have Classic Menu for Office.Classic Menu for Office 2007 Applications.
