Splitting Cells

  • Thread starter Thread starter PAL
  • Start date Start date
P

PAL

I am working on putting together a cheat sheet. I guess you could describe
it as a dashboard. I was wondering if you could combine then split cells. I
would like to go from 3 cells to 2 cells. I don't want to affect the entire
column as I will have a table below that needs the 3 columns.

I know you can do this in a Word table. Is that the best way to do this?

Thanks.
 
You can combine cells. In your case, you'll just need to hilight the cells
you want to combine, then go to Format / Cells. On the alignment tab check
"Merge Cells" at the bottom and then press Ok.

Those cells now have been put together. One note though, merging cells can
have a negative impact when trying to use the data in a merged cell in a
formula.

Hope this helps.
 
Yes, I can do that, but if I want to adjust the width, I must do it for the
entire column and for the individual cell?
 
Yes that is correct. The cell width will be the same as the two original
cells together. Word allows you to adjust the individual cell borders, but
Excel does not (to my knowledge)
 
Row heights and column widths are properties of the entire row and column.

Be careful if you go with the "merged cells".

They cause no end of problems with copying, sorting, filtering, pasting and a
host of others that escape me right now.

They should be avoided if at all possible.

Center Across Selection can be useful in most cases.


Gord Dibben MS Excel MVP
 
Back
Top