View Single Post
  #7   Report Post  
Posted to microsoft.public.excel.misc
David Biddulph David Biddulph is offline
external usenet poster
 
Posts: 620
Default Excel Spliting Cells

When you are so convinced that you've done nothing wrong, I am surprised
that you are asking advice from experts like Gord.

If you want to receive useful responses, then you would do better by using
the right words to describe what you've done. If you look at the link
you've quoted, it doesn't talk about splitting cells, it talks about
splitting panes. In that situation you have two panes which can (depending
on where you scroll the panes) both include the same cells, so that is why
you are seeing two views of what you are changing. If you look at the row
and column headers in the two (or four) panes, then you can see which cells
are visible in which pane, and which cells are selected.

As far as the other option, Freezing Panes, is concerned, then if you want
to freeze the top four rows, select the fifth row before you Freeze Panes.
--
David Biddulph

"Cassidy" wrote in message
...
No. I am not doing anything wrong heres the link. to what I did...and when
i
do that and i type in one say the top section it writes it in the cesond
section..If I write in row one in the first section it writes it in row
one
in the seocnd section and i dont want that
http://office.microsoft.com/en-ca/ex...033#SplitPanes

and yea and the first part the freezing cells it only lets me freeze the
top
row how come i can't free the third or forth row???


"Gord Dibben" wrote:

Cells cannot be "split" so you must be doing something else that makes
them look
split.

When you find out what that is, you should be able to sort out your
problem.

Perhaps you have a border around two cells and across the middle of the
cells
that make it look one split cell?


Gord Dibben MS Excel MVP


On Thu, 11 Jan 2007 17:21:00 -0800, Cassidy

wrote:

NO i didnt work,..do you understand what i mean it rights in both top
split
and bottom split but i dont want that. Do you have msn

"CLR" wrote:

Probably the cells are "merged". They can be un-merged by selecting
them,
then doing Right-click formatCells AlignmentTab ....uncheck the
MergeCells box......

Vaya con Dios,
Chuck, CABGx3



"Cassidy" wrote in message
...
I need help. I sp;lit te cells and I need to know how to conly write
in
one f
them because when i write in one it write in the toehr one does
anyone
know
know what i mean