page is in HTML format, which is the default format used by Paste Special. The data should extend down to row 27. After the paste is complete, the Paste Options menu button is displayed at the lower right of the pasted data. Click this menu and select Match Destination Formatting to remove the internal HTML markup from the pasted data.
Fig: 1