Searching within Excel comments

February 1, 2021

By Kelly L. Williams, CPA, Ph.D., Journal of Accountancy

Q. Is there a way to search for text that is contained within a hidden comment of an Excel spreadsheet?

A. You can search for text that is contained within comments, hidden or unhidden, of an Excel spreadsheet. I have created a workbook with comments added to the three lines of text. You can access the workbook here and accompanying video at the bottom of the page. Note that the content that follows is based on Microsoft Excel 365 for PCs. Other versions of Excel may work differently.

To hide Excel comments on your device, go to File, Options, Advanced. Scroll to the Display section and select No comments, notes, or indicators, as shown in the screenshot below. Click OK. All comments will now be hidden in all Excel workbooks. You can always change this to make the comments visible again.

Continue reading
View all News