Does Numbers allow creation of macros?

Short answer : NO !

Yvan KOENIG (VALLAURIS, France) vendredi 19 mars 2010 19:16:33

No macros but if you feel like learning Applescript you can automate it a bit. You can also use Automator's "record" workflow (or whatever it's called), save your "macro" as a service, and make a keyboard shortcut for it.

I'm curious to hear if this has worked for you. I would like to use Automator to create a "macro" for Numbers as well, but haven't been able to make it work. I want to be able to repeat the same editing/formatting tasks on every Numbers sheet I create.

I export my data to Numbers (no fancy formulas, just text within the cells). I want to automate the process of deleting the same rows and columns on every sheet, changing the font size, changing the margins, and a series of 'find and replace' edits.

Is this possible using Automator? This was a a really easy task for Excel with the Macro tool. I've tried using Automator, but get errors whenever I try to run recorded actions.

Thanks for your help!

One more question using the Excel vocabulary 😟
May you take care to use the Numbers one ?
*In Numbers, a sheet may contain table(s), text block(s), media item(s) or nothing
but _it will never contain cells_* !

May be done with AppleScript.
Send me a Numbers document with the original table
and the edited one.

Click my blue name to get my address.

But, I'm wondering why you must do that.
Why not use a custom template with most of the attributes already defined.
Custom templates where defned to fit these needs.

Yvan KOENIG (VALLAURIS, France) mercredi 28 avril 2010 16:16:25