Public Schedule Face-to-Face & Online Instructor-Led Training - View dates & book

templates

ResolvedVersion 2007

Li-kim has attended:
Excel Intermediate course
Excel Advanced course
Excel VBA Intro Intermediate course

Templates

After creating a template containing various fields/cells for users to fill in, as well as cells that users cannot alter, how can I transfer the template to other formats e.g. Word, PDF, online submission? The intention is to provide an alternative format that contains all capabilities and limitations of the original template in Excel.

RE: templates

Hello Li-kim
Thank you for your question

You can not transfer the template to word, you would need to recreate it manually. This means it will look much better in word. Once you have done the word version you can convert a word doc into PDF and the format will work as a static template, but you will not be able to edit PDFs without an editor program installed. For a proper web format it would also be better to code a web form from scratch or simply provide a link to the excel/word document.

If this resolves your question, please mark it as resolved. If not, please reply with more information.

Kind regards
Cress

Mon 2 Mar 2009: Automatically marked as resolved.

Excel tip:

Repeating headings on spreadsheets that print on more than one page

By default when you print a spreadsheet out and it prints on more than one page, the headings at the top and the side of the spreadsheet don't appear on all the pages following page 1.

To get Excel to repeat headings on all pages when printing, go to File - Page Setup - Sheet, then select the rows to repeat at the top of pages, and the columns to repeat at the side of pages by clicking on the red arrows at the right side of the two boxes under the 'Print titles' area. Then click OK.

If you view your spreadsheet in Print Preview, you should see the headings being repeated on each page.

View all Excel hints and tips

Connect with us:

0207 987 3777

Call for assistance

Request Callback

We will call you back

Server loaded in 0.12 secs.