Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
How do I divide a column into two?
I want to be able to set up a split column under the same header. I'm trying
to keep track of a goals for my girlfriend and I so under the heading of "Monday" I want to be able to place a number value for both of us in seperate cells. Is it possible to do this? Sorry, I'm a rookie... |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
How do I divide a column into two?
If the Header "Monday" was in cell A1, then right-click on column B and
select 'Insert'. Then highlight A1 and B1 together. Select the Merge and Center icon from the toolbar. If you are not familiar with that icon, then right-click your highlighted area, select Format Cells-Alignment tab and check the box for 'Merge Cells'. HTH, Paul "udowado" wrote in message ... I want to be able to set up a split column under the same header. I'm trying to keep track of a goals for my girlfriend and I so under the heading of "Monday" I want to be able to place a number value for both of us in seperate cells. Is it possible to do this? Sorry, I'm a rookie... |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
How do I divide a column into two?
If you do not want to run into problems later on because of the merged cells,
type Monday in A1. Select A1 and B1 then FormatCellsAlignmentHorizontalCenter Acros Selection. Gord Dibben MS Excel MVP On Fri, 20 Oct 2006 12:30:39 -0400, "PCLIVE" wrote: If the Header "Monday" was in cell A1, then right-click on column B and select 'Insert'. Then highlight A1 and B1 together. Select the Merge and Center icon from the toolbar. If you are not familiar with that icon, then right-click your highlighted area, select Format Cells-Alignment tab and check the box for 'Merge Cells'. HTH, Paul "udowado" wrote in message ... I want to be able to set up a split column under the same header. I'm trying to keep track of a goals for my girlfriend and I so under the heading of "Monday" I want to be able to place a number value for both of us in seperate cells. Is it possible to do this? Sorry, I'm a rookie... |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Conditional Format as a MACRO | Excel Worksheet Functions | |||
Positioning Numeric Values Resulting from 6 Column Array Formula | Excel Worksheet Functions | |||
Divide Column A by Column B multiply Column C | Excel Worksheet Functions | |||
Running total w/2 columns - Excel | Excel Worksheet Functions | |||
Return Count for LAST NonBlank Cell in each Row | Excel Worksheet Functions |