This month’s column walks you through all the special ways you can paste text, data, and even application capabilities in Excel.

To copy only the conditional formatting, move your mouse over Paste Special, then choose Paste Special from the new menu that appears. Click the radio button next to Formats and click OK.

Format Painter applies the same formatting to multiple text or objects. Learn how to use Format Painter in Word, PowerPoint, and Excel.

Microsoft's spreadsheet program can do way more than you might realize. These are the hacks and tricks you need to know.

Then use the Ctrl+V command to paste the text into a cell of your choosing in your Excel spreadsheet. The pasted text will retain the formatting from the website.

You can follow any one of these methods below to convert numbers stored as text to numbers in Microsoft Excel: Using the Text to column button Using Value function Changing the format Use Paste ...