"Form" repeats on every page

J

Jochen Daum

Hi,

With Excel 2000, are there options to put some kind of "Form" into the
cells (like a form you would have on paper) and have that page
repeated automatically, once you move the cursor to the next page?

Thaks for any pointer,

Jochen
 
T

Trevor

Yes, I've seen many people use Excel to enter a question and then use cell
borders to make an "underline" where a user would type a response, or, when
the worksheet was printed, write a response.

One way to make multiple pages would be to copy the spreadsheet. Each time
you need a new page, right-click on the tab, select "Move or Copy...", put a
check mark in the "Create a copy" option, and click OK.

You could also create your spreadsheet and save it as a template. Create
your spreadsheet with your questions and cells with borders, then choose
File->Save As. In the window that appear, specify the "Save as type" as
"Template (*.xlt). Now, every time you create a new spreadsheet, use that
template, so you'll start with your questions and underlines, instead of a
blank spreadsheet. This could be very effective, so read up on Templates if
you're unfamilar with them.

Finally, I would also like to let you know that there is a new product in
the latest version of Microsoft Office which is called InfoPath. It is very
useful for creating electronic versions of paper forms and capturing the
answers.... the Excel forum isn't the right place to talk about InfoPath,
but if you'd like more information, post a reply or e-mail me at
(e-mail address removed).
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top