Tag Archives: paste special
Excel: quick and easy 10 alarm industrial dashboard
This is so easy… that even a 15 year old can build it. And it is all in Excel, without macros. Building this dashboard requires: naming some ranges, conditional formatting, paste special / paste as hyperlinks, a nice floor plan … Continue reading
MS Office: add the Format Painter button to the QAT
Part 1: Saves a lot of time: Add the Format Painter button to your quick access toolbar (if you don’t know how to customize the QAT, click here) The format painter is in a handy place in the Home ribbon, … Continue reading
Powerpoint, Word : paste special as PNG, GIF, or JPG and not bitmap or WMF
It is amazing how many people paste huge pictures in Powerpoint (or Word) and then save the file, and, oh surprise, the file is monster big! Examples of objects that could be VERY BIG: people pasting spreadsheets, maps, objects copied … Continue reading
Word : change the Paste Special default to “Text Only”
Word’s paste special feature retains the source formatting. If you’re pasting from foreign sources (for example, you copy text from a web page), you probably reformat it once it’s in your Word document. If you do this a lot, change … Continue reading