View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Dave Dave is offline
external usenet poster
 
Posts: 1,388
Default How do I turn 1 cell into 2 cells without adding columns or rows?

Hi,
Sorry, you can't split basic cells in Excel.
You can add a diagonal line in Format Cells Borders, which is the
closest you'll get.
The other approach is to merge all cells across 2 columns, then un-merge
just the ones you want to "split." But merging can create other problems when
trying to manipulate data and layout.
Regards - Dave.