## Close current workbook

Windows shortcut  CtrlF4 Mac shortcut  ⌘W This shortcut will close the current workbook window. 0 votes. 0 / 5 .rate-title { display: ...

## Check and uncheck box

Windows shortcut  Space Mac shortcut  Space This shortcut will check and uncheck checkboxes in a dialog box. First select the checkbox using tab ...

## Cancel selection

Windows shortcut  Esc Mac shortcut  Esc Pressing the escape key while editing a cell aborts the operation and leaves the cell in it's ...

## Cancel entry

Windows shortcut  Esc Mac shortcut  Esc Pressing escape while editing an a cell will abort the operation without changing anything. 0 votes. ...

## Cancel and close the dialog box

Windows shortcut  Esc Mac shortcut  Esc This shortcut will close the dialog box without applying any changes. 0 votes. 0 / 5 .rate-title ...

## Calculate worksheets

Windows shortcut  F9 Mac shortcut  FnF9 This shortcut will calculate all worksheets in all open workbooks. 0 votes. 0 / 5 .rate-title { ...

## Calculate active worksheet

Windows shortcut  ShiftF9 Mac shortcut  Fn⇧F9 This shortcut will calculate the active worksheet only. 0 votes. 0 / 5 .rate-title { ...

## Average top 3 scores

Example Related FunctionsAVERAGE LARGE =AVERAGE(LARGE(range,{1,2,3}))To average the top 3 scores in a data set, you can use a formula based on the LARGE ...

## Average numbers

Example Related FunctionsAVERAGE =AVERAGE(range)To get the average of a set of numbers, use the AVERAGE function.In the example shown, the formula in E5 ...

## Average numbers ignore zero

Example Related FunctionsAVERAGEIF =AVERAGEIF(range,"<>0")To get the average of a set of numbers, excluding or ignoring zero values, use the ...