Home |
Search |
Today's Posts |
#1
|
|||
|
|||
rows within rows
I was wondering if it was possible to create rows within rows. What I mean
is A1, 1 row but within that row I would like ten rows for B1-V1. If anyone has any suggestion that would be greatly appreciated. Thanks. |
#2
|
|||
|
|||
Not really.
You could merge B1:B10, but merged cells really cause trouble later (pasting, sorting). Maybe it would be enough just to start a new line within the cell. You can use alt-enter if you're typing data or you could use char(10) if you're using formulas: ="line 1" & char(10) & "line 2" (format the cell with wraptext turned on.) I need to sort the items by their item wrote: I was wondering if it was possible to create rows within rows. What I mean is A1, 1 row but within that row I would like ten rows for B1-V1. If anyone has any suggestion that would be greatly appreciated. Thanks. -- Dave Peterson |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Insert rows based on specific value | Excel Worksheet Functions | |||
formula to use when number of rows changes dynamically | Excel Worksheet Functions | |||
Hiding Rows if the linked rows are blank | Excel Discussion (Misc queries) | |||
Row selections by row # OR by even/odd rows in another spreadsheet | Excel Discussion (Misc queries) | |||
Adding Rows to Master Sheet | New Users to Excel |