ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   How do I split a cell into multiple rows/columns? (https://www.excelbanter.com/excel-discussion-misc-queries/65689-how-do-i-split-cell-into-multiple-rows-columns.html)

SKA

How do I split a cell into multiple rows/columns?
 
In MS Word, one can use the "split cell" function to insert multiple rows
and/or columns into a single cell. I would like to do the same, but in
Excel. In this case, it is simply text that I am dealing with, no fancy
formulas or such.

So in one cell, I want the top part to span the width of the cell and say
"The Big Idea", and then immediately beneath that, have 3 columns that are
"children" of "The Big Idea" that say "Good", "Bad" and "Ugly".
I know I could do this using different Excel rows entirely and using the
"merge cell" function, but this does not look the same.

Help?

Ken Johnson

How do I split a cell into multiple rows/columns?
 
Hi SKA,
the only other option is type "The Big Idea" in the top leftmost cell
of the table, then click and drag so that the next two cells to the
right are also selected, then FormatCellsAlignmentselect Center
Across Selection in the Horizontal drop down list.
Also, maybe appropriate adjustment of cell borders will help you
achieve the desired result.
Ken Johnson



All times are GMT +1. The time now is 05:37 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com