Column headers are sometimes blocked

Question

I recently swapped from using VLookup to XLookup. One weird quirk I've noticed is that with XLookup, sometimes a teaser line (I have no clue what else to call it) pops up to remind me of what comes next in the formula construction. The problem is it covers the column headers and will not move out of the way. If I am trying to select an entire column that happens to fall under it, I have to type that part of the formula manually, or click another column then manually update my formula. Is this by design? Is my install broken? Anyone know if this is scheduled to be fixed?

I know I can "fix" it if I use a specific cell range instead of the entire column, but with some of the files I handle, it's easier and more efficient to use the entire column.

Portion of the file name that shows the company name was deliberately blurred out. For the example shown in the screenshot, I was populating data from the .csv into an .xlsx file. I am using Office365 for Business on a Windows 10 PC.

Answer 1

Hi

Thank you for your question in this community, according to your description of the problem:

Do you think this Screen Tips affects your use, you can place your mouse on Tips and until that there is a

After the icon, you can drag and drop this tips.

Or you can turn off this Options by setting,

1. Click Microsoft Office, click Excel Options, and then Click Advanced.
2. in the display area, click to clear the show function screen prompt check box.

Hope to help you solve this problem, thank you for your support and understanding!

Best Regards

Ethan

Answer 2

You're an angel! I don't want to turn them off because I love having the reminders, but dragging it elsewhere worked. It never dawned on me that it would be draggable. Thank you!