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

Insert / Delete columns in Excel via AutoHotkey

Columns in Excel via AutoHotkeyThis post continues to build on using AutoHotkey via COM to manipulate Excel.  This time I demonstrate how easy it is to use an AutoHotkey function to insert columns, delete columns and set column widths.  All of which are utilizing a simple function after connecting to Excel via AutoHotkey and COM.

Here’s the video demonstrating how to manipulate columns in Excel via AutoHotkey.

Inserting / Deleting columns & setting widths in Excel with AutoHotkey

Here is the code where I demonstrate in the above video how to manipulate columns in Excel via AutoHotkey.  Make sure you connect to the Excel object before calling the functions!

Simplify writing AutoHotkey code using the Macro recorder & Excel constants

Macro recorder & Excel constantsUsing the Macro recorder & Excel constants is a great way to obtain VBA code which is easily translated/tweaked to AutoHotkey syntax!

A lot of the time when I’m working on an AutoHotkey Script I can find great examples on the AutoHotkey Forum or Stack Overflow however sometimes I’m unable to find a similar example.  The below video demonstrates how you can use the Macro Recorder in Excel to help write your AutoHotkey syntax.  One very critical point you’ll need to remember is to “look up” the constant value by right clicking on it in the VBA mode and listing the “quick info”.

In addition to the 1,500+ constants in  this file, you can review this site which lists many of the constants

Video demonstrating the Macro recorder & Excel constants in Excel

Use Excel macro recorder to get constants from Excel for AutoHotkey