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.

When pasting the data into other applications, such as Notepad, tabular data will retain its columns to make it easier to view the data you copied. You can also paste tabular data directly into ...