Microsoft Office Excel的一大功能就是可以合并或拆分表格内的单元格。使用Excel时可以用工具来分离图表或电子表格中两个或以上的单元格数据。要拆分单元格,或分离数据,必须先合并单元格。按照以下步骤,来拆分单元格,或者分离单元格内数据到多个单元格内。
步骤
方法 1 的 2:
拆分一个单元格
-
{"smallUrl":"https:\/\/www.zenmeban.com\/images_en\/thumb\/b\/b2\/Unmerge-Cells-in-Excel-Step-1-Version-2.jpg\/v4-460px-Unmerge-Cells-in-Excel-Step-1-Version-2.jpg","bigUrl":"https:\/\/www.zenmeban.com\/images\/thumb\/b\/b2\/Unmerge-Cells-in-Excel-Step-1-Version-2.jpg\/v4-728px-Unmerge-Cells-in-Excel-Step-1-Version-2.jpg","smallWidth":460,"smallHeight":345,"bigWidth":728,"bigHeight":546,"licensing":"<div class=\"mw-parser-output\"><\/div>"}
1
点击选择要拆分的单元格。
-
{"smallUrl":"https:\/\/www.zenmeban.com\/images_en\/thumb\/7\/7e\/Unmerge-Cells-in-Excel-Step-2-Version-2.jpg\/v4-460px-Unmerge-Cells-in-Excel-Step-2-Version-2.jpg","bigUrl":"https:\/\/www.zenmeban.com\/images\/thumb\/7\/7e\/Unmerge-Cells-in-Excel-Step-2-Version-2.jpg\/v4-728px-Unmerge-Cells-in-Excel-Step-2-Version-2.jpg","smallWidth":460,"smallHeight":345,"bigWidth":728,"bigHeight":546,"licensing":"<div class=\"mw-parser-output\"><\/div>"}
2
在格式标签中找到合并并居中按钮。
-
{"smallUrl":"https:\/\/www.zenmeban.com\/images_en\/thumb\/0\/02\/Unmerge-Cells-in-Excel-Step-3-Version-2.jpg\/v4-460px-Unmerge-Cells-in-Excel-Step-3-Version-2.jpg","bigUrl":"https:\/\/www.zenmeban.com\/images\/thumb\/0\/02\/Unmerge-Cells-in-Excel-Step-3-Version-2.jpg\/v4-728px-Unmerge-Cells-in-Excel-Step-3-Version-2.jpg","smallWidth":460,"smallHeight":345,"bigWidth":728,"bigHeight":546,"licensing":"<div class=\"mw-parser-output\"><\/div>"}
3
点击合并并居中按钮,选择分离或拆分单元格。
方法 2 的 2:
把一个单元格内的多个数据分离到多个单元格内
-
{"smallUrl":"https:\/\/www.zenmeban.com\/images_en\/thumb\/0\/02\/Unmerge-Cells-in-Excel-Step-4-Version-2.jpg\/v4-460px-Unmerge-Cells-in-Excel-Step-4-Version-2.jpg","bigUrl":"https:\/\/www.zenmeban.com\/images\/thumb\/0\/02\/Unmerge-Cells-in-Excel-Step-4-Version-2.jpg\/v4-728px-Unmerge-Cells-in-Excel-Step-4-Version-2.jpg","smallWidth":460,"smallHeight":345,"bigWidth":728,"bigHeight":546,"licensing":"<div class=\"mw-parser-output\"><\/div>"}
1
选中要分离的这个文字数据。可以选中多个单元格、单元格范围或一条单元格。
- 不能选择宽于一列的数据。不过可以选择多行。
- 任何选中表格右侧的单元格(如有数据)都会被覆盖。
-
{"smallUrl":"https:\/\/www.zenmeban.com\/images_en\/thumb\/9\/9d\/Unmerge-Cells-in-Excel-Step-5-Version-2.jpg\/v4-460px-Unmerge-Cells-in-Excel-Step-5-Version-2.jpg","bigUrl":"https:\/\/www.zenmeban.com\/images\/thumb\/9\/9d\/Unmerge-Cells-in-Excel-Step-5-Version-2.jpg\/v4-728px-Unmerge-Cells-in-Excel-Step-5-Version-2.jpg","smallWidth":460,"smallHeight":345,"bigWidth":728,"bigHeight":546,"licensing":"<div class=\"mw-parser-output\"><\/div>"}
2
找到上端的数据标签。在里面找到分列(Text to Columns)按钮,来分离数据。
-
{"smallUrl":"https:\/\/www.zenmeban.com\/images_en\/thumb\/e\/eb\/Unmerge-Cells-in-Excel-Step-6-Version-2.jpg\/v4-460px-Unmerge-Cells-in-Excel-Step-6-Version-2.jpg","bigUrl":"https:\/\/www.zenmeban.com\/images\/thumb\/e\/eb\/Unmerge-Cells-in-Excel-Step-6-Version-2.jpg\/v4-728px-Unmerge-Cells-in-Excel-Step-6-Version-2.jpg","smallWidth":460,"smallHeight":345,"bigWidth":728,"bigHeight":546,"licensing":"<div class=\"mw-parser-output\"><\/div>"}
3选中单元格、一个范围或者一列数据
-
{"smallUrl":"https:\/\/www.zenmeban.com\/images_en\/thumb\/2\/25\/Unmerge-Cells-in-Excel-Step-7-Version-2.jpg\/v4-460px-Unmerge-Cells-in-Excel-Step-7-Version-2.jpg","bigUrl":"https:\/\/www.zenmeban.com\/images\/thumb\/2\/25\/Unmerge-Cells-in-Excel-Step-7-Version-2.jpg\/v4-728px-Unmerge-Cells-in-Excel-Step-7-Version-2.jpg","smallWidth":460,"smallHeight":345,"bigWidth":728,"bigHeight":546,"licensing":"<div class=\"mw-parser-output\"><\/div>"}
4
打开分列向导框。这时一个新窗口跳出,点击原数据形式,可以是“等宽样式”或“分隔符固定”两种类型。
- “等宽”表示的是通过每个空格分隔数据。
- “分隔符”表示通过任何特殊符号来分隔数据。
-
{"smallUrl":"https:\/\/www.zenmeban.com\/images_en\/thumb\/f\/f1\/Unmerge-Cells-in-Excel-Step-8.jpg\/v4-460px-Unmerge-Cells-in-Excel-Step-8.jpg","bigUrl":"https:\/\/www.zenmeban.com\/images\/thumb\/f\/f1\/Unmerge-Cells-in-Excel-Step-8.jpg\/v4-728px-Unmerge-Cells-in-Excel-Step-8.jpg","smallWidth":460,"smallHeight":345,"bigWidth":728,"bigHeight":546,"licensing":"<div class=\"mw-parser-output\"><\/div>"}
5
点击下一步,更改进阶设置。
- 若选择分隔符,则可以使用空格、逗号、分号或tab符号等等作为分隔符。
- 若选择等宽形式,则按照向导选择分栏符,可以移动或者删除分栏符。
-
{"smallUrl":"https:\/\/www.zenmeban.com\/images_en\/thumb\/2\/2d\/Unmerge-Cells-in-Excel-Step-9.jpg\/v4-460px-Unmerge-Cells-in-Excel-Step-9.jpg","bigUrl":"https:\/\/www.zenmeban.com\/images\/thumb\/2\/2d\/Unmerge-Cells-in-Excel-Step-9.jpg\/v4-728px-Unmerge-Cells-in-Excel-Step-9.jpg","smallWidth":460,"smallHeight":345,"bigWidth":728,"bigHeight":546,"licensing":"<div class=\"mw-parser-output\"><\/div>"}
6
点选单元格或整列数据的格式。在分列向导的第三步,选择一种数据形式。可以选择通用、日期或文字形式。文字数据会把数据转为文字符号,日期则转为月/日/年形式,通用则将日期转为日期,数字转为数字,其他信息转为文字信息。
- 在日期格式中,可以确定年月日的排列顺序。
- 无论选择等宽还是分隔符形式,日期格式都适用。
-
{"smallUrl":"https:\/\/www.zenmeban.com\/images_en\/thumb\/0\/0e\/Unmerge-Cells-in-Excel-Step-10-Version-2.jpg\/v4-460px-Unmerge-Cells-in-Excel-Step-10-Version-2.jpg","bigUrl":"https:\/\/www.zenmeban.com\/images\/thumb\/0\/0e\/Unmerge-Cells-in-Excel-Step-10-Version-2.jpg\/v4-728px-Unmerge-Cells-in-Excel-Step-10-Version-2.jpg","smallWidth":460,"smallHeight":345,"bigWidth":728,"bigHeight":546,"licensing":"<div class=\"mw-parser-output\"><\/div>"}
7
然后可以拆分单元格和单元格数据了。