Shortcut For Autosum In Excel On Full Screen Ctrl

If you use the shortcut without a row selected, youll see the the Insert Cells dialog box displayed.

See also: The 54 Excel shortcuts you really should know and Excel shortcuts on the Mac.

My heart sank when I looked at a multi-line cell realised I needed each line in a separate column.

Worked a charm. Yes, I could have done it other ways but all of them would have been so much longer.

I sorted your method out in less time than it took me to send you this email.

Extend the selection to the last cell up Ctrl Shift Add or remove border horizontal interior Alt H No alternative shortcut for mac.

Shortcut For Autosum In Excel On Full Screen Ctrl

Remove borders Ctrl Shift Maximize current workbook window Ctrl F10 Fn F10 Select all precedents Ctrl Shift Move to next pane Shift F6 Fn F6 Select entire pivot table Ctrl A A Check and uncheck box First select the checkbox, Tab or Shift Space First select the checkbox, Tab or Shift Space Accept function with autocomplete Tab or shift tab Tab Extend the selection to the last cell right Ctrl Shift Unhide rows Ctrl Shift 9 9 Apply number format Ctrl Shift Move one cell down Move one screen up PgUp Fn Move to previous tab Ctrl Shift Tab Tab Cut selected cells Ctrl X X Duplicate object Ctrl D D Open pivot table wizard Alt D P P Toggle full screen Ctrl Shift F1 F Extend the selection to the last cell left Ctrl Shift Select column differences Ctrl Shift Move to bottom edge of data region Ctrl Insert current date Ctrl;; Move active cell up in selection Shift Enter Return Add border outline Ctrl Shift 0 Extend selection down one screen Shift PgDn Fn Print file Ctrl P P Move to previous pane Shift F6 Fn F6 Save workbook Ctrl S S Open options Alt F T, Move to next tab Ctrl Tab Tab Display the Paste Special dialog box Ctrl Alt V V Get help on selected control Shift F1 No alternative shortcut for mac.

Copy selected cells Ctrl C C Evaluate part of a formula Shift F9 Fn F9 Add adjacent cells to selection Shift Click Click Remove indent Alt H 5 Tab Apply currency format Ctrl Shift Move one word left Ctrl Move one screen down PgDn Fn Add or remove the shadow font style No alternative shortcut for windows.

W Extend the selection to the last cell down Ctrl Shift Force calculate all worksheets Ctrl Alt F9 NA Align left Alt H A L L Unhide columns Ctrl Shift 0 0 Create chart in new worksheet Shift F11 Fn F11 Create new workbook Ctrl N N Create pivot chart on same worksheet Alt F1 No alternative shortcut for mac.

Move one cell up Extend selection to start of row Shift Home Fn Go to next worksheet Ctrl PgDn Fn Select all dependents Ctrl Shift Flash fill Ctrl E NA Extend selection to last cell in worksheet Ctrl Shift End Fn Display right-click menu Shift F10 Fn F10 Turn End mode on End (or Shift End) Fn Enter and move down Enter Return Select direct dependents Ctrl Apply or remove underscoring Ctrl U U Increase font size one step Alt H FG Select current region around active cell Ctrl Shift Space Display find and replace Ctrl F F Define name Ctrl F3 Fn F3 Move left between non-adjacent selections Ctrl Alt Show the active cell on worksheet Ctrl Backspace Delete Apply or remove strikethrough formatting Ctrl 5 X Toggle Autofilter Ctrl Shift L F Activate access keys Alt or Shift F10 No shortcut alternative for mac.

Toggle add to selection mode Shift F8 Fn F8 Expand or collapse ribbon Ctrl F1 R Enter array formula Ctrl Shift Enter Return Insert columns Ctrl Shift Close Excel Alt F4 Q Clear slicer filter Alt C C Cancel entry Esc Esc Find next match Shift F4 G Group rows or columns Alt Shift K Drag and insert Shift drag drag Extend selection up one screen Shift PgUp Fn Insert rows Ctrl Shift Delete comment Shift F10 D Fn Shift F10 Select table column Ctrl Space Space Calculate worksheets Shift F9 Fn F9 Go back to hyperlink Ctrl G Enter G Return Copy formula from cell above Ctrl Move to previous control Shift Tab Tab Move to first cell in worksheet Ctrl Home Fn Find previous match Ctrl Shift F4 G Select visible cells only Alt; Z Select table row Shift Space Space Move to top edge of data region Ctrl Display Insert Dialog box Ctrl Shift Activate or open selected control Space Space Display Modify Cell Style dialog box Alt L Add or remove border bottom Alt B Paste content from clipboard Ctrl V V Complete entry and stay in same cell Ctrl Enter Return Move to next control Tab Tab Display function arguments dialog box Ctrl A A Drag to worksheet Alt drag drag Extend selection by one cell right Shift Select entire row Shift Space Space Insert table Ctrl T T Select one word left Ctrl Shift Toggle formulas on and off Ctrl Open workbook Ctrl O O Display Delete dialog box Ctrl Ungroup pivot table items Alt Shift J Select one word left Ctrl Shift Edit the active cell Shift F2 U Delete contents of selected cells Delete Fn Delete Insert or edit comment Shift F2 Fn F2 Move one cell left Enter and move up Shift Enter Return Select cells with comments Ctrl Shift O Fn O Display Go To dialog box Ctrl G G Apply or remove bold formatting Ctrl B B Move active cell down in selection Enter Return Move active cell down in selection Alt Shift K Align right Alt H A R R Decrease font size one step Alt H FK Toggle extend selection mode Shift F8 Fn F8 Move active cell left in a selection Shift Tab Tab Zoom in Ctrl Alt Delete to end of line Ctrl Delete Delete Display AutoComplete list Alt Open Ungroup Dialog Box Alt Shift J Select current array Ctrl Add or remove the outline font style No shortcutalternative for windows.

D Extend selection by one cell up Shift Open help Shift F1 Select adjacent worksheets Shift Click Click Ungroup rows or columns Alt Shift J Hide pivot table item Ctrl Ctrl Drag and cut drag drag Create embedded chart Alt F1 Fn F1 Select one word right Ctrl Shift Open print preview window Ctrl F2 NA Apply general format Ctrl Shift Delete character to the left of cursor Backspace Delete Redo last action Ctrl Y Y Toggle absolute and relative references Shift F4 T Move active cell right in a selection Tab Tab Same selection in previous column NA Tab Calculate active worksheet Shift F9 Fn F9 Drag and insert copy Ctrl Shift drag drag Add non-adjacent cells to selection Ctrl Click Click Delete columns Ctrl Apply date format Ctrl Shift Select one character right Shift Move to last cell in worksheet Ctrl End Fn Display find and replace, replace selected Ctrl H H Move to right edge of data region Ctrl Apply scientific format Ctrl Shift Select non-adjacent worksheets Ctrl Click Click Apply time format Ctrl Shift Save as Shift F12 S Close current workbook Ctrl F4 W Select row differences Ctrl Autosum selected cells Alt T Snap to grid Alt Toggle table total row Ctrl Shift T T Select to end of cell Shift End Fn Format (almost) anything Ctrl 1 1 Extend selection by one cell left Shift Select entire worksheet Ctrl A A Toggle pivot table field checkbox Space Space Go to next workbook Ctrl Tab Tab Go to next workbook Tab Tab Move one cell right Indent Alt PgDn Fn Hide or show objects Ctrl 6 6 Enter same data in multiple cells Ctrl Enter Return Hide rows Ctrl 9 9 Open VBA Editor Alt F11 Fn F11 Zoom out Ctrl Alt Select active cell only Shift Backspace Delete Copy value from cell above Ctrl Shift Move active cell clockwise in selection Ctrl..

Cancel and close the dialog box Esc Esc Select entire column Ctrl Space Space Activate filter Alt Create pivot chart on new worksheet Shift F11 Fn F11 Add hyperlink Ctrl K K Select current region Ctrl A A Insert function arguments Ctrl Shift A A Open Macro dialog box Alt F8 Fn F8 Open Group Dialog Box Alt Shift K Accept and apply Enter Return Drag to duplicate worksheet Ctrl drag drag Select one character left Shift Confirm control change Enter Return Same selection in next column NA Tab Move to left edge of data region Ctrl Undo last action Ctrl Z Z Fill down from cell above Ctrl D D Select one character left Shift Align center Alt H A C E Select direct precedents Ctrl Paste name into formula F3 NA Apply percentage format Ctrl Shift Insert current time Ctrl Shift:; Start a new line in the same cell Alt Enter Return Move to beginning of row Home Fn Display control menu Alt Space Drag and copy Ctrl drag drag Move one screen left Alt PgUp Fn Open Thesaurus dialog box Shift F7 Fn F7 Minimize current workbook window Ctrl F9 M Add or remove border top Alt T Select table Ctrl A A Go to previous worksheet Ctrl PgUp Fn Insert new worksheet Shift F11 Fn F11 Enter and move left Shift Tab Tab Delete character to the right of cursor Delete Fn Delete Delete cells Ctrl Move to next ribbon control Tab Tab Cancel selection Esc Esc Move right between non-adjacent selections Ctrl Alt Go to previous workbook Ctrl Shift Tab Tab Delete rows Ctrl Excel Shortcut Table.

Shortcut For Autosum In Excel On Mac