Vai al contenuto principale

Come unire le celle in un intervallo formattato come tabella in Excel?

In Excel, puoi facilmente unire alcune celle consecutive in una con l'utilità Unisci e centra come mostrato nell'immagine sottostante. Tuttavia, non può unire le celle in un intervallo formattato come una tabella in Excel, c'è qualche trucco per gestirlo?
doc unire le celle nella tabella 1

Unisci celle in una tabella

Unisci le stesse celle con Kutools per Excelbuona idea 3


freccia blu freccia destra Unisci celle in una tabella

In Excel, non è possibile unire celle in una tabella, ma qui presento un trucco circolare per unire celle in una tabella.

Seleziona la tabella, vai al Design scheda, fare clic Converti in intervallo, Quindi fare clic nella finestra di dialogo popping per convertire la tabella in un intervallo che assomiglia anche a una tabella. Vedi screenshot:

doc unire le celle nella tabella 2
doc unire le celle nella tabella 3

 

Quindi seleziona le celle che desideri unire, fai clic su Casa > Unisci e centrae fare clic OK nella finestra di dialogo di avviso che si apre. Vedi screenshot:

doc unire le celle nella tabella 4
doc unire le celle nella tabella 5

 

freccia blu freccia destra Unisci le stesse celle con Kutools per Excel

Se desideri unire le stesse celle in un intervallo o dividere le celle in un intervallo, puoi applicare Kutools for Excel'S Unisci le stesse celle or Separa cella.

Kutools for Excel, con oltre 300 funzioni utili, semplifica il tuo lavoro. 
Comments (7)
No ratings yet. Be the first to rate!
This comment was minimized by the moderator on the site
Thanks, Friend
Your suggestion about the merging table was very helpful.
This comment was minimized by the moderator on the site
graciaas. Me ayudaste un montón
This comment was minimized by the moderator on the site
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?
This comment was minimized by the moderator on the site
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.
This comment was minimized by the moderator on the site
Great help! I was able to merge once I converted to range, best regards!
This comment was minimized by the moderator on the site
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
This comment was minimized by the moderator on the site
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.
There are no comments posted here yet
Please leave your comments in English
Posting as Guest
×
Rate this post:
0   Characters
Suggested Locations