This tutorial provides the detailed guidance on how to do this in Excel 2016, 2013, 2010 and earlier versions. In addition, you can insert a hyperlink to go to another cell, sheet or workbook, to open a new Excel file or create an email message. In your Excel worksheets, you can easily create such links too. Hyperlinks are widely used on the Internet to navigate between web-sites. You will learn how to insert, change and remove hyperlinks in your worksheets and now to fix non-working links. You can then click the OK button at the bottom of the window to save your changes.ĭo you have trouble getting your spreadsheets to print well? Read our Excel printing tips to see some of the more useful options that can make it easier to print your data.The tutorial explains how to hyperlink in Excel by using 3 different methods. if you wish to disable ScreenTips in Excel, then select the Don’t show ScreenTips option. Step 4: Click the General tab at the left side of the Excel Options window, then click the drop-down menu to the right of ScreenTip Style and choose your desired setting. Step 3: Click the Options button at the bottom of the column on the left side of the window. Step 2: Click the File tab at the top-left corner of the window.
But if you would prefer one of the different options shown above, then you can select that option instead. Our guide will be primarily focused on turning off the ScreenTips in Excel, which will remove any of the information that displays when you hover over a button. The second ScreenTips option will display the information without the descriptions, as in the image below: The first option, and likely the one that is currently set on your computer, will show ScreenTips with descriptions. There are actually three different ScreenTips options from which you can select in Excel 2013. We will show you how to find and stop the ScreenTips from appearing in Excel in our guide below. Fortunately you can turn off ScreenTips in Excel 2013 by adjusting an option on the Excel Options window.
While these are generally useful, you might find that they are getting in the way of something that you need to do or look at. These pop-up descriptions are called ScreenTips, and they can either be simple, where they only display the name of the object, or they can be enhanced, where they display a description as well. Excel 2013 can provide you with additional information about some of the buttons and features in the program when you hover over them.