Data Entry Form

B

Barrym

I have 11 colums of data with headers and I would like to use a dat
entry form. One column is a date format which returns a day name in th
next column. One column is a time format and the balance are tex
columns. The data base is a customer call log.
When I click data and then form from the main tool bar I get
generated form that won't allow additional entries. What is the bes
way to create a data entry form in Excel 2003
 
D

Dave Peterson

Additional entries means more rows or more columns?

I'm betting more rows.

Any chance you have a row gap in your data. Maybe excel saw that as the bottom
most row that can be used.

You could get rid of those empty rows or select the whole range first, then do
data|Form
 
Top