How to paste text to multiple columns in Excel

Learn Microsoft Excel: Smart Paste: Pasting text into different Excel cells can be done by making use of the TAB key in the text editor. Pressing Tab represents a new cell in Excel when pasting the contents into Microsoft Excel. To create a four column layout in Excel one would simply write down the name of the first column, press tab, write down the name of the second column, press tab and so on.