Home |
Search |
Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Cell Format
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 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Cell Format
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 ================================= "Ms. L" wrote in message ... 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 |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Cell Format
have automobile in the top row (top left above gass purchase), label the row below for your 4 columns. Then select Automobile and the 3 cells to the right and format_cells_Alignment and choose merge cells Regards Dav -- Dav ------------------------------------------------------------------------ Dav's Profile: http://www.excelforum.com/member.php...o&userid=27107 View this thread: http://www.excelforum.com/showthread...hreadid=544741 |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
Cell Format
Thanks Dav
"Dav" wrote in message ... have automobile in the top row (top left above gass purchase), label the row below for your 4 columns. Then select Automobile and the 3 cells to the right and format_cells_Alignment and choose merge cells Regards Dav -- Dav ------------------------------------------------------------------------ Dav's Profile: http://www.excelforum.com/member.php...o&userid=27107 View this thread: http://www.excelforum.com/showthread...hreadid=544741 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
conditional cell format based on cell in same row, previous column | Excel Worksheet Functions | |||
Custom functions calculating time arguments Help Desperate | Excel Worksheet Functions | |||
Cell data format | Excel Discussion (Misc queries) | |||
Possible Lookup Table | Excel Worksheet Functions | |||
can't format cell - have tried unlocking and unprotecting | Excel Discussion (Misc queries) |