Forcing a font throughout

M

mattslav

When I paste text from another source into my worksheet, it does no
take on the font of the rest of the sheet. I have highlighted th
entire sheet, by clicking the square between the "A" and "1", an
applied the font I want through Format Cells, but that doesn't seem t
work. How can I make outside text automatically take on the font of th
rest of the sheet
 
D

Dave Peterson

What happens when you Paste Special|Text?

(Or if it's just going into one cell, pasting directly into the formula bar.)
 
M

mattslav

It says the text is in HTML format. Is there a way to say that I always
want to paste in plain text?
 
D

Dave Peterson

Maybe opening Notepad and then pasting there first.

Then copy from there and paste into excel???
 
Top