Windows 7 Forums

Welcome to Windows 7 Forums. Our forum is dedicated to helping you find support and solutions for any problems regarding your Windows 7 PC be it Dell, HP, Acer, Asus or a custom build. We also provide an extensive Windows 7 tutorial section that covers a wide range of tips and tricks.


Windows 7: how to divide row into 2 columns in excel

14 Jul 2014   #1
florida2001

64bit windows 7
 
 
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
how to divide row into 2 columns in excel-photo-2-.jpg  
My System SpecsSystem Spec
.
14 Jul 2014   #2
ignatzatsonic

Microsoft Community Contributor Award Recipient

Windows 7 Home Premium SP1, 64-bit
 
 

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 System SpecsSystem Spec
14 Jul 2014   #3
PooMan UK

Windows 7 Ultimate 64bit
 
 

Something like this pal .... (excel file below)


Attached Thumbnails
how to divide row into 2 columns in excel-capture.jpg  
Attached Files
File Type: zip Book1.zip (4.1 KB, 0 views)
My System SpecsSystem Spec
.

Reply

 how to divide row into 2 columns in excel




Thread Tools Search this Thread
Search this Thread:

Advanced Search




Similar help and support threads
Thread Forum
Sub-nets - How to divide a small wired home network into 2 subnets?
Hi guys, I have a fairly typical small wired home network, consisting of a handful of Win7 DHCP clients and a few shared fixed-IP public resources (printer, web-enabled DVR, intranet web and file servers etc), connected to an ADSL router (LiveBox) for Internet access which is configured with...
Network & Sharing
Web site data to excel columns
Is it possible to fetch some lines of data from a group of web pages and paste in to Excel?Pls view the image for required excel columns. urls are, Stock Share Price dlf ltd | Get Quote dlf | BSE Stock Share Price dlf ltd | Get Quote dlf | BSE Stock Share Price jaiprakash associates ltd | Get...
Browsers & Mail
I wanted to divide into five partition my laptop hard drive
Hi guys. i have a dell 5010 laptop I wanted to divide into five partition my laptop hard drive. But 7 did not let that make more than four partitions. My hard drive capacity is 465 GB. 7 automatically maked partition 0 with a capacity of 100 Mb. I built second partition 65 GB and the third...
General Discussion
Formatting Excel 2010, Excel 2003
Hello, I want to create a table as in the drawing below, where the first cell is table-wide (as it contains the heading common (pertaining?) to all columns and rows under it) but, and this is where I cannot get it together, where those cells are divided into several columns. It's a cinch when...
Microsoft Office
Want to divide disk into c: and d: partitions.
My new computer came with one c: partition. I want to shrink it and use the avaialble space to set up a second partition which I want to format as vfat. I've done this before with a machine running vista. By going to help I found something under partitioning a disk, which had me link to...
Installation & Setup
Can't open 2003 Excel Files in Excel 2007?
I'm not sure if it because the files are 2003 or not? When I try to open them an error message appears stating, "...the file you are trying to open is in a different format than specified by the file extension. Verify file is not corrupted and is from a trusted source..." These are my files. The...
Microsoft Office


Our Sites

Site Links

About Us

Find 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 19:34.

Twitter Facebook Google+



Windows 7 Forums

Seven Forums Android App Seven Forums IOS App