Share via

Split Table in Excel

Anonymous
2023-12-17T22:36:30+00:00

I have office 365. Trying to create an excel sheet that has different size columns. I tried to search split table but couldn't find how to do it. It says go to Table Tools Layout > Split Table and I don't have table tools layout. The original form was created in word but I can't even figure out how to convert word to excel.

RANCHO EL DORADO - HOUSE WATCH
Address: RP:
Start Date: 12/5/23 SnowBird:  No Local:
End Date: 12/28/23 Key:  Yes Pets: No Cars: Yes Make/Model:  Silver Toyota Camry and Dark Gray Acura TL
Comments:
**** ENTER TIME BELOW (Ex:  14:20) ****
**** DATES MON TUE WED THR FRI SAT SUN COMMENTS
1 12/4 -12/10 **** **** **** **** **** **** ****
Microsoft 365 and Office | Excel | For home | Windows

Locked Question. This question was migrated from the Microsoft Support Community. You can vote on whether it's helpful, but you can't add comments or replies or follow the question.

0 comments

1 answer

Sort by: Most helpful
Most helpful Newest Oldest
  1. Andreas Killer 144.1K Reputation points Volunteer Moderator
    2023-12-18T07:20:38+00:00

    Split Table doesn't exist in Excel, it's a feature in Word only.

    https://support.microsoft.com/en-au/office/split-a-table-d231a898-6983-4ef8-acb0-797c7f2b0c45

    In Excel you can only merge cells.

    https://support.microsoft.com/en-au/office/merge-and-unmerge-cells-5cbd15d5-9375-4540-907f-c673a93fcedf

    There is no simple way to convert Word tables to Excel, you can try to select the table in Word and copy, switch to Excel and paste. In most cases the layout in Excel looks different and it is up to you to adjust it manually.

    Andreas.

    2 people found this answer helpful.
    0 comments