PDA

View Full Version : MS Excell worksheet



Chads
14-07-2009, 01:37 PM
I have a data base in an Excell worksheet. The data consists of boat names, the owners details and boat details. I want to show all the details for an individual boat in a form that can be -
(a) amended
(b) a new boat added to
(c) the form able to be printed.

I can bring up a form within the work sheet (Data, Form) but -
(a) I can't size the form which I would like to do.
(b) can't be printed.
That particular form would suit my purpose fine if i could resolve the above mentioned issues

pctek
14-07-2009, 03:05 PM
Why can't you print it?

Why can't you size it?
The thing with Excel is you can make any form you like with it.
You can have different sizes for certain cells, rows and columns, you can amend and format anything at all in it.

It may take a bit of fiddling around to get the layout in a way you like, but it certainly is possible.

What issue are you having exactly?

Chads
14-07-2009, 04:13 PM
I can work up the worksheet,size and print such. What I am wanting to do is printout a A5 sized sheet (form) that relates to the worksheet.

pctek
14-07-2009, 05:13 PM
Page Setup, change to A5, then amend your cells accordingly.

andrew93
14-07-2009, 07:14 PM
Hi

The issue with the Data > Form is that it is essentially a dialogue box so you can't naturally print or resize it.

If you want to create a customised form in Excel 2003, then the following tutorial should help:
http://www.contextures.com/xlUserForm01.html

Andrew

P.S. I haven't tested this particular tutorial and the ability to print records via the form.......