How do I split a cell in Excel into two or more where they are divided horizontally

0 votes

How do I split a cell in Excel into two or more where they are divided horizontally. Please see the screenshot below:

You'll notice that row number 2 (cat/parrot) is divided. I'm not sure how to replicate this. I tried CMD + ALT + Enter which split the text on two lines, but that is not the effect I'm looking for. In the screenshot example the cat and parrot are selectable like they are in their own cells.

thanks for any help enter image description here

Apr 5 in Database by Edureka
• 9,320 points
23 views

1 answer to this question.

0 votes

Table cells should be combined.
To make a single cell out of two or more table cells in the same row or column, perform the following:

Select the cells you want to combine on the slide.

It is not feasible to choose numerous cells that are not adjacent.

Merge Cells may be found under Table Tools, on the Layout tab, under the Merge group.

Merge or Split table cells

Table cells can be split into two groups.
Do the following to divide a table cell into more cells:

To split a table cell, right-click it.

Click Split Cells under Table Tools, on the Layout tab, under the Merge group, and then do one or more of the following:

Merge or Split table cells

To divide a cell vertically, type the desired number of new cells in the Number of columns box.

Enter the desired number of new cells in the Number of rows box to divide a cell horizontally.

To divide a cell horizontally and vertically, enter the desired number of new columns in the Number of columns box, and then the desired number of new rows in the Number of rows box.

answered Apr 6 by Edureka
• 8,820 points

Related Questions In Database

0 votes
0 answers

How do I merge two rows in Excel?

Hi I'm not even sure if this ...READ MORE

Apr 4 in Database by Edureka
• 8,820 points
9 views
0 votes
0 answers

How do I merge two rows in Excel?

Hi I'm not even sure if this ...READ MORE

Apr 7 in Database by Edureka
• 9,320 points
12 views
0 votes
1 answer

How do I reset a sequence in Oracle?

 If you want to set it to ...READ MORE

answered Sep 27, 2019 in Database by Omaiz
• 560 points
303 views
0 votes
1 answer

How do I UPDATE from a SELECT in SQL Server?

MERGE INTO YourTable T USING ...READ MORE

answered Feb 3 in Database by Vaani
• 5,040 points
34 views
0 votes
1 answer

Retrieve epay.info Balance with VBA and Excel

This code should log you in, provided ...READ MORE

answered Sep 5, 2018 in Blockchain by digger
• 26,720 points
321 views
0 votes
1 answer

ImportError: openpyxl is required for loading excel format files

Forget the PsychoPy complications for the time ...READ MORE

answered Oct 3, 2018 in Python by Priyaj
• 58,060 points
288 views
0 votes
1 answer

In Blue Prism how to split excel column data into TWO columns

This is how I am doing it. Dim ...READ MORE

answered Oct 15, 2018 in RPA by Priyaj
• 58,060 points
3,124 views
0 votes
1 answer

Excel Power Query: Using List.MatchAny on a column value

try this. let TableA = ...READ MORE

answered Oct 22, 2018 in Power BI by Annie97
• 2,160 points
2,513 views
0 votes
1 answer

How do I display a ratio in Excel in the format A:B?

Try this formula: =SUBSTITUTE(TEXT(A1/B1,"?/?"),"/",":") Result: A B ...READ MORE

answered Apr 1 in Database by Edureka
• 8,820 points
23 views
0 votes
1 answer
webinar REGISTER FOR FREE WEBINAR X
Send OTP
REGISTER NOW
webinar_success Thank you for registering Join Edureka Meetup community for 100+ Free Webinars each month JOIN MEETUP GROUP