How do I make a column in Excel into two columns for only A3-A8

G

Guest

I need to have a mini spread sheet inside the larger one. So I need to make
Column A into 2 columns at A3-A8 positions. That means that cells A1 and A2
are the same size the A3-A8 cells become two columns. I can split them with
the draw tool by putting in a vertical line, but this doesn't allow correct
alignment and formulas for those cells. HELP AND thank you. excel Microsoft
office 2003 on Windows XP
 
G

Guest

You can't split cells in Excel, however you could merge cells above and
below so that it looks like you have split the cells
IE merge A1 and B1, A2 and B2, A9 and B9 etc.
 

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

How to combine multiple columns into different cells in one column 4
How to search for nearest nonblank cell in previous rows? 8
How do I incorporate 2 columns into 1 column 3
How do I insert a cell without making a column? 1
Repeating a formula across mulitple columns 1
Excel ALERT a duplicate of the match of two cells in two different columns... please 0
creating columns out of two columns in excel 1
Is there a way (Excel 2003) to make a TWO LINE header in a column 6

Top