Log in  \/ 
x
or
x
x
Register  \/ 
x

or

Kutools for Excel 22.00 HOT

300+ Powerful Features You Must Have in Excel

Kutools-for-Excel

Kutools for Excel is a powerful add-in that frees you from performing time-consuming operations in Excel, such as combine sheets quickly, merge cells without losing data, paste to only visible cells, count cells by color and so on. 300+ powerful features / functions for Excel 2019, 2016, 2013, 2010, 2007 or Office 365!

Read More Download Buy now

Office Tab 14.00HOT

Adding Tabbed Interface for Office

Office Tab

It enables tabbed browsing, editing, and managing of Microsoft Office applications. You can open multiple documents / files in a single tabbed window, such as using the browser IE 8/9/10, Firefox, and Google Chrome. It's compatible with Office 2019, 2016, 2013, 2010, 2007, 2003 or Office 365. Demo

Read More Download Buy now

Kutools for Outlook 13.00NEW

100+ Powerful Features for Outlook

Kutools-for-Outlook

Kutools for Outlook is a powerful add-in that frees you from time-consuming operations which majority of Outlook users has to perform daily! It can save your time from using Microsoft Outlook 2019, 2016, 2013, 2010 or Office 365!

Read More Download Buy now

Kutools for Word  9.00NEW

100+ Powerful Features for Word

Kutools-for-Word

Kutools for Word is a powerful add-in that frees you from time-consuming operations which majority of Word users have to perform daily! It can save your time from using Microsoft Word / Office 2019, 2016, 2013, 2010, 2007, 2003 or Office 365!

Read More Download Buy now

Classic Menu for Office

Bringing Back Your Familiar Menus

Restores the old look and menus of Office 2003 to Microsoft Office 2019, 2016, 2013, 2010, 2007 or Office 365. Don’t lose time in finding commands on the new Ribbon. Easy to deploy to all computers in enterprises and organizations.

Read More Download Buy now

How to merge cells in a range formatted as table in Excel?

In Excel, you can easily merge some consecutive cells into one with the Merge & Center utility as below screenshot shown. However, it cannot merge the cells in a range which formatted as a table in Excel, is there any trick to handle it?
doc merge cells in table 1

Merge cells in a table

Merge same cells with Kutools for Excelgood idea3


arrow blue right bubble Merge cells in a table

In Excel, there is no way that can merge cells in a table, but here I introduce a roundabout trick for you to merge cells in a table.

Select the table, the go to the Design tab, click Convert to Range, and then click Yes in the popping dialog to convert the table to a range which also looks like a table. See screenshot:

doc merge cells in table 2
doc merge cells in table 3

 

Then select the cells you want to merge, click Home > Merge & Center, and click OK in the popping out warning dialog. See screenshot:

doc merge cells in table 4
doc merge cells in table 5

 

arrow blue right bubble Merge same cells with Kutools for Excel

If you want to merge same cells in a range or unmerge cells in a range, you can apply Kutools for Excel’s Merge Same Cells or Unmerge Cell.

Kutools for Excel, with more than 300 handy functions, makes your jobs easier. 
Say something here...
symbols left.
You are guest
or post as a guest, but your post won't be published automatically.
Loading comment... The comment will be refreshed after 00:00.
  • To post as a guest, your comment is unpublished.
    marco · 1 years ago
    Hi, I need combine Hello, I need to combine a range of two columns, but row by line, is there a formula or procedure to do it without having to go over it by line?
    • To post as a guest, your comment is unpublished.
      Sunny · 7 months ago
      Hi, macro, do you want to column two columns as below screenshot shown? If so, you can use the formula =D1&E1, D1 and E1 is the cells in two column you want to combine, if not, please upload the file to display your desired result.
  • To post as a guest, your comment is unpublished.
    Vero · 2 years ago
    Great help! I was able to merge once I converted to range, best regards!
  • To post as a guest, your comment is unpublished.
    Sai Mounika · 2 years ago
    Hi i have tried Merge Same Cells With Kutools For Excel by downloading Kutools For Excel. But When I select two cells and click Kutools > Range > Merge Same Cells or Unmerge Cell, Its displaying a popup that ' This fuction can not be proceeded since: * The selection has table. Could you please help me how to overcome this
    • To post as a guest, your comment is unpublished.
      Sunny · 2 years ago
      Hi, thank u for your message, I am sorry to tell you that the Merge Same Cells and Unmerge Cell utilities cannot apply in table, you can right click at the table, then click Table > Convert to range in the context menu to convert the table to range cells first, then apply the Merge Same Cells or Unmerge Cell utilties. Or you can copy the table and paste as value, then apply the utilities. Wish it is helpful.

Feature Tutorials

 
Copyright © 2009 - ExtendOffice.com | All Rights Reserved. Sitemap
Microsoft and the Office logo are trademarks or registered trademarks of Microsoft Corporation in the United States and/or other countries.
Protected by Sectigo SSL