Windows 7 Forums

Welcome to Windows 7 Forums. Our forum is dedicated to helping you find support and solutions for any problems regarding your Windows 7 PC be it Dell, HP, Acer, Asus or a custom build. We also provide an extensive Windows 7 tutorial section that covers a wide range of tips and tricks.


Windows 7: Show mini toolbar on selection

22 Jun 2014   #1
Franky

windows 7 32-bit
 
 
Show mini toolbar on selection

Hi all,

I'm using Excel 2010 on Win 7. In Options > General, there is a check box named "Show mini toolbar on selection". What happens if I uncheck that please?


My System SpecsSystem Spec
.
22 Jun 2014   #2
soho1

Win 7 Pro 64-bit
 
 

Turns off that cute and handy little formatting bar.

See also: Working with the Excel 2010 Mini Toolbar - For Dummies
My System SpecsSystem Spec
22 Jun 2014   #3
Franky

windows 7 32-bit
 
 

OK. I cleared that check box but still when I right click on a cell or press F2 to edit a text cell and right click, in both cases the mini toolbar again appears! Why?
My System SpecsSystem Spec
.

22 Jun 2014   #4
Franky

windows 7 32-bit
 
 

No continued help!?
My System SpecsSystem Spec
22 Jun 2014   #5
Ranger4

Windows 7 Home Premium 64 bit sp1
 
 

The website that soho1 in Post #2 has a method of removing the "Mini Tool bar", but you need to do it for each cell you are working on. I have checked it in Excel 2013 & it certainly works.

The quote from the website, where it shows a target & arrow, is just below the spreadsheet image.

"Press Esc at any time to remove the mini toolbar and shortcut menu. If you have already made a selection from the mini toolbar, move the mouse pointer away from the mini toolbar or select another cell to make it disappear."
My System SpecsSystem Spec
23 Jun 2014   #6
Franky

windows 7 32-bit
 
 

@Ranger4:
Thanks for the response.

There is a small misunderstanding!
Look, at the beginning of the thread I said that subject, that, in Options > General, there is a check box named "Show mini toolbar on selection". I'm talking about this.

Anyway, even if I select a target cell and uncheck that option (from the above path) for it, still when I edit that cell the mini toolbar appears when right clicking on it!

Let me ask the problem as simple as possible:
What is the difference when that option is checked and when that is not checked, in effect? Or what should happen we we uncheck that option?
My System SpecsSystem Spec
23 Jun 2014   #7
Lady Fitzgerald

Win 7 Ultimate 64 bit
 
 

Quote   Quote: Originally Posted by soho1 View Post
Turns off that cute and handy little formatting bar.

See also: Working with the Excel 2010 Mini Toolbar - For Dummies
You mean that annoying and intrusive little formatting bar?
My System SpecsSystem Spec
23 Jun 2014   #8
Ranger4

Windows 7 Home Premium 64 bit sp1
 
 

Quote   Quote: Originally Posted by Kurdman View Post
@Ranger4:
Thanks for the response.

There is a small misunderstanding!
Look, at the beginning of the thread I said that subject, that, in Options > General, there is a check box named "Show mini toolbar on selection". I'm talking about this.

Anyway, even if I select a target cell and uncheck that option (from the above path) for it, still when I edit that cell the mini toolbar appears when right clicking on it!

Let me ask the problem as simple as possible:
What is the difference when that option is checked and when that is not checked, in effect? Or what should happen we we uncheck that option?
I have tried to stop the Mini Toolbar from showing on right click in Excel 2013, but even with all the option unchecked it still shows, even with a new spreadsheet.
So it does seem that you are correct, so the only work around seems to be to use the "Esc" key to temporarily remove it for each cell you are working on.
Perhaps it's a bug in Excel, but I can't offer any more help. Perhaps someone else may have a solution.
My System SpecsSystem Spec
24 Jun 2014   #9
Franky

windows 7 32-bit
 
 

Quote   Quote: Originally Posted by Ranger4 View Post
Quote   Quote: Originally Posted by Kurdman View Post
@Ranger4:
Thanks for the response.

There is a small misunderstanding!
Look, at the beginning of the thread I said that subject, that, in Options > General, there is a check box named "Show mini toolbar on selection". I'm talking about this.

Anyway, even if I select a target cell and uncheck that option (from the above path) for it, still when I edit that cell the mini toolbar appears when right clicking on it!

Let me ask the problem as simple as possible:
What is the difference when that option is checked and when that is not checked, in effect? Or what should happen we we uncheck that option?
I have tried to stop the Mini Toolbar from showing on right click in Excel 2013, but even with all the option unchecked it still shows, even with a new spreadsheet.
So it does seem that you are correct, so the only work around seems to be to use the "Esc" key to temporarily remove it for each cell you are working on.
Perhaps it's a bug in Excel, but I can't offer any more help. Perhaps someone else may have a solution.
Thank you. You did the help that you would want.
The below is the answer.
Show mini toolbar on selection
My System SpecsSystem Spec
25 Jun 2014   #10
soho1

Win 7 Pro 64-bit
 
 

So, I believe the recap is, you cannot turn it off of the right-click, as it appears to float over the menu, however, it DOES turn off when selecting cell contents (left to right or right to left or double click) and should stay persistent in behavior each time you open excel, which can be verified when the checkbox remains OFF in File > Options > General tab.
My System SpecsSystem Spec
Reply

 Show mini toolbar on selection




Thread Tools Search this Thread
Search this Thread:

Advanced Search




Similar help and support threads
Thread Forum
Google toolbar won't show in pinned websites
Hi all - new to Windows 7 and coming up to speed. I have downloaded Google toolbar for use in IE and having a problem. When I launch IE by opening the actual IE icon, I can see the Google toolbar. Further, while this instance of IE is open, I can right click on IE toolbar area to see what...
Browsers & Mail
Virtualbox 4.2.14 - Linux guest - No mini toolbar in fullscreen mode
Windows 7 64 bit host Linux guests Ubuntu 13.04, Linux Mint 14 & 15, both 32 bit and 64 bit for all I recently had to update my video driver for my AMD Radeon 6670 (driver version 13.4, release date 2013-5-29). After updating, my linux guests will not display the mini toolbar in fullscreen...
Virtualization
How do I delete a shotcut from yahoo toolbar that does not show up on
How do I delete a shotcut from yahoo toolbar that does not show up on my toolbar apps? I recently bought an item from Amazon and a couple of days later the shortcut for Amazon was in my toolbar which I did not put there. And as i say it does not show up on my toll bar apps. ...
Browsers & Mail
Firefox tabs show up as indavidual windows on toolbar
When i pass over the icon of firefox on my toolbar at the bottom of the screen( unsure of its real name but the bar with the time and start icon) each and every tab shows up separately. just today i repartitioned my hardrive, and before the reinstall it only showed whatever windows were open, no...
Browsers & Mail
Show Translucent Selection Rectangle
How to Turn On or Off "Translucent Selection Rectangle" in Vista, Windows 7, and Windows 8 The selection rectangle is what you see when you left click and hold, then drag the mouse pointer over items to select them when you release the left click. This will show you how to turn the...
Tutorials
Most folders show a mini preview file, but some dont?
Ok most of my folders when set to large icons show a little file or picture or whatever if there is something inside of the folder. But I have a couple of folders that arent showing any mini preview but have something in them? Any ideas?
General Discussion


Our Sites

Site Links

About Us

Find Us

Windows 7 Forums is an independent web site and has not been authorized, sponsored, or otherwise approved by Microsoft Corporation. "Windows 7" and related materials are trademarks of Microsoft Corp.

Designer Media Ltd

All times are GMT -5. The time now is 05:49.

Twitter Facebook Google+



Windows 7 Forums

Seven Forums Android App Seven Forums IOS App