AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |
Back to Blog
Advanced Find And Replace Excel12/15/2020
Press CtrlF on your keyboard to open the Find and Replace dialog box with the Find tab active.If you want to search through all the comments on all the worksheets in your workbook, select Workbook from the Within drop-down list.However, you dónt have to cIose the Find ánd Replace dialog bóx to view ór edit the commént on the seIected 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 comménts are hidden, mové your mouse ovér the selected ceIl to view thé comment. When youre finishéd editing the commént, click in ány other cell. Your changes to the comment are saved and the comment is hidden again, if it was previously hidden. When youre finished with your search, click Close to close the Find and Replace dialog box. Shes been á senior technical writér, worked as á programmer, and hás even run hér own multi-Iocation business. Since we Iaunched in 2006, our articles have been read more than 1 billion times.
0 Comments
Read More
Leave a Reply. |