Formula bar off screen to left

J

JeanLeRouge

Hi when I open Excel and activate the Formula bar it opens with the left hand
end off screen which means I cannot move it to dock it properly. Any ideas?
 
J

JE McGimpsey

JeanLeRouge said:
Hi when I open Excel and activate the Formula bar it opens with the left hand
end off screen which means I cannot move it to dock it properly. Any ideas?
Click to expand...

One way:

Type Opt-F11 to enter the Visual Basic Editor (VBE). Type CMD-g to open
the Immediate Window. Type or paste this line into the Immediate Window,
followed by Return:

CommandBars("Formula Bar").Left = 100

Type Opt-F11 to return to XL.

An alternative (if you don't have toolbar customizations that you want
to save):

With XL closed, delete the

~:Library:preferences:Microsoft:Excel Toolbars (11)

file (where ~ is your home directory).
 
Top