Go to ToolsOptionsView and check the Formula Bar.

For the other, right click in the bottom-right area, and click which option
you want.

--

HTH

Bob Phillips

(remove nothere from the email address if mailing direct)

"Drew" wrote in message
...
I have somehow lost the toolbar that sits directly above the cells of an
open
Excel spreadsheet that allows one to type and edit text or formulas in a
selected cell. also the toolbar directly below the spreadsheet that
contains
the box that automatically calculates sums or averages, etc... as cells
are
selected. How can I restore these toolbars?