Trying to make a simple looking spreadsheet

Is this sort of thing possible in Excel? Artistic rendition attached.

1) Can a formula refer to a Text Box, or other item?
2) Can a layout remotely like this be made, above, below, anywhere... that the text box doesn't scroll with the rest of the information, or overlap existing rows and columns?

Hi
Have a look at what I came up with and let me know if that is what your looking for.

JG

I suppose for my one text box example I could survive with freezing the panes a couple rows lower than usual, but I was looking for a solution that wasn't so ... constricting. I was hoping for some magically floating field that could have different widths and positions than the existing columns.

I thought I found it when I found this link, Linking a Cell to a Text Box, but I'm not finding any way to connect a normal everyday cell formula to a text box.

All I can get a text box to do is to copy an existing cell's final result. Is this the limit of Excel? I'm surprised I can't put any formulas in text boxes.

Hi
I'm not sure if this will help but try using a text box from the visual basic toolbar. You can link the text box to a cell and then use that cell as the reference cell in your formula.

How? Link?

I found the Visual Basic toolbar, added a text box, edited properties to include some number ... what do I do next?

Hi
Good, go back to properties and under the (Alphabetic) tab find the "Linked Cell" option and type a Cell address in the box to the right of it... e.g A1 , I would use a cell that is hidden somewhere or from a column that will never be seen. Once you have set up the size and location of the text box exit design mode, the button with the blue triangle on the visual basic toolbar. Now for your formula, lets say that your Kwh column is B and the cost is C then in C1:

=B1*$A$1

or you could define your linked cell by selecting it and hitting CTRL+F3, type a name... e.g rate and hit ok. The formula would then be:

=B1*rate
copied down

Hopes this help!

Anybody?