Freeze Excel panes, with AppleScript

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
        set freeze panes of active window to false
    end if

end tell

Posted by Benjamin

Leave a Reply

This site uses Akismet to reduce spam. Learn how your comment data is processed.