how to divide row into 2 columns in excel

florida2001

New member
Local time
2:58 AM
Messages
12
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
 

Attachments

  • photo (2).JPG
    photo (2).JPG
    95.2 KB · Views: 1

My Computer My Computer

At a glance

64bit windows 7
Computer type
PC/Desktop
OS
64bit windows 7
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 My Computer

At a glance

Windows 7 Home Premium SP1, 64-bitIntel Skylake i5-6600K, not overclocked8 GB HyperX DDR4-2666 (2 x 4 GB)none; graphics are integrated on CPU
Computer type
PC/Desktop
Computer Manufacturer/Model Number
Ignatz Special; 4 speed manual gearbox; factory air conditioning; one of one
OS
Windows 7 Home Premium SP1, 64-bit
CPU
Intel Skylake i5-6600K, not overclocked
Motherboard
AsRock Z170M Extreme 4, micro ATX
Memory
8 GB HyperX DDR4-2666 (2 x 4 GB)
Graphics Card(s)
none; graphics are integrated on CPU
Sound Card
onboard: Realtek ALC1150; external: USB Behringer UF0-202
Monitor(s) Displays
Dell S2340M 23 inch IPS
Screen Resolution
1600 x 900
Hard Drives
System: Crucial MX100 series SSD, 128 GB;
Data: Samsung Spinpoint 103SJ, 1 TB;
Backup: WD Caviar Green WD30EZRX-00D8PB0, 3 TB
PSU
Rosewill SilentNight 500 watt fanless, semi-modular
Case
Antec Solo II
Cooling
Noctua NH-U12S; Noctua F12 intake, Noctua S12A exhaust
Keyboard
Microsoft 200 6JH-00001 USB
Mouse
Dell or Microsoft optical wired; USB
Antivirus
Microsoft Security Essentials and Malwarebytes Premium
Browser
Pale Moon
Other Info
All fans PWM; speeds at idle: CPU circa 500 rpm; intake circa 600 rpm; exhaust circa 600 rpm; CPU temps 27 idle and 47 C load in a warm room (27 C/81 F) when running Intel Extreme Tuning Utility stress test.
Something like this pal .... (excel file below) ;)
 

Attachments

  • Book1.zip
    Book1.zip
    4.1 KB · Views: 4
  • Capture.JPG
    Capture.JPG
    48.6 KB · Views: 2

My Computer My Computer

At a glance

Windows 7 Ultimate 64bitAMD Phenom Quad core 9950 black edition16Gb2x XFX Radeon 5850
Computer type
PC/Desktop
Computer Manufacturer/Model Number
Self Built
OS
Windows 7 Ultimate 64bit
CPU
AMD Phenom Quad core 9950 black edition
Motherboard
Gigabyte
Memory
16Gb
Graphics Card(s)
2x XFX Radeon 5850
Sound Card
PCI Express X-Fi Titanium / Logitech G35
Monitor(s) Displays
2x HP 2410i
Screen Resolution
1920x1080
Hard Drives
2x 500Gb Seagate
1x 300Gb Seagate
1x 1Tb Seagate
2x 1Tb Hitatchi
PSU
Jean Tech Storm 700W
Case
Cooler Master COSMOS S
Cooling
Akasa Evo Blue Pro
Keyboard
Logitech G15
Mouse
Mad Catz M.M.O. 7
Internet Speed
12mb
Back
Top