Comments in Excel are great for making notes about certain cells so you can keep track of your work. If you’ve added a lot of comments to your worksheets, it can get hard to remember where you put a specific note in a comment.
However, you can search through only the comments in your worksheet or workbook, with this advanced setting.
You can start the search from any cell in your worksheet. Excel will continue to cycle the search through the worksheet and search all the cells. Press Ctrl+F on your keyboard to open the Find and Replace dialog box with the Find tab active. Click “Options”.
To narrow the search to only comments, select “Comments” from the “Look in” drop-down list.
By default, Excel will only search the current worksheet. If you want to search through all the comments on all the worksheets in your workbook, select “Workbook” from the “Within” drop-down list. Click “Find Next” to start the search.
The first cell with a comment attached to it that contains the search term you entered is highlighted. The comment is not automatically shown. However, you don’t have to close the Find and Replace dialog box to view or edit the comment on the selected cell. The Find and Replace dialog box is a non-modal dialog box, which means you can work on the worksheet behind it while the dialog box is still open. If your comments are hidden, move your mouse over the selected cell to view the comment.
If you want to edit the comment, right-click on the cell and select “Edit Comment” from the popup menu.
The comment is shown (if it was hidden) and the cursor is placed within the comment, allowing you to edit it. When you’re finished editing the comment, click in any other cell. Your changes to the comment are saved and the comment is hidden again, if it was previously hidden.
To continue searching through your comments, click “Find Next” again on the Find and Replace dialog box to find the next occurrence of your search term. When you’re finished with your search, click “Close” to close the Find and Replace dialog box.
Google announced on March 22, 2016 that the Chrome App Launcher–which provides quick access to all your offline Chrome apps–will be retired (except in Chrome OS). It’s being phased out over time and will be completely gone in July 2016. There will not be any official replacement for the Chrome App
Windows 10’s “Bash on Ubuntu on Windows” environment contains a few different components. The first time you run the bash.exe program, it will download and install an entire Ubuntu user space environment. You can access these files in File Explorer or other Windows programs, if you know where to
Can you transfer your Windows license between PCs? It depends–the answer isn’t so cut and dried.
Finding viruses or malware on your computer is never a pleasant experience, but why does antivirus software quarantine them instead of completely removing them from your computer? Today’s SuperUser Q&A post has the answers to a curious reader’s question.
Smart outlets are a cheap way to turn your ordinary appliances and fixtures into smart devices. With a smart outlet, you can turn your appliances on and off from your phone, or (in some cases) with your voice through devices like the Amazon Echo. But not every device will work with smart outlets.
Think you know the answer? Click through to see if you're right!
Microsoft Office allows you to add more functionality through add-ins. Many modern add-ins also work with Office for iPad, Office Online, and Office for Mac–not just traditional desktop versions of Office for Windows.
Whether you got them by iMessage or SMS, sometimes you need to remove messages from your iOS device’s message history. Maybe you’re clearing out old clutter, or maybe you need to remove messages with more sensitive information. Whatever your reason, you can remove specific messages from
Evernote is going to be limiting their free plans and increasing the prices of paid plans. If you’ve ever thought about switching to Microsoft’s OneNote instead, now is probably a good time. Thankfully, Microsoft has released an official tool for migrating your Evernote data into OneNote.
Browser extensions extend your web browser with additional features, modify web pages, and integrate your browser with the other services you use. This guide will introduce you to the world of browser extensions and help you get started.