Set Excel Font type and format with AutoHotkey

Automatically Set Excel Font type, size, emphasis with AutoHotkeySet Excel Font

Excel files are a go-to standard form many business people.  Often people will export a file from their “tool” and then spend time making it “pretty” by adjusting font size, type, cell color, formatting, etc.  When I do this, I automate the re-doing of applying formatting over and over which greatly streamlines the process and makes things more consistent.

Tutorial how to use the below AutoHotkey functions

Excel & AutoHotkey-Font type, size, and formatting

The following AutoHotkey functions are demonstrated in the below above video.  They make it a breeze to update settings in a given Excel range.

AutoHotkey functions to Set Excel Font type, Size and format

 

Setting Number format of Excel with AutoHotkey

Excel with AutoHotkeyThis short video demonstrates the below AutoHotkey function that allows you to easily set the number format.

Video demonstrating setting Number format in Excel with AutoHotkey

Use AutoHotkey to set Number format of Excel cell

Here is the function reviewed in the video and the example function calls.  Make sure you include the function of getting a pointer to the current Excel object so you can manipulate Excel with AutoHotkey.

Freeze panes in Excel, Toggle screen update and MRU list via AutoHotkey

This video coverFreeze panes in Excels how to Freeze panes in Excel, Toggle screen updating (which can drastically speed-up your script) and inject a file name int the MRU (Most Recently Used) list of files.

This video walks through how to use the below AutoHotkey functions.  Be sure you check out how to get a handle to Excel which is covered in this video.

Freeze panes in Excel, Toggle screen updates & insert file into MRU

Frezing panes, Toggling screen update and MRU List in Excel via AutoHotkey

AutoHotkey code demonstrated in Video