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 for Excel demonstrated in Video

Inserting / Deleting and setting height of rows in Excel via AutoHotkey

rows in Excel via AutoHotkeyNext in line of my Microsoft Excel tutorials is this video to demonstrate Inserting, Deleting and setting width of Excel rows via AutoHotkey.

Here is the video walking through manipulating Rows in Excel via AutoHotkey

Inserting / Deleting & adjusting height of Excel Rows with AutoHotkey

Here are the functions to manipulate rows in Excel via AutoHotkey demonstrated in the above video

Merging, Shrinking, and Wrapping cells in Excel with AutoHotkey

Excel with AutoHotkeyThe below video and AutoHotkey functions demonstrate how to connect to an Excel Object and manipulate a range of cells in Excel.  In particular I demonstrate use Excel with AutoHotkey to:

  • Wrap text (have text in cells expand so all words are visible)
  • Shrink to fit (reduce the size of the font so text fits within a given cell at it’s current size)
  • Merge cells (keep content from top-left range but merge the provided cells into one cell)

Merging, Shrinking, and Wrapping cells in Excel with AutoHotkey

Merging, Shrinking, and Wrapping cells in Excel with AutoHotkey

Here are the functions to use Excel with AutoHotkey