Moving the formula bar

[morry]

For some reason the formula bar is too far over to the left and the
portion that can be dragged cannot be seen. How can I move the
formula bar to the right so that I can see the end and move it to
where I want it?

 

[JE McGimpsey]

For some reason the formula bar is too far over to the left and the
portion that can be dragged cannot be seen. How can I move the
formula bar to the right so that I can see the end and move it to
where I want it?

One way:

Type Opt-F11 to enter the Visual Basic Editor. Type CMD-G to open the
Immediate window. Type or paste this into the Immediate Window

Commandbars("Formula Bar").Left = 0

followed by the Return/Enter key. Type Opt-F11 to return to XL.