how to divide row into 2 columns in excel


  1. Posts : 12
    64bit windows 7
       #1

    how to divide row into 2 columns in excel


    I need to create this table in Excel, How do I create table like I attached? How do I divide 2 row into 2 columns. Im using mac 2013 office.
    please help thx
    Attached Thumbnails Attached Thumbnails how to divide row into 2 columns in excel-photo-2-.jpg  
      My Computer


  2. Posts : 12,012
    Windows 7 Home Premium SP1, 64-bit
       #2

    Not sure I follow what you need to do, but....

    highlight a group of cells in a row, such as 3A, 3B, and 3C.

    Then right click and choose "format cells". Then choose the alignment tab. Then choose "merge cells".

    That will combine 3A, 3B, and 3C into a single cell.

    Is that what you are trying to do?

    You can do the same thing with cells in a column--combine them into a single cell.

    You can do that with any combination of cells.

    You can then type in whatever you need into a cell and align that typed text to either the left, right, or center of the merged cells.
      My Computer


  3. Posts : 2,726
    Windows 7 Ultimate 64bit
       #3

    Something like this pal .... (excel file below)
    Attached Thumbnails Attached Thumbnails how to divide row into 2 columns in excel-capture.jpg  
    how to divide row into 2 columns in excel Attached Files
      My Computer


 

  Related Discussions
Our Sites
Site Links
About Us
Windows 7 Forums is an independent web site and has not been authorized, sponsored, or otherwise approved by Microsoft Corporation. "Windows 7" and related materials are trademarks of Microsoft Corp.

© Designer Media Ltd
All times are GMT -5. The time now is 17:55.
Find Us