I have a word document that's not currently in any forms, or any other type, of format. It consists of chunks of information and a main table in landscape with about 9 or 10 headings - type of risk, control risk, hazard etc. under each of the headings are categories. So, for each heading it needs completing for noise, health, asbestos, environment etc.

The amount that can be put in each of the areas varies. For instance, under health and hazard there could be lots of information but under noise and hazard you could have little or no information.

Currently, the table jumps all over the place. I can't keep information together. Even if I do a repeat on header rows, the separate elements underneath it can make it difficult to follow.

Can I create some kind of form in Word or Excel into which users can enter data and the cell fits the text entered? The user would also need to save the form and print it out in a readable format.

The form is attached. Any help would be gratefully appreciated. I'm really struggling with where to start. Toyed with using Visual Basic in Word and Excel, a spreadsheet etc. and really getting confused.

Attached Files

RA Document For MS Forum.docx (54.2 KB, 42 views)

You could format the cells to wrap to text

Hi
You need to set all of your head rows to "keep with next". Select Format -> Paragraph and then select the "Line and Page Breaks" tab and tick the "Keep with next" box. This will ensure that all heads stay with the text below it.
Then you need to take off the fixed row height you have set in your table. Any text entered in a cell will then expand that cell to fit its size as required.
If you need any further help then come back to me.
Good luck.
Tony(OTPM)

Hi
In order to get the best out of any application you need to take time to learn it. Only then will you be amazed at what you can achieve yourself.
If you want to attach a copy of your form I will try and find time to see what I can do to help.
Tony (OTPM)