how to copy and paste multiple hyperlinks in excel?
['Select the information to be copied and press Ctrl+C. ... ', 'Switch to Excel and select the cell where you want the link to appear.', 'Click the down-arrow under the Paste option on the Home tab of the ribbon and then click Paste Special. ... ', 'Choose Hyperlink from the list of options. ... ', 'Click OK.']