creating form in xl.

  • Thread starter Thread starter Guest
  • Start date Start date
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
 
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
 
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
 
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
 
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
 
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!
 
You must log in or register to reply here.

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

Similar Threads

linking between worksheets 1
problem with fractions to decimal 1
Creating Sheets in a present Xl File 2
In Excel I need to insert a clean form each use 1
How do I create a form in Excel that I can send to be filled out? 2
Creating Print Macro 1
combining data multiple worksheets into one? 5
Create Fill In Template in Excel? 1

Back
Top