JJ EXCEL1234
New Member
- Joined
- Jan 30, 2018
- Messages
- 12
I have a spreadsheet with hundreds of rows of data. Each row should contain a hyperlink to that rows specific file in Column B ("PDF"). Currently, Column B has everything formatted as a hyperlink, even if it does not contain a hyperlink.
How do I find which cells under column B are hyperlinked and which are not without hovering over each cell in order to see if there is a hyperlink?
How do I find which cells under column B are hyperlinked and which are not without hovering over each cell in order to see if there is a hyperlink?