creating form in xl.

G

Guest

hi, anyone know how i can create a form to show up on my
excel sheet as a "on screen form" with fill-in blanks.
Similar to sheets like "invoice.template or balnce sheet
templates". i tried saving as a template but it still
shows up on screen like a spreadsheet with cells?
any suggestions?
thanks!!!
PS: basically i want to create a daily log that can be
filled out by me as well as my employees. each time they
use the tab button it jumps from data line to data line
or entry line.
mike
 
P

Peter Atherton

Mike

You need to protect the worksheet. Before you do that
first format the cells to enter. Select the data entry
cells and press Ctl +1, Format, Protection. Remove the
locked checkmark and click OK. The data entry cell should
now all be unprotected

To protect the sheet choose

Tools, Protection, Protect sheet; I would suggest that you
do not add a password at this stage. Now test your sheet.
If you press a down arrow you can move to any cell but if
you press the Tab key you will be able to jump to the next
data entry cell.

Regards
Peter
 
P

Peter Atherton

Mike

You need to protect the worksheet. Before you do that
first format the cells to enter. Select the data entry
cells and press Ctl +1, Format, Protection. Remove the
locked checkmark and click OK. The data entry cell should
now all be unprotected

To protect the sheet choose

Tools, Protection, Protect sheet; I would suggest that you
do not add a password at this stage. Now test your sheet.
If you press a down arrow you can move to any cell but if
you press the Tab key you will be able to jump to the next
data entry cell.

Regards
Peter
 
P

Peter Atherton

Mike

You need to protect the worksheet. Before you do that
first format the cells to enter. Select the data entry
cells and press Ctl +1, Format, Protection. Remove the
locked checkmark and click OK. The data entry cell should
now all be unprotected

To protect the sheet choose

Tools, Protection, Protect sheet; I would suggest that you
do not add a password at this stage. Now test your sheet.
If you press a down arrow you can move to any cell but if
you press the Tab key you will be able to jump to the next
data entry cell.

Regards
Peter
 
P

Peter Atherton

Mike

You need to protect the worksheet. Before you do that
first format the cells to enter. Select the data entry
cells and press Ctl +1, Format, Protection. Remove the
locked checkmark and click OK. The data entry cell should
now all be unprotected

To protect the sheet choose

Tools, Protection, Protect sheet; I would suggest that you
do not add a password at this stage. Now test your sheet.
If you press a down arrow you can move to any cell but if
you press the Tab key you will be able to jump to the next
data entry cell.

Regards
Peter
 
G

Guest

great! It works thanks!! Now willthis show up like
a "form" each time i open it?? yu know with blacked out
background and all the works of thier saved templates??or
is that a built in form by thier programmers?
mike thanks agian!
 
Top