Video Merge Cells Or Split Merged Data

Worlds best Ms Office Tutorial content. Find anything about Ms Office Tutorial on this site.

Video Merge Cells Or Split Merged Data. Right click any merged cell and select the Delete from the right-clicking menu. Merge cells or split merged data.

Add A Drop Cap In Word Instructions And Video Lesson Words Lesson Video Lessons
Add A Drop Cap In Word Instructions And Video Lesson Words Lesson Video Lessons from www.pinterest.com

When the two cells are merged only the data contained in the top left one is retained. Click in a cell or select multiple cells that you want to split. Right click any merged cell and select the Delete from the right-clicking menu.

And then select the range again.

Merging cells in Excel is easy. Under Table Tools on the Layout tab in the Merge group click Split Cells. Enter the number of columns or rows that you want to split the selected cells. You can Select all merged cells by selecting one merged cell in the Find and Replace dialog box and then pressing the Ctrl A keys simultaneously.