What is the keyboard shortcut for parentheses?

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Is there a keyboard shortcut that will allow me to place parentheses around a
highlighted formula (on the formula bar) with out typing '(' and ')' ?
 
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
 
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.
 
jstewart46 said:
Is there a keyboard shortcut that will allow me to place parentheses around a
highlighted formula (on the formula bar) with out typing '(' and ')' ?
Click to expand...

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.
 
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.
Click to expand...

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.
 
Myrna said:
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.
Click to expand...

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.
Click to expand...

Third-party macro programs don't have this limitation.
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Parsing data within parentheses 3
identify nested parentheses 1
Formulas 5
FIND from right to left instead of left to right 8
Displaying result in parentheses 4
Conditional formula based on 2 pre-conditions 4
Use array/braces **WITHIN** a formula? 3
i can't get this formula to work 3

Back
Top