• Excel 工作表表名鼠标右键不能用 Mouse right click not working in Excel sheets


    Excel 工作表表名鼠标右键不能用

    Mouse right click not working in Excel sheets

    解决方法: 

    1. Please look into C:\Users\User_Name\AppData\Roaming\Microsoft\Excel (replace user name with your user name, you can directly reach here by copy and pasting following without quotes in Explorer address bar - "%appdata%\Microsoft\Excel") and see if is contains few files / folders. Move those files to some other location (i.e create a backup of those files / folders and delete all files / folders from here). Hence, make Excel folder blank.

    Now open Excel and see if the problem disappears or not.

    其实就是删掉 "%appdata%\Microsoft\Excel" 目录下的所有文件(删掉前记得备份一下到其他地方),然后再重新打开 Excel 看看是否恢复正常,如果正常,下面的可以不用看了。

    Note - If the above path is not applicable for your installation, you need to find XLSTART path. Excel folder contains XLSTART folder in itself (In case, your XLSTART path is not in Appdata)
    Open Excel > ALT+F11 > If Immediate Window is not visible, type CTRL+G. Same can be also be accessed through View > Immediate Window > Type "? application.StartupPath" without quotes and press enter > You will have your path below.

    2. Sometimes, add-ins can cause problems. To determine, if add-in is a problem start your application in safe mode and see if problem has gone away.

    To start in Safe Mode -

    Hold CTRL key and click on application icon and don't release the CTRL key till it asks you for Safe mode confirmation.

    If yes, then start application normally and disable add-ins one by one and start application again every time you disable an add-in to determine the culprit add-in.
    To disable add-in > File > Options > Add-ins > Down below you have Manage: Com Add-in : Press Go > Untick the Add-ins to disable and tick to enable them

    3. Try repairing your office installation. First try Quick Repair (takes 5 - 10 mins) , if that doesn't help then try Online Repair (Takes more than 30 mins but less than 1 hour in general)
    https://support.microsoft.com/en-us/office/repair-an-office-application-7821d4b6-7c1d-4205-aa0e-a6b40c5bb88b?ui=en-us&rs=en-us&ad=us 

    参考: 

    https://answers.microsoft.com/en-us/msoffice/forum/all/mouse-right-click-not-working-in-excel-sheets/74f65a2c-4a2b-4fc0-b29c-69c4d258a3a1

  • 相关阅读:
    搜狗输入法弹出广告
    PHP uploadify io error错误如何解决?
    读写生信流程必备的 Perl 语法
    Illumina Sequence Identifiers 序列标识符 index详解
    真核生物基因结构 & mRNA结构
    主成分分析(PCA)原理及R语言实现 | 降维dimension reduction | Principal component analysis
    CRISPR基因编辑
    表观遗传学
    Shiny+SQLite打造轻量级网页应用
    探索gff/gtf格式
  • 原文地址:https://www.cnblogs.com/ling3blog/p/16385623.html
Copyright © 2020-2023  润新知