[Last Call] Learn how to a build a cloud-first strategyRegister Now

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 3544
  • Last Modified:

Switch off tooltips in Excel

Does anyone know how to switch off tooltips in Excel? Although they can be helpful when highlighting data it can obstruct rows below:-
Tooltip
I've read a few forums which suggest that you can setup a hyperlink or comment to null which switches it off, however doesnt seem to work.

Any suggestions?

Thank you
0
tonelm54
Asked:
tonelm54
  • 2
2 Solutions
 
contactkarthiCommented:
Show or hide ToolTips

From the Tools menu, choose Options.
Select the General tab sheet.
Do one of the following:
To display ToolTips, check the Show ToolTips box.
To hide ToolTips, clear the Show ToolTips box.
0
 
EirmanCommented:
It would appear that the only type of tooltips that CANNOT be turned off, are those on the ribbon.

http://answers.microsoft.com/en-us/mac/forum/macoffice2011-macexcel/how-to-disable-tooltips/cd08c858-c10f-49fc-8ff3-cdde35b34ae5
0
 
contactkarthiCommented:
the one i gave above is for menu tooltips.. the one you are asking about is paste options.. see below



How to prevent options from appearing

To prevent the paste options, the auto fill options, and theinsert options from appearing, follow these steps, as appropriate for the version of Excel that you are running.


Microsoft Office Excel 2007

Click the Microsoft Office Button, and then click Excel Options.
Click Advanced.
Under Cut, copy, and paste, use one or both of the following procedures:
To turn off Paste Options and Auto Fill Options, click to clear the Show Paste Options buttons check box.
To turn off Insert Options, click to clear the Show Insert Options buttons check box.
Click OK.


Microsoft Office Excel 2003 and earlier versions of Excel

On the Tools menu, click Options.
Click the Edit tab.
Use one or both of the following procedures:
To turn off Paste Options and Auto Fill Options, click to clear the Show Paste Options buttons check box.
To turn off Insert Options, click to clear the Show Insert Options buttons check box.
0

Featured Post

VIDEO: THE CONCERTO CLOUD FOR HEALTHCARE

Modern healthcare requires a modern cloud. View this brief video to understand how the Concerto Cloud for Healthcare can help your organization.

  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now