Moving the (Irritating) formula hint bar

While we start entering the formula, excel tries to help us by displaying the formula hint window as shown below. Sometime this may block viewing some of the cells which may be required to refer for completing the formula.

Moveformulahintbar-1

But this hint bar can be moved to a different place which most of the users not aware of. Just mouse over this hint window until the cursor shape changes something like cross with triangle shaped edges, click and drag to the location which is convenient to you to continue editing the formula.

Moveformulahintbar-2

Moveformulahintbar-3

Once it is moved you can continue editing the formula and when you are out of that formula, hint bar also disappears as usual. Other way to counter this problem is typing the formula directly in the formula bar instead of typing in the cell, which some users doesn’t prefer.


   2 Comments


  1. WilliamsoR
      May 22, 2016

    I truly appreciate this forum.Thanks Again. Really Great. Dernier

    • Wilson
        May 23, 2016

      Thanks for your comments.

Leave a Reply

Your email address will not be published. Required fields are marked *