This article outlines 32 shortcuts you should start with today to use Excel without the mouse and increase your efficiency. Parenthesis)Unhide any hidden rows within theĬTRL+SHIFT+) (closingparenthesis) Unhide any hiddencolumns within the selection.ĬTRL+SHIFT+& Apply the outlineborder to the selected cells.ĬTRL+SHIFT+_ Remove the outlineborder from the selected cells. Once Excel is open, keep your browser open behind your Excel and look up the shortcut for any action for which you don’t immediately know the shortcut. You can thenpress ENTER orCTRL+SHIFT+ENTER (for arrayformulas) to replace the selectedportion with the calculated value.ĬTRL+ALT+F9 Calculate allworksheets in all open workbooks,regardless of whether they havechanged since the last calculation.ĬTRL+ALT+SHIFT+F9 Rechecksdependent formulas and thenĬalculates all cells in all openworkbooks, including cells notmarked as needing to becalculated.ĬTRL+C Copy the selected cells.CTRL+C, immediately followed byĪnother CTRL+C Display theMicrosoft Office Clipboard (multiplecopy and paste).ĬTRL+X Cut the selected cells.CTRL+V Paste copied cells.DELETE Clear the contents of theĬTRL+1 Display the Format Cellsdialog box.ĬTRL+SHIFT+~ Apply the Generalnumber format.ĬTRL+SHIFT+$ Apply the Currencyformat with two decimal places(negative numbers in parentheses).ĬTRL+SHIFT+% Apply thePercentage format with no decimalplaces.ĬTRL+SHIFT+^ Apply theExponential number format withtwo decimal places.ĬTRL+SHIFT+# Apply the Dateformat with the day, month, Apply the Timeformat with the hour and minute,and AM or PM.ĬTRL+SHIFT+! Apply the Numberformat with two decimal places,thousands separator, and minussign () for negative values.ĬTRL+U Apply or remove underlining.CTRL+5 Apply or removeĬTRL+9 Hide the selected rows.CTRL+SHIFT+( (opening When you are editing a cell, delete the character to the left of the insertion point.
Cancel an entry in the cell or formula bar. When a portion of aformula is selected, calculate theselected portion. Microsoft Excel 2001 (Mac) Keyboard Shortcuts. Insert an AutoSum formula with theSUM function.ĬTRL+SHIFT+" (quotation mark)Copy the value from the cell above theĪctive cell into the cell or theFormula Bar.ĬTRL+' (apostrophe) Copies aformula from the cell above theactive cell into the cell or theFormula Bar.ĬTRL+` (single left quotation mark)Alternate between displaying cellvalues and displaying formulas.į9 Calculate all worksheets in all openworkbooks.
When the insertion point is to the rightof a function name in a formula,insert the argument names andparentheses. Let’s understand the working of the Toolbar in Excel by some examples given below. Using Toolbar in Excel is easy, and it helps us simplify access to the document’s commands. To the right of a function name in aformula, display the FunctionArguments dialog box. The Toolbar in Excel is a shortcut tool to avoid searching for the commands you often use in the worksheet. = (equal sign) Start a formula.F2 Move the insertion point into theįormula Bar when editing in a cellis turned off.īACKSPACE In the Formula Bar,delete one character to the left.ĮNTER Complete a cell entry from thecell or Formula Bar.ĮSC Cancel an entry in the cell orFormula Bar.įunction dialog box.CTRL+A When the insertion point is Select cells, rows and columns,and objects SHIFT+F6 Switch to the previous panein a worksheet that has been split.ĬTRL+BACKSPACE Scroll to displaythe active cell. PAGE DOWN Move down one screen.PAGE UP Move up one screen.ALT+PAGE DOWN Move one screen For example, if =D8*$P$8 is in the Formula bar and you AutoFill from this cell, the next cell would read =D9*$P$8, changing the first cell, but keeping the second cell reference constant – otherwise, it would read =D9*P9.Arrow keysMove one cell up, down, left, or right.ĬTRL+arrow key Move to the edge ofthe current data region.ĬTRL+HOME Move to the beginningof the worksheet.ĬTRL+END Move to the last cell onthe worksheet, in the bottom-mostused row of the rightmost usedcolumn. If you want a constant reference (for example, each column should be divided by a certain cell's data), add a dollar sign ($) in front that cell's reference in the Formula bar. Excel automatically adjusts the formula for the row it is now on (so, in the example at right, February's total formula would read =SUM(B3:F3) and so on.Ī note about using AutoFill with formulas and functions: Click and hold on the fill handle and drag to the right (or down) to fill in the other cells.
Excel shortcut for formula bar mac plus#
Select the cell(s) with the formula and move the cursor over the little block in the lower right corner of the active cell, and the cursor changes to a hairline plus sign (+), as opposed to the usual block plus sign.Ģ. To use AutoFill with formulas, insert the formula and make sure it works (see Formulas and Functions for more information about working with formulas)ġ.
0 kommentar(er)
