Home |
Search |
Today's Posts |
|
#1
![]() |
|||
|
|||
![]()
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 |
#2
![]() |
|||
|
|||
![]()
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. "ruffles the cat" wrote: 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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Lookup Table Dilemma | Excel Worksheet Functions | |||
Excel should provide an easy way to switch a column into a row, n. | Excel Discussion (Misc queries) | |||
How do i copy columns of data in notepad into microsoft excel? | Excel Discussion (Misc queries) | |||
How do i copy columns of data in notepad into microsoft excel? | Excel Discussion (Misc queries) | |||
Columns in Excel will not allow user to click in them | Excel Discussion (Misc queries) |