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

Hi gib65,

1: Unless you're into vba coding, not possible if you select more than one row at a time;
2: Not if you mean multiple rows & columns in a single row/column. You can, of course merge rows&columns around your sub-set, but this doesn't change the underlying workbook structure.

__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]

Too bad. Thanks for your response, macropod.