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

Posted in Excel | Tagged , , , , , , | 7 Comments

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

Posted in Excel, Powerpoint, Word | Tagged , , , , , , , | Leave a comment

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

Posted in Powerpoint, Word | Tagged , , , , | 1 Comment

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

Posted in Word | Tagged , , | Leave a comment