#1
|
|||
|
|||
merging rows and creating sub-rows
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 |
#2
|
||||
|
||||
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] Last edited by macropod; 12-08-2011 at 07:30 PM. Reason: Clarification |
#3
|
|||
|
|||
Too bad. Thanks for your response, macropod.
|
Thread Tools | |
Display Modes | |
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
How make rows equalized | Yumin | Word Tables | 2 | 09-21-2011 09:17 AM |
Product and Sum on 2 rows | apolloman | Excel | 2 | 04-27-2011 07:14 AM |
Rows to Columns | kyakobi | Excel | 5 | 12-07-2010 03:12 PM |
Average of many rows | speedycorn1 | Excel | 1 | 10-30-2010 07:54 PM |
How do I turn the top 2 rows into a header | GR8Fandini | Excel | 1 | 02-06-2010 12:58 PM |