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.

You can Cut or Copy Paste Columns and Rows in Excel spreadsheet - and keep the formulas and formatting using this step-by-step guide.

Copy Text to Windows Clipboard for Use with Other Applications Open Microsoft Excel and click the Developers tab. Click the Visual Basic icon to open the VBA editor.

Here's how to copy and paste in just a few quick steps, whether you have a Windows or macOS machine, prefer using a keyboard, or would rather just use a mouse.