WTH!?! Why can't I paste values? I'm copying data from a webpage that contains links, colors, columns separated by gaps and when I go into Excel to paste ONLY the values, it wont let me. When I try to paste special - plain text, instead of keeping the formatting of rows and columns, it puts it all into one column with the data on different rows. This does me no good. Whats the problem here?