However, there is no way to select all items having hyperlinks in one step. In Visio, just clearing the formatting removes the hyperlink. MS Project also has Clear Hyperlinks command like Excel. OneNote requires third-party add-in to do this. PowerPoint has no such menu option nor shortcut. Select entire document and choose CTRL SHIFT F9. Word has no such menu option but does have a shortcut. There is no way to quickly select cells containing hyperlinks. DO NOT choose clear formatting because it will remove formatting for ALL selected cells. There is no way to select only those cells which contain hyperlinks. You have to remove formatting separately. Therefore, you may feel that nothing has happened. The default blue color and underline is NOT removed. Select multiple sheets and select the desired range.