|Join Nairaland / Login / Trending / Recent / New|
Stats: 1216505 members, 1596220 topics. Date: Monday, 10 March 2014 at 12:35 AM
|Splitting A Cell In Excel 2007 by STOjo(m): 8:21am On Oct 13, 2011|
I am trying to SPLIT A CELL into 2 in excel 2007. I have gone to help online but the issue is I could not find TABLE LAYOUT. I am sure you will help me out.
|Re: Splitting A Cell In Excel 2007 by Maleeq(m): 10:11am On Oct 13, 2011|
You cannot split an empty, unmerged cell. You can only split a cell that was previously merged. However, you can split the contents of an unmerged cell and distribute the divided contents across other cells.
Clarify your needs better. I only have a vague idea of what I think you need: Something like a header column with two sub-cell beneath it? If yes, then what you need to do is merge the topmost cells as one. See the attached sample.xls file if it offers what you need.
|Re: Splitting A Cell In Excel 2007 by STOjo(m): 11:14am On Oct 13, 2011|
Thank you @Maleeq, I raised two questions.
1. I did not see TABLE LAYOUT on my toolbar that made it impossible for me to
2. get to SPLIT A SINGLE CELL- I want to have 2 colors in a cell with content (NO MERGING).
Thanks & regards.
|Re: Splitting A Cell In Excel 2007 by Maleeq(m): 11:35am On Oct 13, 2011|
#1. The "Table Layout" simply does not exist in excel. Excel, as-is, is a table already whose layout cannot be altered.
#2. Its not possible to achieve that in excel without a merge.
|Sections: politics (1) business autos (1) jobs (1) career education (1) romance computers phones travel sports fashion health |
religion celebs tv-movies music-radio literature webmasters programming techmarket
Nairaland - Copyright © 2005 - 2014 Oluwaseun Osewa. All rights reserved. See Nairalist and How To Advertise