Brackets Shortcut in Excel?
Already tried googling. So I know there's a shortcut to anchor a part of cell using F4 when you're in your formula bar.
But, if I want to put brackets around some parts in my formula bar, is there a shortcut?
I'm trying to type =(A5+B3)*5
I have =A5+B3 typed in the formula bar, is there any button or built in short cut to put brackets around all the contents? Or any related features?
Shortcut to Input Parenthesis Easily in Excel
While there is not an excel provided shortcut to add in parenthesis in excel, a user created acode to complete the following command.
Dim x As Integer
Dim strFormula As String
strFormula = Selection.FormulaR1C1
x = Len(strFormula)
y = Left(strFormula, x - (x - 1))
Z = Right(strFormula, x - 1)
Selection.FormulaR1C1 = y + "(" + Z + ")"
Application.CutCopyMode = False
Read More About Excel Shortcuts on WSO
- Favorite Excel Shortcut(S)?
- Excel: Tools, Add-Ins, And Macros
- What Shortcut Renames A Sheet In Excel?
Excel Border Shortcut
The shortcut to get to the excel border window - is "Alt + H + B + M". This opens up the “more” window with all the border options.
If you have a specific border command in mind, you can go to "Alt + H + B" and select the key that represents the option that you want out of the drop-down menu.
Looking to Become an Excel Master?
Sign up for ourto learn all this and more. Check out our 15% off 's .