![]() |
Split cells below header column:
I am trying to split the cells below a Header Column:
Header: Time I would like to split the cells below that to put in variable times. 1st split would contain the start time. The second split would contain the ending time. This is to be used for volunteer event scheduling. Thanks, |
Split cells below header column:
Hi Gloria,
Microsoft Word allows you to split a cell. In Excel, each cell has an address and cannot be split. What you can do in insert another column them merge the two cells in the first row. http://www.mvps.org/dmcritchie/excel/merge.htm#builtin As noted on the page merging cells may interfere with such things as sorting, filtering, and autofit of rows and columns. To merge two cells select them, then format, cells, alignment, merge. You can install and use the toolbar icons to do this faster. --- HTH, David McRitchie, Microsoft MVP - Excel [site changed Nov. 2001] My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm Search Page: http://www.mvps.org/dmcritchie/excel/search.htm "HBH Gloria" <HBH wrote in message ... I am trying to split the cells below a Header Column: Header: Time I would like to split the cells below that to put in variable times. 1st split would contain the start time. The second split would contain the ending time. This is to be used for volunteer event scheduling. Thanks, |
Split cells below header column:
Thanks Dave!
"David McRitchie" wrote: Hi Gloria, Microsoft Word allows you to split a cell. In Excel, each cell has an address and cannot be split. What you can do in insert another column them merge the two cells in the first row. http://www.mvps.org/dmcritchie/excel/merge.htm#builtin As noted on the page merging cells may interfere with such things as sorting, filtering, and autofit of rows and columns. To merge two cells select them, then format, cells, alignment, merge. You can install and use the toolbar icons to do this faster. --- HTH, David McRitchie, Microsoft MVP - Excel [site changed Nov. 2001] My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm Search Page: http://www.mvps.org/dmcritchie/excel/search.htm "HBH Gloria" <HBH wrote in message ... I am trying to split the cells below a Header Column: Header: Time I would like to split the cells below that to put in variable times. 1st split would contain the start time. The second split would contain the ending time. This is to be used for volunteer event scheduling. Thanks, |
All times are GMT +1. The time now is 08:12 AM. |
Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com