How do I divide a column into two?

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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...
 
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
 
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 Format>Cells>Alignment>Horizontal>Center Acros Selection.


Gord Dibben MS Excel MVP
 
You must log in or register to reply here.

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

Dividing Worksheet into Two Columns 2
Dividing a column 3
dividing a number into hours and minutes 1
How do I divide a cell into two diagonally? 2
Dividing existing content into two cells 2
How do I combine these columns into one? 2
how do i split a cell into 2 under a heading 2
Dividing a school-class into (almost) equally sized groups 3

Back
Top