A couple questions about Excel 2007:



1) How can I highlight a whole block of cells and merge them across the rows only? So they would become a single column of rows, but the number of rows would remain the same as before the merge.

2) Is there a way of creating a spreadsheet within a spreadsheet? I mean that I want to create a set of sub-rows within a row under a specific column. Can this be done?
Thanks