Formula bar off screen to left

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

 

[JE McGimpsey]

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?

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

~:Libraryreferences:Microsoft:Excel Toolbars (11)

file (where ~ is your home directory).

 

[JeanLeRouge]

Thanks very much - that worked perfectly.