You can make a difference in the Apple Support Community!
When you sign up with your Apple Account, you can provide valuable feedback to other community members by upvoting helpful replies and User Tips.
When you sign up with your Apple Account, you can provide valuable feedback to other community members by upvoting helpful replies and User Tips.
Is there a way to write an AppleScript that I can run each time I open a Numbers file so that I can quickly freeze Header Row 1 and Header Column 3? I have to do this repeatedly, so I'd like a way to automate it. Thanks!
iMac (M1, 2021)
You asked to freeze so these two additional commands should do the trick. I just noticed that when opening a CSV the headers are not automatically frozen.
tell application "Numbers"
tell table 1 of sheet 1 of front document
set header row count to 1
set header rows frozen to true
set header column count to 3
set header columns frozen to true
end tell
end tell
You asked to freeze so these two additional commands should do the trick. I just noticed that when opening a CSV the headers are not automatically frozen.
tell application "Numbers"
tell table 1 of sheet 1 of front document
set header row count to 1
set header rows frozen to true
set header column count to 3
set header columns frozen to true
end tell
end tell
Thank you, the second script worked beautifully!
In Script Editor:
tell application "Numbers"
tell table 1 of sheet 1 of front document
set header row count to 1
set header column count to 3
end tell
end tell
You may have to adjust the part table 1 of sheet 1 to suit your document.
Some instructions here:
Applescript to Freeze certain Header Rows and Columns for open Numbers doc
