ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Is it possible to expand the formula bar in excel? (https://www.excelbanter.com/excel-programming/337259-possible-expand-formula-bar-excel.html)

Tivpine

Is it possible to expand the formula bar in excel?
 
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.

Tom Ogilvy

Is it possible to expand the formula bar in excel?
 
Your formulas should wrap so you can see all of the formula.

--
Regards,
Tom Ogilvy

"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.




NickHK

Is it possible to expand the formula bar in excel?
 
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.




David McRitchie

Is it possible to expand the formula bar in excel?
 
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.







All times are GMT +1. The time now is 10:27 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com