Home |
Search |
Today's Posts |
#12
![]()
Posted to microsoft.public.excel.newusers
|
|||
|
|||
![]()
Great - something else I have to put into my Favorites list! For the record:
your workbook with all the icons for Command Bar Face IDs has just been a goldmine for me. "Ron de Bruin" wrote: I add a new page on my site today that explain how you can change the image of the button. http://www.rondebruin.nl/imageqat.htm -- Regards Ron de Bruin http://www.rondebruin.nl/tips.htm "Ron de Bruin" wrote in message ... You can also add the PasteSpecial values button to the QAT to do it with one click Click on the arrow on the Paste button on the Home tab and then right click on "Paste Values" and choose add to QAT -- Regards Ron de Bruin http://www.rondebruin.nl/tips.htm "Vernon Balbert" wrote in message ... I'm copying data from a web site to an Excel 2007 worksheet. Specifically, I'm creating a database of my DVDs and using IMDB as a source of information, specifically the release date of the movie. Right now I'm copying the date from the web page, right-clicking on the appropriate cell and selecting Paste Special and then selecting Text. This is getting to be too repetitive to be convenient. Is there a keyboard shortcut to do this? I'd love to just hit Ctrl-V (or something similar) to paste it as plain text with no HTML codes or formatting. -- "Pinky, are you pondering what I'm pondering?" "I think so, Brain. But what if the Earl of Essex doesn't like burlap pantaloons?" |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Excell 2007 Paste Special Formatting | Excel Discussion (Misc queries) | |||
Special paste column widths is not coming up in Excel 2007? | Excel Discussion (Misc queries) | |||
missing text when using paste special from word to excel | Excel Discussion (Misc queries) | |||
Paste Special as Text | Excel Discussion (Misc queries) | |||
excel paste special should allow text | Excel Worksheet Functions |