I am using 2003. I dont know what you have but one way around this is
to use the "Insert Function" button. This is located immediately to
the left of the Formula Bar. If you cant see the Formula Bar then do
the following:

Select: Tools...Options...View(tab) and select the checkbox next to
Formula Bar.

This will give you full access to all the functions and a nice help
menu as well.