MS Excel on Mac - is there an easy way to create a simple macro (to insert a blank row)?

[wfriedwald]

MS Excel on Mac - is there an easy way to create a simple macro (to insert a blank row)?

I keep trying the RECORD MACRO tag in the developer options, and it just doesn't work for me!

Help!

 

[960design]

Is it not just [Shift + Command + =] ?
What is the macro solving that the default keys listed above are not.

 

[wfriedwald]

that certainly helps! it brings up the dialog box, which is a step better. so now it's two steps to add a row instead of 3 or 4, so certainly helpful. and I searched all over the internet looking for that info, doesn't seem to be findable anywhere, I could use a list of all the pre-set shortcut keys. THANK YOU AND HAPPY NEW YEAR!

 

[960design]

I only use the online version of microsoft excel (and other online 365 applications).
Maybe try the online version and see if that works faster/better.
Happy New Year to you as well!

 

[wfriedwald]

thank you again - I truly did not realize that was even an option! (I wonder what the first step is for that?)

thanks again!

w

 

[Gregg2]

Why not right click on the "row heading" on the left and select "Add line above" or "Add line below"?

 

[MacBH928]

I only use the online version of microsoft excel (and other online 365 applications).
Maybe try the online version and see if that works faster/better.
Happy New Year to you as well!

isn't the online version slow?

 

[Tagbert]

isn't the online version slow?

It is and a lot of features are not available or are harder to get to. The web version is a compromise.

 

[MacBH928]

It is and a lot of features are not available or are harder to get to. The web version is a compromise.

I have an older machine so I thought maybe web apps run faster with newer machines. I guess I am wrong.

 

[Tagbert]

I have an older machine so I thought maybe web apps run faster with newer machines. I guess I am wrong.

You might consider using Keyboard Maestro to setup a macro for this or for any other thing you want to automate.

 

[MacBH928]

You might consider using Keyboard Maestro to setup a macro for this or for any other thing you want to automate.

am not sure what you mean, automate what? I think you are addressing OP?

 

[Tagbert]

am not sure what you mean, automate what? I think you are addressing OP?

Oh, I was. sorry for mixing you up. The OP was looking for a way to assign an action to a keystroke to insert a row. There may be other ways to do that but Keyboard Maestro should do that and more.