Data Entry in Excel Database

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Maisey - 11 May 2007 01:57 GMT

I have a database in excel for my collection of books which contains various
columns, title, type, cost etc. In excel 2000 when I wanted to add a new
book I just clicked on form and a box opened with all my column names in it
and I just filled in the new data. In Excel 2007 I cannot find this command
anywhere.

Can anybody help.

Reply to this Message

Roger Govier - 11 May 2007 12:46 GMT

Hi

You will need to add the facility to your Quick Access Toolbar (QAT)
Press the round Office button>Excel Options>Customise>Choose Command
from>use dropdown to select All Commands.
Scroll down to Form>click Add.

From your QAT, click the new icon you have added.

Signature

Regards

Roger Govier

>I have a database in excel for my collection of books which contains
>various
[quoted text clipped - 7 lines]
>
> Can anybody help.

Reply to this Message

Shailesh Shah - 29 May 2007 11:25 GMT

In addition you may see below link,

http://office.microsoft.com/en-us/excel/HA101491511033.aspx

to download workbook showing location of excel-2003 menu in excel-2007.
http://office.microsoft.com/search/redir.aspx?AssetID=AM101864291033&CTT=5&Origi
n=HA100860481033

In case you want to use excel-2003 menu in excel-2007, email me, you can
use my free addins excel-2003 menu for excel-2007. This will place worksheet
menu, standard toolbar & formatting toolbar in the addins tab.

Regards,
Shailesh Shah
http://in.geocities.com/shahshaileshs/
(Excel Add-ins Page)

> I have a database in excel for my collection of books which contains various
> columns, title, type, cost etc. In excel 2000 when I wanted to add a new
[quoted text clipped - 3 lines]
>
> Can anybody help.

Reply to this Message