ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Isolated rows within a single cell? (https://www.excelbanter.com/excel-discussion-misc-queries/118575-isolated-rows-within-single-cell.html)

Ryan P.

Isolated rows within a single cell?
 
I know that you can't actually change the cell height in different
cells across a row, but I'm hoping there is a work-around. I am trying
to produce a spreadsheet that will look like the following:

A B C D
__________________________________________________ ____________
| |Option #1 |_____[Value]___|[Comments] |
| |Option #2 |_______________|[over multiple]|
1 |[Picture] |Option #3 |_______________|[lines] |
| | |_______________| |
|____________|_______________|_______________|____ ___________|


The position of (C) could be next to any (but only one) of the options
in (B). The application is for a service technician to enter the values
quickly without having to do any formatting for position or color; point
next to the option in (B) and type.

The size of (A) and (D) cannot change as the form needs to be easily
printable on a standard 8.5 x 11 page.

Worst-case option would be to make a text box for each value
postion... but that's multiple boxes in 20 cells... Not an appealing
prospect!

Any ideas?

Ryan P.

Isolated rows within a single cell?
 
Sorry. I used tabs and the formatting broke on review... here's a
"spaced" version incase the same thing happens to anyone else!

__________________________________________________ ____________
| |Option #1 |_____[Value]___|[Comments] |
| |Option #2 |_______________|[over multiple]|
1 |[Picture] |Option #3 |_______________|[lines] |
| | |_______________| |
|____________|_______________|_______________|____ ___________|


Ryan P.

Isolated rows within a single cell?
 
Ryan P. wrote:

A B C D
************************************************** ************
* * Option #1 * [Value] *[Comments] *
* * ***************** *
* * Option #2 * *[over multiple]*
* * ***************** *
1 *[Picture] *Option #3 * * [lines] *
* * ***************** *
* * * * *
************************************************** ************

Ryan P.

Isolated rows within a single cell?
 
One more try with the table...


A B C D
Option 1 Comments Over
Option 2 multiple lines
1 [Picture] Option 3 Value
Option 4
Option 5

Option 1 Comments Over
Option 2 multiple lines
2 [Picture] Option 3 Value
Option 4
Option 5


All times are GMT +1. The time now is 06:07 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com