I want to make format in Excel

[aparvez007]

Dear All,

I am manually writing 20 to 25 attached form on daily basis. I want to make excel format where I can type and print on origional form.


Regards,
pAvi

 

[Hui]

Setup a form with fields as per your sample

The form could be linked to a Database or another worksheet where you enter the values and it will update on the form for you

Best to start simply laying out the form first

 

[aparvez007]

Thanks Hui Sir,

But I am asking how can I setup this form in excel, and I dont want any link with this excel I will just fill the form and take print out instead of writing.

Please check attached sample.

Regards,
pAvi

 

[sudipto3003]

dear pavi,

r u looking for a converted excel file, there are several sites for online converter from pdf to excel.

 

[aparvez007]

Dear Sudipto3003,

Thanks for your reply.

I am not looking for pdf to excel converter. You can see the file SABB Form Print.xlsm I want the way this file created.


Regards,
pAvi

 

[Hui]

pAvi

As with the Saab file it is simply a matter of laying out the cells in the style you want

you can either add cell border or add shapes ontop of the worksheet for check boxes etc

There is no easy method

Start at the top and work your way down

You can merge cells and add shading to cells and cell boarders to get various effects

Don't be shy on using more columns than you need as you can resize or delete them later if you don't need them