I presume the problem is that the formula bar then covers the
first row(s), for which there is not fix. You might insert some
rows at the top temporarily, and later on show some rows above
your area of interest.
---
HTH,
David McRitchie, Microsoft MVP - Excel [site changed Nov. 2001]
My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm
Search Page: http://www.mvps.org/dmcritchie/excel/search.htm

"NickHK" wrote in message ...
Tivpine,
Sorry, do not understand the problem, as the formula bar runs across the
majority of the of Excel window and expands to multiple lines if required.

NickHK

"Tivpine" wrote in message
...
Am currently using the Excel 2003 version, and i am currently designing
exam
templates for the Department of Management at our local university here.
My
formula's dont fit into the formula bar due to the lenght of the my
worksheet. My worksheet is between forty to sixty columns long.