I keep getting frustrated with the Excel syntax bubble obscuring the column headers. My headers are often narrow and my formulas often refer to whole columns, but I can't simply click them because they are obscured. Naturally, the bubble appears where it does because I disabled "Allow Editing Directly in Cells", but I am not prepared to put it back on (because editing in cell obstructs adjacent cells). The worst thing is that the bubble always shows over the column headers, even if the formula bar has empty rows. Finally, I acknowledge it is still possible to click over the tiny strip between the column headers and formula bar (highlighted green in the screenshot). BUT if any cell in the column selected is part of a merged cell spanning more than one column, then the range Excel enters into the formula spans all the columns involved, even if I only click on the single one I need, and it is impossible to see which column I actually need. So I always have to accept the formula, often with errors, and then go back and edit manually to narrow the range down to the single column I need. (NB The screenshot is taken with print screen rather than the snipping tool, as I needed to be able to show how excel uses green highlight to show where I'm hovering - I don't know how to achieve this with the snipping tool).
I can see a few ways this could be resolved:
- the bubble could appear below the cursor so stretching/scrolling the formula bar would indirectly control where the bubble shows
- the bubble could become transparent when I hover over it with the cursor
- the bubble could be toggled off, perhaps with a keyboard shortcut.
Does anyone know how to achieve any of the above, or are there any alternative solutions? Or at least please tell me it's not just me suffering from this? I got zero results from my google searches so far!