Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Old October 20th 06, 05:14 PM posted to microsoft.public.excel.misc
external usenet poster
 
First recorded activity by ExcelBanter: Oct 2006
Posts: 1
Default 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   Report Post  
Old October 20th 06, 05:30 PM posted to microsoft.public.excel.misc
external usenet poster
 
First recorded activity by ExcelBanter: Sep 2006
Posts: 1,311
Default 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   Report Post  
Old October 20th 06, 11:45 PM posted to microsoft.public.excel.misc
external usenet poster
 
First recorded activity by ExcelBanter: Jul 2006
Posts: 22,908
Default 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
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Conditional Format as a MACRO Gunjani Excel Worksheet Functions 3 March 29th 06 05:22 PM
Positioning Numeric Values Resulting from 6 Column Array Formula Sam via OfficeKB.com Excel Worksheet Functions 2 January 5th 06 02:03 AM
Divide Column A by Column B multiply Column C Stumped Excel Worksheet Functions 3 December 28th 05 05:51 AM
Running total w/2 columns - Excel Anna / Ideal Excel Worksheet Functions 14 August 10th 05 04:28 PM
Return Count for LAST NonBlank Cell in each Row Sam via OfficeKB.com Excel Worksheet Functions 12 April 17th 05 10:36 PM


All times are GMT +1. The time now is 07:56 AM.

Powered by vBulletin® Copyright ©2000 - 2019, Jelsoft Enterprises Ltd.
Copyright 2004-2019 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"

 

Copyright © 2017