Cell Format

M

Ms. L

How do I create multiple columns under 1 cell?
EX: In a cell named Automobile, I would like to put 4 columns named
GasPurchse, Mileage, Repairs, and Misc
Thanks
 
D

Daniel CHEN

You can name A1, B1, C1 and D1 as GasPurchse, Mileage, Repairs, and Misc,
respectively.
And then name range A1:D1 as Automobile.


--
Best regards,
---
Yongjun CHEN
=================================
XLDataSoft - Data Analysis Expert, Excel/VBA Specialist
- - - - www.XLDataSoft.com - - - -
Free Excel-Based Data Processing Tool is Available for Download
Free Excel / VBA Training Materials is Available for Download
=================================
 
D

Dav

have automobile in the top row (top left above gass purchase), label th
row below for your 4 columns. Then select Automobile and the 3 cells t
the right and format_cells_Alignment and choose merge cells

Regards

Da
 
Top