Thread: Irritating panel displayed in Excel - gets in the way

Click on the quick analysis icon again it will disappear. If you never click on that icon. it will never pop up. (see pic with only the quick analysis icon at the left bottom corner of the highlighted area)
Capture.PNG

it also pops up when you hit CTRL so the way I think is most likely that you've been using the keyboard, and when you've done Ctrl-C to copy you've hit Ctrl again when you've been releasing the key, which has caused this. If you press ESC it will disappear as well

Thanks. Yes I can click the QA icon or anywhere else, but it comes up at random....and I don't clcik the QA icon coz it ain't there to start. The panel just pops up and soon as I ctrl c.

yep as I expected, you're a keyboarder like me So it's an errant CTRL popping it

Originally Posted by poundy

it also pops up when you hit CTRL

Right....but only when there is data in the cells (as I've just discovered).

Originally Posted by poundy

so the way I think is most likely that you've been using the keyboard, and when you've done Ctrl-C to copy you've hit Ctrl again when you've been releasing the key, which has caused this.

Yep, that's it....I must be doing a tiny extra ctrl with my left pinky, but only every now and then.

I'd still like to disable it though....

Anyhoo, thanks chaps!

I'm just doing a sheet of ALT keystrokes (been using them for years, but expanding it a bit).

There is one stroke that has me stumped
ALT 39 shows as an apostrophe ' but only when I am "in the cell" (double clicked in).
By equation it is equal to an empty cell, but the ' shows up in the formula bar when the cell is highlighted.

¿QUE?

Apostrophes are used to convert a formula or a value into text. This is why it is only visible when the cell is in the formula bar.

Sent from my SM-G973F using Tapatalk

Thanks for that. So, as expected, when I put two apostrophes into a cell (and ALT 39 is an apostrophe, not a look alike) it shows up as one '.

Excel works in mysterious ways - there are some drop down menus that make the lights dim along our entire street

Just be careful you don't accidentally delete the internet.

Originally Posted by FenceFurniture

Right....but only when there is data in the cells (as I've just discovered).

Yep, that's it....I must be doing a tiny extra ctrl with my left pinky, but only every now and then.

I'd still like to disable it though....

Anyhoo, thanks chaps!

The finger or the key....I'll leave the building now.

FOUND IT!

• Click the File tab and choose Options from the left pane.
• Choose General in the left pane (the default).
• In the User Interface Options section, uncheck the Show Quick Analysis Options On Selection option.
• Click OK.

This does not eliminate the formatting options for text when you select text within the cell (which I REALLY like).

Chris, when you come back to the building, have a look at your Excel 2019 and see if the dickheads have brought back the "tearaway" feature for changing font or cell colours. (you grab the font or cell colour icon and drag it into the cells area - super useful for doing lots of formatting - in fact SO useful that it got deleted.....)