Needs Pictures: 0
Picture(s) thanks: 0
Results 1 to 12 of 12
-
30th December 2019, 10:45 AM #1
Irritating panel displayed in Excel - gets in the way
G'day
One of these days I'll get back to woodworking posts
In Excel (2016 version, recently updated) I get a option panel displayed irregularly when I do a copy.
Irritating Formatting.JPG
As you might expect, it is almost ALWAYS lands directly over the area that I want to paste to, so I have to click somewhere else to get rid of it. Seems to come up at random too, which is a bit strange for a pgm so exacting as Excel.
I never want to see that panel again in my life, so is there a way to get rid of it (had a look through options, but nothing seems to match).
-
30th December 2019 10:45 AM # ADSGoogle Adsense Advertisement
- Join Date
- Always
- Location
- Advertising world
- Posts
- Many
-
30th December 2019, 11:14 AM #2GOLD MEMBER
- Join Date
- Nov 2012
- Location
- SE Melb
- Age
- 64
- Posts
- 1,278
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
-
30th December 2019, 11:18 AM #3GOLD MEMBER
- Join Date
- Mar 2018
- Location
- Sydney
- Posts
- 1,166
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
-
30th December 2019, 11:18 AM #4
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.
-
30th December 2019, 11:19 AM #5GOLD MEMBER
- Join Date
- Mar 2018
- Location
- Sydney
- Posts
- 1,166
yep as I expected, you're a keyboarder like me So it's an errant CTRL popping it
-
30th December 2019, 11:24 AM #6
-
30th December 2019, 11:36 AM #7
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?
-
30th December 2019, 12:06 PM #8SENIOR MEMBER
- Join Date
- Mar 2018
- Location
- Sydney
- Posts
- 469
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
-
30th December 2019, 12:10 PM #9
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 '.
-
30th December 2019, 01:29 PM #10
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.
-
30th December 2019, 02:15 PM #11GOLD MEMBER
- Join Date
- Jun 2005
- Location
- Helensburgh
- Posts
- 7,696
-
30th December 2019, 02:25 PM #12
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.....)
Similar Threads
-
Want to change raised panel cabinet doors to flat/slab panel.
By Okeroa in forum WOODWORK - GENERALReplies: 11Last Post: 5th December 2015, 05:05 AM -
This is irritating and wasteful
By SAISAY in forum NOTHING AT ALL TO DO WITH WOODWORKReplies: 5Last Post: 8th February 2013, 12:59 PM -
Worst Item displayed in 2011
By adeben in forum WOODWORK - GENERALReplies: 9Last Post: 16th December 2011, 05:10 PM -
Displayed picture size
By Bob38S in forum FORUMS INFO, HELP, DISCUSSION & FEEDBACKReplies: 7Last Post: 28th September 2008, 04:00 PM -
MS excel
By Harry72 in forum COMPUTERSReplies: 4Last Post: 30th July 2008, 12:36 AM