Paste plain text- Use AutoHotKey to strip RTF/HTML formatting

Paste plain text

I (like everyone else in the world) frequently copy-paste between various programs. While some programs like Word and Excel allow for paste plain text, a lot do not.

Paste plain text

I wrote a small script in AutoHotKey which takes the contents of the clipboard and strips it of HTML/RTF format. This way it allows me to paste as plain text in any program by hitting a key combination (Control+G).  What’s great is that I don’t actually lose the original format so, if I decide I actually wanted the original content, I can still just paste with Control+V and I’m good to go!

Paste plain text- Use AutoHotKey to strip formatting

Below is the actual code for doing the above in AutoHotKey.

 

Keyboard shortcuts for launching programs- Start any program with 1 click

keyboard shortcuts

Keyboard shortcuts

Keyboard shortcuts can be a great time saver (especially for specific programs, folders, actions) that you do dozens of times a day.

 

Over a decade ago I put the below file together documenting the most frequently used Windows / Office shortcuts

keyboard shortcuts

MS word file great keyboard shortcuts

 

Now-a-days AutoHotKey to create my own shortcuts (of which I have over 100 which do various activities by a simple click of the key/button.)  AutoHotKey has a function for this called Hotkeys which are a great way to launch programs / scripts /folders that you use frequently.

This video walks through how easy it is to set up hotkeys to launch programs, scripts, etc.

Hotkeys with AutoHotKey

 

select multiple items on a form (in mass)

select multiple items

In order to speed-up our page load times I like to archive items to an old folder.  Unfortunately there is no easy way to select some, but not all, items.   What I really wanted to do is automate select multiple items from a list.

Web scraping with AutoHotKey to the rescue!!! This simple looper is fast, flexible and a life saver. It simply sends tabs and the space key to my browser window saving me a lot of time and mundane work.  Below is the AutoHotKey code which is set to work in Chrome

And here is a video in case you’re not getting the value.

Select multiple items from a list

Selecting / Deselecting items on a form (in mass)

Easily update Excel graphs; AutoHotKey saved me 100’s of repetitive clicks

Easily update Excel graphs

Easily update Excel graphs

In market research I used to spend a lot of time making sure my charts and graphs were beautiful visualizations that conveyed the data in an easy to understandable way.

I always wanted to make complete use of the range of the graph and would have to, manually, update each one.  I finally learned some object oriented programming and wrote an script in AutoHotKey to easily change the axis on scales in and easily update Excel graphs.  The below video demonstrates how I can just hit a key combo and scroll up/down to adjust the scale.

Tweaking Graphs in Excel