every time I open Excel the formula bar is hidden and I have to click on view and then formula bar. Does anyone know how I can get the formula bar to always appear?

Thanks

try this, go to "Tools", select "Options"
select the "View" tab
there should be a formula bar to check

Thanks Bill!