What is the keyboard shortcut for parentheses?

[jstewart46]

Is there a keyboard shortcut that will allow me to place parentheses around a
highlighted formula (on the formula bar) with out typing '(' and ')' ?

 

[Guest]

hi
???????????????????
shift+9 and Shipt+0
???????????????????

 

[FSt1]

hi.
see this site for all known xl keyboards shortcuts. it's a
downloadable xl file.
I looked. none that i could find for what you want.
hope this helps you out.
FSt1

 

[Myrna Larson]

Not that I know of -- you have to move the cursor and type them manually. And
you can't do it with a macro: you say you want to do this in the formula bar,
which means you are in Edit mode. Macros can't run in Edit mode.

 

[Jonathan Rynd]

Is there a keyboard shortcut that will allow me to place parentheses around a
highlighted formula (on the formula bar) with out typing '(' and ')' ?

Control-X
(
Control-V
)

If you had a macro program or keyboard recorder, you could record this
sequence of keystrokes and assign it to a shortcut of your choice.

 

[Myrna Larson]

If you had a macro program or keyboard recorder, you could record this

sequence of keystrokes and assign it to a shortcut of your choice.

If he wants to operate on just the part of the formula that he has selected,
you can't record or run a macro to do it.

When you are editing in the formula bar, you can't turn on the macro recorder.
When you are editing in the formula bar, you can't run a macro, either.

If he always wanted to put parens around, say, the 5th through the 10th
characters, that could be automated with a macro. But he is out of luck if the
position and length is variable.

 

[Jonathan Rynd]

If he wants to operate on just the part of the formula that he has selected,
you can't record or run a macro to do it.

You can't record a run a VBA macro.

But there are plenty of other macro programs out there that will do the
trick, completely independently of what's happening in Excel.

When you are editing in the formula bar, you can't turn on the macro recorder.
When you are editing in the formula bar, you can't run a macro, either.

Third-party macro programs don't have this limitation.

 

[Myrna Larson]

Enlighten us. What programs are you talking about?

 

[Jonathan Rynd]

Enlighten us. What programs are you talking about?

For instance...

Macro Magic -- www.iolo.com/mm
Macro Express -- www.macros.com
Macro Scheduler -- www.mjtnet.com

All of these can record and play back at any time.