Office Settings & Configuration

Restore Missing Paste Special ScreenTips in Excel 2016

Rana GarciaRana Garcia Nov 20, 2026 869 views

Question details

Restore hover descriptions for Paste Special options in Excel 2016.

Restore Missing Paste Special ScreenTips in Excel 2016
Product
Microsoft Excel 2016
Device & OS
not provided
Scenario
The user wants to identify Paste Special options such as Values, Transpose, and Paste as Picture by hovering over them.
Observed behavior
Descriptions do not appear when the user hovers over Paste Special options.
Before you start

Open Excel 2016 and copy a cell so you can test the Paste menu. Note your current ScreenTip setting before changing it.

Solution 1Recommended

Enable feature descriptions in Excel ScreenTips

Use this setting to restore descriptions when hovering over Paste Special commands.

1
Open Excel Options

In Excel, select File > Options.

2
Find the ScreenTip setting

Select General and locate the ScreenTip style dropdown under User Interface options.

3
Enable descriptions

Choose Show feature descriptions in ScreenTips, then select OK.

4
Test Paste Special

Copy a cell, open the Home > Paste dropdown, and hover over options such as Values or Transpose. Pause briefly to allow the ScreenTip to appear.

Enable feature descriptions in Excel ScreenTips
Free Microsoft Office alternative

Work with spreadsheet paste options in WPS Office

WPS Office is a free, lightweight alternative with a familiar interface for working with spreadsheets. Open compatible Excel files in WPS Spreadsheets for an easy transition; it does not change Excel's ScreenTip settings.

Use spreadsheet paste options in a familiar interfaceOpen and edit Microsoft Excel XLSX and XLS filesMove existing spreadsheets to WPS Office without changing your usual file formatsUse a free, lightweight office suite
microsoft office alternative - wps office

Frequently Asked Questions

Why do Paste Special descriptions disappear in Excel 2016?

Excel may be set not to show feature descriptions. Check File > Options > General > ScreenTip style and select Show feature descriptions in ScreenTips.

How can I test whether ScreenTips are working?

Copy a cell, open the Home > Paste dropdown, and hover over an option such as Values or Transpose. Wait briefly for its description.

What if changing the ScreenTip setting does not help?

On Windows, close Excel and run excel /safe from the Windows+R dialog. If descriptions appear in Safe Mode, review add-ins under File > Options > Add-ins.

Can WPS Office restore ScreenTips in Microsoft Excel?

No. Excel's ScreenTip preference must be changed in Excel. WPS Spreadsheets is an alternative for working with compatible XLSX and XLS files.