Excel兄，小雅怎么找不到对象
天气转凉了，你“脱单”了吗？小雅也扛不住了，早上起床需要勇气了，此时有个暖被窝的人，或许幸福指数会蹭蹭上涨吧。可是找不到对象啊，连Excel也要嘲笑我找不到对象。
你找不到对象有原因，在Excel中也存在“找不到对象”，这又是什么原因呢？原因比较简单：Excel中文本框、图片、插入的各类形状等都属于对象，如果Excel中并不存在对象，当然就会出现“找不到对象”提示框。
下面插入一张小雅的照片，按F5——定位条件——对象，一次性选中Excel中插入的对象。
好了，言归正传，先来解答昨天小伙伴的留言。
询问如何筛选出某个日期之前的数据。
主要就是使用到筛选——自定义筛选——筛选某个日期之前的数据。
询问如何将超级表转换为普通区域。
激活超级表，设计——转换为普通区域。
“不负时光”这位伙伴想学习数据透视表，请观看下面滴答老师的Excel数据透视表视频。
加班费计算
员工加班，每小时加班费为80元。分别计算每个人的加班费，结果在C列。
C2单元格公式为：
=ROUND(HOUR(B2)+MINUTE(B2)/60,2)*80
公式解释：
=ROUND(HOUR(B2)+MINUTE(B2)/60,2)*80
1. hour提取小时数
2. MINUTE(B2)提取分钟数，再除以60，可以把分钟数转为小时数。
3. 小时数+转为后的分钟数得到的数字有小数，通过Round函数保留2位小数
4. 最后，再乘以80元/小时的费用，就可以计算出加班费了。
当然公式写法肯定还会有好几种，小雅就不在罗列了哦。大家可以留言评论晒出您的公式。
88折套餐优惠活动即将结束
责任编辑：
声明：该文观点仅代表作者本人，搜狐号系信息发布平台，搜狐仅提供信息存储空间服务。
今日搜狐热点Add or remove add-ins in Excel - Office Support
Add or remove add-ins in Excel
Applies To:
Excel for Office 365
Excel for Office 365 for Mac
Excel 2016
Excel 2013
Excel 2010
Excel 2007
Excel 2016 for Mac
Add-ins provide optional commands and features for Microsoft Excel. By default, add-ins are not immediately available in Excel, so you must first install and (in some cases) activate these add-ins so that you can use them.
Are you looking for information about Office Add-ins based on HTLM, CSS, and JS? If you are, see .
Some add-ins are built in to Excel, such as Solver and the Analysis ToolPak. Other add-ins are available from the Download Center and must first be downloaded and installed. Finally, there are add-ins that are created by third parties, such as a programmer in your organization or a software solution provider. These can be Component Object Model (COM) add-ins, Visual Basic for Applications (VBA) add-ins, and DLL add-ins. These add-ins must also be installed to use them.
Most add-ins can be categorized into three different types:
These typically include Excel add-in (.xlam), Excel 97-2003 add-in (.xla), or DLL add-in (.xll) files or they are automation add-ins. Some Excel add-ins, such as Solver and the Analysis ToolPak, may be available after you install Excel or Microsoft Office. Typically, you only need to activate these add-ins to use them.
Additional add-ins for Excel can be downloaded and installed from
at Office.com.
Developers and solution providers usually design custom Component Object Model (COM) add-ins, automation add-ins, VBA add-ins, and XLL add-ins. These must be installed for you to use them.
After you have installed or activated an add-in, the add-in and its commands may be available in one of the following locations:
Data tab. After you install and activate the Analysis ToolPak and Solver add-ins, the Data Analysis and Solver commands are available in the Analysis group.
Formulas tab. After you install and activate the Euro Currency Tools, the Euro Conversion and Euro Formatting commands are displayed in the Solutions group.
Add-Ins tab. Other add-ins may be added to the Add-Ins tab. This tab is added to the ribbon when you install and activate the first add-in that is shown in the Add-Ins tab. If you don't see the Add-Ins tab, you should exit and then restart Excel.
Other add-ins, such as the Get Started tab, are available in other places in Excel, such as a tab on the ribbon, or through macros or customized menus.
Important: If you are a software developer, you can use this procedure to install or remove an automation program before you design installation and removal programs for your add-in.
Click the File tab, click Options, and then click the Add-Ins category.
In the Manage box, click Excel Add-ins, and then click Go.
The Add-Ins dialog box appears.
In the Add-Ins available box, select the check box next to the add-in that you want to activate, and then click OK.
If you cannot find the add-in that you want to activate in the Add-Ins available box, you may need to install it.
To install an add-in that is typically installed with Excel, such as Solver or the Analysis ToolPak, run the setup program for Excel or Microsoft Office and choose the Change option to install the add-in. After you restart Excel, the add-in should appear in the Add-Ins available box.
Some Excel add-ins are located on your computer and can be installed or activated by clicking Browse (in the Add-Ins dialog box) to locate the add-in, and then clicking OK.
Some Excel add-ins require running an installation package. You may need to download or copy the installation package to your computer (an installation package is typically a file with an .msi file name extension), and then run it.
Other add-ins that are not available on your computer can be downloaded and installed through a Web browser from
or from other sites on the Internet or a server in your organization. Follow the setup instructions for the download as needed.
Click the File tab, click Options, and then click the Add-Ins category.
In the Manage box, click Excel Add-ins, and then click Go.
In the Add-Ins available box, clear the check box next to the add-in that you want to inactivate, and then click OK.
In many cases, when you inactivate an add-in, it is removed from its group on the ribbon. In other cases, to remove the add-in from the ribbon, you may need to restart Excel.
Inactivating an add-in does not remove the add-in from your computer. To remove the add-in from your computer, you must uninstall it.
Important: If you originally installed the Excel add-in from a network file server or from a shared folder, you might need to remove the add-in from that location. If you installed the Excel add-in from a CD and you mapped your CD drive to a new drive letter after installing the add-in, you need to reinstall the add-in from the CD. If you are running any Excel add-ins from the CD, you must uninstall the Excel add-ins, and then reinstall them from the CD.
Click the File tab, and then click Exit.
In Control Panel, click Programs and Features (Windows 7 and Windows Vista) or Add/Remove Programs (Windows XP).
Do one of the following:
If you installed Excel as part of Microsoft Office, click Microsoft Office in the list of installed programs, and then click the Change button.
If you installed Excel individually, click the name of your program in the list of installed programs, and then click the Change button.
If you installed the add-in from the Download Center, click the name of your program in the list of installed programs, and then click the Uninstall button.
Follow the instructions in the installation program.
Important: If you are a software developer, you can use this procedure to install or remove an automation program before you design installation and removal programs for your add-in. If you are not a developer, you should not need to use this procedure. Contact the system administrator who provided the add-in if you want installation and removal instructions.
Add a COM add-in
Click the File tab, click Options, and then click the Add-Ins category.
In the Manage box, click COM Add-ins, and then click Go.
The COM Add-Ins dialog box appears.
In the Add-Ins available box, select the check box next to the add-in that you want to install, and then click OK.
If the add-in that you want to use is not listed in the Add-Ins available box, click Add, and then locate the add-in.
Remove a COM add-in
Click the File tab, click Options, and then click the Add-Ins category.
In the Manage box, click COM Add-ins, and then click Go.
The COM Add-Ins dialog box appears.
In the Add-Ins available box, clear the check box next to the add-in that you want to remove, and then click OK.
This removes the add-in from memory but keeps its name in the list of available add-ins. It does not delete the add-in from your computer.
To remove a COM add-in from the list of available add-ins and to delete the add-in from your computer, click its name in the Add-ins available box, and then click Remove.
Note: If you are a software developer, you can use this procedure to install or remove an automation program before you design installation and removal programs for your add-in. If you are not a developer, you should not need to use this procedure. Contact the system administrator who provided the add-in if you want installation and removal instructions.
Click the File tab, click Options, and then click the Add-Ins category.
In the Manage box, click Excel Add-ins, and then click Go.
The Add-Ins dialog box appears.
To install an automation add-in, in the Automation servers available box, click Automation, and then click the add-in that you want.
If the add-in that you want isn't in the list, click Browse, locate the add-in, and then click OK.
To remove an automation add-in, you must remove it from the registry. See your system administrator for details.
Some add-ins are built in to Excel, such as Solver and the Analysis ToolPak. Other add-ins are available from the Download Center and must first be downloaded and installed. Finally, there are add-ins that are created by third parties, such as a programmer in your organization or a software solution provider. These can be Component Object Model (COM) add-ins, Visual Basic for Applications (VBA) add-ins, and DLL add-ins. These add-ins must also be installed to use them.
Most add-ins can be categorized into three different types:
These typically include Excel add-in (.xlam), Excel 97-2003 add-in (.xla), or DLL add-in (.xll) files or they are automation add-ins. Some Excel add-ins, such as Solver and the Analysis ToolPak, may be available after you install Excel or Microsoft Office. Typically, you only need to activate these add-ins to use them.
Additional add-ins for Excel can be downloaded and installed from
at Office.com.
Developers and solution providers usually design custom Component Object Model (COM) add-ins, automation add-ins, VBA add-ins, and XLL add-ins. These must be installed for you to use them.
After you have installed or activated an add-in, the add-in and its commands may be available in one of the following locations:
Data tab. After you install and activate the Analysis ToolPak and Solver add-ins, the Data Analysis and Solver commands are available in the Data tab on the ribbon.
Home tab. Other add-ins may be added to the Home tab.
Other add-ins, such as the Get Started tab, are available in other places in Excel, such as a tab on the ribbon, or through macros or customized menus.
Important: If you are a software developer, you can use this procedure to install or remove an automation program before you design installation and removal programs for your add-in.
On the Tools menu, select Add-ins.
In the Add-Ins available box, select the check box for the Add-in you want to activate, and then click OK.
Some Excel add-ins are located on your computer and can be installed or activated by clicking Browse (in the Add-Ins dialog box above) to locate the add-in, and then clicking OK.
Some Excel add-ins require running an installation package. You may need to download or copy the installation package to your computer (an installation package is typically a file with an .msi file name extension), and then run it.
Other add-ins that are not available on your computer can be downloaded and installed through a Web browser from
or from other sites on the Internet, a server in your organization, , or using the built-in Store option in Excel. Follow the setup instructions for the download as needed.
To install Add-ins from the Store
Click the Insert tab in the ribbon.
Click the Store button.
Use the Categories or Search field to find Add-ins.
Click Add to install the Add-in.
Note: Some Add-ins need to be purchased.
Click the Insert tab, and then click My Add-ins.
In Office Add-ins, click the 3 dots menu next to the Add-in.
Click Remove.
Read the notice that appears regarding other devices and click Remove.excel表格中的一个表格突然不见了，怎么恢复？_百度知道
excel表格中的一个表格突然不见了，怎么恢复？
如图中的3号楼-房态，突然不见了。求高手解答。谢谢
我有更好的答案
　　EXCEL中某些工作表标签不见，有以下几种可能：右击任一工作表标签，如果“取消隐藏”呈高亮显示，并非灰色不可操作，那就是隐藏了，点击“取消隐藏”即可；水平滚动条移动得太靠左侧工作表标签了，导致工作表标签不能全部显示，按住滚动条左侧的竖线条，向右移动即可；工作表标签太多，导致不能完全显示出来，此时可利用工作表标签左侧的快速切换按钮，切换到需要的工作表标签。
采纳率：75%
来自团队：
3号楼-房态的标签还在就没不了按CTRL+向上方向键让光标置顶看一下行列号是不是全，如不全即是隐藏，在不全处取两边的行号或列标点鼠标右键一取消隐藏。3号楼-房态的标签不在了，点最上面的菜单一格式一工作表一取消隐藏如果都没有了可能是误操作删除了，不好恢复了，用专业软件试试吧
本回答被网友采纳
是不是隐藏了工作表, 在任何一个工作表名点右键, 再点击取消隐藏, 选取要取消隐藏的工作表即可.
估计是隐藏了
其他1条回答
为您推荐：
其他类似问题
酱香型白酒的相关知识
换一换
回答问题，赢新手礼包
个人、企业类
违法有害信息,请在下方选择后提交
色情、暴力
我们会通过消息、邮箱等方式尽快将举报结果通知您。这种情况是U盘文件被隐藏了，找出隐藏文件的方法：
此法利用了attrib命令（来源于attribute ：特征，属性），强制修改文件夹的属性，以达到显示隐藏文件夹的功能。
以恢复G盘“我的图片”文件夹为例：点击“开始”按钮，在运行中输入cmd，启动MS-DOS窗口 输入命令：attrib G:"我的图片" -s -h -r回车后，看看U盘里，”我的图片“就又出现了。
如果要显示G盘里所有文件，可输入：attrib G:"*" -s -h -r /s /dattrib语法释义：+r 设置只读文件属性。-r 清除只读文件属性。+a 设置存档属性。-a 清除存档属性。+s 设置系统文件属性。-s 清除系统文件属性。+h 设置隐藏文件属性。-h 清除隐藏文件属性。/s 将attrib和任意命令行选项应用到当前目录及其所有子目录中的匹配文件。/d 将 attrib 和任意命令行选项应用到目录。/在命令提示符下显示帮助。
介绍一种几乎尽人皆知的最简单办法。
新手必知，这种方法只可以简单还原隐藏文件，遇到“顽固”症状请使用方法一打开U盘，点击左上角菜单栏里的“组织”按钮（win7）
点击“文件夹和搜索选项”，点击“查看”选项页找到“显示隐藏的文件、文件夹、驱动器”选项，打钩即可。
如果这2种方法都没法解决，那大家只能求助专业软件了。excel 找不到对象怎么解决_百度知道
excel 找不到对象怎么解决
弄表格的时候出现这个，请大师给看看，怎么解决呀，跪求
弄表格的时候，用的F5定位，然后显示的这个方块，一个朋友教我的，下面是他的原话全选没有用过行F5，定位条件，对像删除然后再全选一次，delete列也一样
我有更好的答案
你要删除什么？这样说明没有你要定位的东西
以前是这个方块，就是为了解决这个问题，您能帮我解决这个问题吗
把你这个数据给为（)你这样看不清楚
采纳率：43%
什么你表格没有对象…………
为您推荐：
其他类似问题
您可能关注的内容
换一换
回答问题，赢新手礼包
个人、企业类
违法有害信息,请在下方选择后提交
色情、暴力
我们会通过消息、邮箱等方式尽快将举报结果通知您。