Can I post a link or just some text I have cut from the web and have
Excel keep the default font?
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.
---
HTH, (that give you four methods)
David McRitchie, Microsoft MVP - Excel [site changed Nov. 2001]
My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm
Search Page: http://www.mvps.org/dmcritchie/excel/search.htm
<[email protected]> wrote in message ...
> Can I post a link or just some text I have cut from the web and have
> Excel keep the default font?
>
David McRitchie wrote:
> To paste plain text to Excel you can paste to the formula bar
> (one cell) instead of into the cell.
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.
<[email protected]> wrote in message
> Pasting one cell at a time is enough for me.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks