How do I turn 1 cell into 2 cells without adding columns or rows?

S

Shawna

Is it possible to divide a cell into more than one cell without adding rows
or columns to the worksheet? I need to be able to apply borders to the new
cells created.
 
D

Dave

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Split one cell into 4 cells without adding columns? 2
How to filter rows data based on background color of individual cells 1
Combine multiple cells (3) adding a Colon (:) 4
Adding Rows or Columns disorders my micro 14
Dividing Worksheet into Two Columns 2
Merging multiple columns into one column (dynamically) 1
VBA - retrieve data on last create named range from previous inserted named range 0
How to covert rows to columns or columns to rows. 11

Top