User-friendly editing

Hi,

I'm developing a Workbook for non-Excellers to use. The mainstay of this is a table of records individual to each user. They input a record type and the remaining columns are completed with LOOKUP functions etc., returning text, often of considerable length. Over time the values for each record will deviate from the initial defaults. Users will have to manually edit the returned strings. At the moment, I have to instruct users to 'Paste values' before editing the text, or else the whole string is lost. This works, but confuses many users and is annoying for all. Is there a way to get the value to appear in the formula bar for editing and/or to automatically paste values across a row after one specified column is filled in? This would allow users to edit the records with ease.

I can provide a simplified mock-up if needed, but hope my explanation makes at least some sense.

Thanks.

F2 edits the formula, not value, no? I need to edit values.

The formulas look up starting values for models that users can then go on to customise. Most are not simple figures that can be typed over the formulas, but contain concatenated text items a user may wish to add to. But it's currently impossible to edit without pasting values. I can do this with keyboard shortcuts, but must users just baulk when they click on a cell and the massive concatenation formulas appear.

Ahh, brilliant. I hadn't come across F9 before. That will speed things up. Thanks.