How can I paste text without changing the font.

  • Thread starter Thread starter kilowatt
  • Start date Start date
K

kilowatt

Can I post a link or just some text I have cut from the web and have
Excel keep the default font?
 
To paste plain text to Excel you can paste to the formula bar
(one cell) instead of into the cell.

After copying you can select the cell(s) in Excel and then
use Edit, Paste Special values
*or* with a macro you could assign a shortcut Ctrl+SHIFT+V
http://www.mvps.org/dmcritchie/excel/paste.htm#values
If not familiar with installing using macro see
http://www.mvps.org/dmcritchie/excel/getstarted.htm

You can remove formatting after copying by using Steve Miller's
Pure Text -- http://www.stevemiller.net/puretext/
and then pasting to Excel. This is what I use normally because
it works to or from any application, and I can keep my hands
away from the keyboard.
 
David said:
To paste plain text to Excel you can paste to the formula bar
(one cell) instead of into the cell.
Click to expand...

Pasting one cell at a time is enough for me.
Thanks
 
Nice to know which method you choose for immediate use, Thanks.

I left out pasting to notepad, and then copying from notepad into Excel
so now you have five choices.
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

How to paste unformatted text without paste sprecial? 2
Changing color 9
My cut and paste to my web site, converts to text and not visual 3
Prevent format change caused by pasting. (office '97) 1
Conditional Formatting 1
default font in text boxes - Excel 2007 1
=trim 2
Excel 2002 how to change font for entire spreadsheet 2

Back
Top