Browsing large dataset in Excel can be tricky sometimes, as one almost always wants to refer to row and column names. Excel provides a feature for this, called “freeze panes”, but the interface is not practical at all (Microsoft…). Here is a handy AppleScript to activate/deactivate on-the-go this feature. Just select the cell from which you want to freeze the panes, and run the script [I would suggest, from Alfred 🙂 ].
tell application "Microsoft Excel"
if freeze panes of active window is false then
set freeze panes of active window to true
else
set freeze panes of active window to false
end if
end tell
