The pasted text will retain the formatting from the website. To paste plain text instead, first paste it into Notepad or a similar text editor, then copy and paste it again into Excel.

Use Excel's Paste Special feature to calculate multiple values against a data range, at the same time. You can make the process even more efficient with keyboard shortcut combinations.

However, this pastes everything, including the values, the formatting, and any comments or notes. Excel lets you choose more specifically which elements you want to paste into the selected cell.