Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
HBH Gloria
 
Posts: n/a
Default 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,

  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
David McRitchie
 
Posts: n/a
Default 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,



  #3   Report Post  
Posted to microsoft.public.excel.worksheet.functions
HBH Gloria
 
Posts: n/a
Default 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,




Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Return SEARCHED Column Number of Numeric Label and Value Sam via OfficeKB.com Excel Worksheet Functions 23 January 30th 06 06:16 PM
checking that cells have a value before the workbook will close kcdonaldson Excel Worksheet Functions 8 December 5th 05 04:57 PM
Enable a new dimention: sub-level of split cells yarp Excel Discussion (Misc queries) 3 August 8th 05 04:11 PM
removing blank cells from a column joeeng Excel Discussion (Misc queries) 1 July 26th 05 08:01 PM
match and count words David Excel Worksheet Functions 5 July 4th 05 02:24 AM


All times are GMT +1. The time now is 08:44 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"