Moving the formula bar

M

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?
 
J

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?
Click to expand...

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