Full Transcript

Excel Shortcuts Bible EXCEL Shortcuts Bible Excel 2013 / 2016 © eforexcel.com Excel Shortcuts Bible Shortcut Keys Key Description CTRL+PgUp Switches between worksheet tabs, from left-to-right. CTRL+PgDn...

Excel Shortcuts Bible EXCEL Shortcuts Bible Excel 2013 / 2016 © eforexcel.com Excel Shortcuts Bible Shortcut Keys Key Description CTRL+PgUp Switches between worksheet tabs, from left-to-right. CTRL+PgDn Switches between worksheet tabs, from right-to-left. CTRL+SHIFT+( Unhides any hidden rows within the selection. CTRL+SHIFT+) Unhides any hidden columns within the selection. CTRL+SHIFT+& Applies the outline border to the selected cells. CTRL+SHIFT_ Removes the outline border from the selected cells. CTRL+SHIFT+~ Applies the General number format. CTRL+SHIFT+$ Applies the Currency format with two decimal places (negative numbers in parentheses). CTRL+SHIFT+% Applies the Percentage format with no decimal places. CTRL+SHIFT+^ Applies the Exponential number format with two decimal places. CTRL+SHIFT+# Applies the Date format with the day, month, and year. CTRL+SHIFT+@ Applies the Time format with the hour and minute, and AM or PM. CTRL+SHIFT+! Applies the Number format with two decimal places, thousands separator, and minus sign (-) for negative values. CTRL+SHIFT+* Selects the current region around the active cell (the data area enclosed by blank rows and blank columns). In a PivotTable, it selects the entire PivotTable report. CTRL+SHIFT+: Enters the current time. CTRL+SHIFT+" Copies the value from the cell above the active cell into the cell or the Formula Bar. CTRL+SHIFT+Plus Displays the Insert dialog box to insert blank cells. (+) CTRL+SHIFT+= Insert Row / Column (if entire row/column is selected otherwise it displays Insert dialog box) CTRL+Minus (-) Displays the Delete dialog box to delete the selected cells. If entire row(s) / column(s) is selected, it deletes them. CTRL+SHIFT+L Applies / removes filter CTRL+; Enters the current date. CTRL+~ Alternates between displaying cell values and displaying formulas in the worksheet. CTRL+' Copies a formula from the cell above the active cell into the cell or the Formula Bar. CTRL+1 Displays the Format Cells dialog box. CTRL+2 Applies or removes bold formatting. CTRL+3 Applies or removes italic formatting. CTRL+4 Applies or removes underlining. CTRL+5 Applies or removes strikethrough. CTRL+6 Alternates between hiding objects, displaying objects, and displaying placeholders for objects. CTRL+8 Displays or hides the outline symbols. CTRL+9 Hides the selected rows. CTRL+0 Hides the selected columns. CTRL+A Selects the entire worksheet. © eforexcel.com Excel Shortcuts Bible If the worksheet contains data, CTRL+A selects the current region. Pressing CTRL+A a second time selects the current region and its summary rows. Pressing CTRL+A a third time selects the entire worksheet. When the insertion point is to the right of a function name in a formula, displays the Function Arguments dialog box. CTRL+SHIFT+A inserts the argument names and parentheses when the insertion point is to the right of a function name in a formula. CTRL+B Applies or removes bold formatting. CTRL+C Copies the selected cells. CTRL+C followed by another CTRL+C displays the Clipboard. CTRL+D Uses the Fill Down command to copy the contents and format of the topmost cell of a selected range into the cells below. CTRL+E Flash Fill CTRL+F Displays the Find and Replace dialog box, with the Find tab selected. SHIFT+F5 also displays this tab, while SHIFT+F4 repeats the last Find action. CTRL+SHIFT+F opens the Format Cells dialog box with the Font tab selected. CTRL+G Displays the Go To dialog box. F5 also displays this dialog box. CTRL+H Displays the Find and Replace dialog box, with the Replace tab selected. CTRL+I Applies or removes italic formatting. CTRL+K Displays the Insert Hyperlink dialog box for new hyperlinks or the Edit Hyperlink dialog box for selected existing hyperlinks. CTRL+N Creates a new, blank workbook. CTRL+O Displays the Open dialog box to open or find a file. CTRL+SHIFT+O selects all cells that contain comments. CTRL+P Displays the Print dialog box. CTRL+SHIFT+P opens the Format Cells dialog box with the Font tab selected. CTRL+R Uses the Fill Right command to copy the contents and format of the leftmost cell of a selected range into the cells to the right. CTRL+S Saves the active file with its current file name, location, and file format. CTRL+T Displays the Create Table dialog box. CTRL+U Applies or removes underlining. CTRL+SHIFT+U switches between expanding and collapsing of the formula bar. CTRL+V Inserts the contents of the Clipboard at the insertion point and replaces any selection. Available only after you have cut or copied an object, text, or cell contents. CTRL+ALT+V displays the Paste Special dialog box. Available only after you have cut or copied an object, text, or cell contents on a worksheet or in another program. CTRL+W Closes the selected workbook window. CTRL+X Cuts the selected cells. © eforexcel.com Excel Shortcuts Bible CTRL+Y Repeats the last command or action, if possible. CTRL+Z Uses the Undo command to reverse the last command or to delete the last entry that you typed. CTRL+SHIFT+Z uses the Undo or Redo command to reverse or restore the last automatic correction when AutoCorrect Smart Tags are displayed. Function keys Key Description F1 Displays the Microsoft Office Excel Help task pane. CTRL+F1 displays or hides the Ribbon, a component of the Microsoft Office Fluent user interface. ALT+F1 creates a chart of the data in the current range. ALT+SHIFT+F1 inserts a new worksheet. F2 Edits the active cell and positions the insertion point at the end of the cell contents. It also moves the insertion point into the Formula Bar when editing in a cell is turned off. SHIFT+F2 adds or edits a cell comment. CTRL+F2 displays the Print Preview window. ALT+F2 displays the Save As dialog box. F3 Displays the Paste Name dialog box. SHIFT+F3 displays the Insert Function dialog box. CTRL+F3 displays Name Manager box. CTRL+SHIFT+F3 displays the Create Name from Selection Box. F4 Repeats the last command or action, if possible. When a cell reference or range is selected in a formula, F4 cycles through the various combinations of absolute and relative references. CTRL+F4 closes the selected workbook window. F5 Displays the Go To dialog box. CTRL+F5 restores the window size of the selected workbook window. CTRL+ALT+F5 refresh all links F6 Switches between the worksheet, Ribbon, task pane, and Zoom controls. In a worksheet that has been split (View menu, Manage This Window, Freeze Panes, Split Window command), F6 includes the split panes when switching between panes and the Ribbon area. SHIFT+F6 switches between the worksheet, Zoom controls, task pane, and Ribbon. CTRL+F6 switches to the next workbook window when more than one workbook window is open. F7 Displays the Spelling dialog box to check spelling in the active worksheet or selected range. CTRL+F7 performs the Move command on the workbook window when it is not maximized. Use the arrow keys to move the window, and when finished press ENTER, or ESC to cancel. F8 Turns extend mode on or off. In extend mode, Extended Selection appears in the status line, and the arrow keys extend the selection. © eforexcel.com Excel Shortcuts Bible SHIFT+F8 enables you to add a nonadjacent cell or range to a selection of cells by using the arrow keys. CTRL+F8 performs the Size command (on the Control menu for the workbook window) when a workbook is not maximized. ALT+F8 displays the Macro dialog box to create, run, edit, or delete a macro. F9 Calculates all worksheets in all open workbooks. SHIFT+F9 calculates the active worksheet. CTRL+ALT+F9 calculates all worksheets in all open workbooks, regardless of whether they have changed since the last calculation. CTRL+ALT+SHIFT+F9 rechecks dependent formulas, and then calculates all cells in all open workbooks, including cells not marked as needing to be calculated. CTRL+F9 minimizes a workbook window to an icon. F10 Turns key tips on or off. SHIFT+F10 displays the shortcut menu for a selected item. ALT+SHIFT+F10 displays the menu or message for a smart tag. If more than one smart tag is present, it switches to the next smart tag and displays its menu or message. CTRL+F10 maximizes or restores the selected workbook window. F11 Creates a chart of the data in the current range. SHIFT+F11 inserts a new worksheet. ALT+F11 opens the Microsoft Visual Basic Editor, in which you can create a macro by using Visual Basic for Applications (VBA). F12 Displays the Save As dialog box. Additional ALT Shortcut Keys Key Description ALT Displays Keys which can be pressed in combination with ALT ALT+I+R Insert Row ALT+I+C Insert Column ALT+Space Bar Control box in top left corner ALT+= Autosum FILE TAB ALT KEYS ALT+F+I Displays Info ALT+F+I+G Displays location (file path) options ALT+F+I+P Protect workbook options ALT+F+I+I Inspect workbook options ALT+F+I+R Manage versions options ALT+F+I+A Browser view options ALT+F+I+Q+S Document properties options ALT+F+I+S+1 Add a title ALT+F+I+S+2 Add a tag © eforexcel.com Excel Shortcuts Bible ALT+F+I+S+3 Add a category ALT+F+I+O+1 Displays current author ALT+F+I+O+2 Add author no. 2 ALT+F+I+O+3 Add an author no. 3 ALT+F+I+O+4 Add an author no. 4 ALT+F+I+O+5 Displays last modified by author ALT+F+I+U+1 Open file location ALT+F+I+Q+P Toggles between show all or limited properties ALT+F+N Displays New ALT+F+N+S Search online templates ALT+F+N+U+1 Search business templates ALT+F+N+U+1 Search personal templates ALT+F+N+U+1 Search industry templates ALT+F+N+U+1 Search financial management templates ALT+F+N+U+1 Search logs templates ALT+F+N+U+1 Search calculator templates ALT+F+N+U+7 Search lists templates ALT+F+N+F Displays featured templates ALT+F+N+E Displays personal templates ALT+F+N+M+1 Welcome to Excel tour ALT+F+N+M+2 Cashflow template (2016) ALT+F+N+M+3 Stock symbols comparison template (2016) ALT+F+N+M+4 Calendar insights (2016) ALT+F+N+Z+1 Travel expense calculator template ALT+F+N+Z+2 Project to do list template ALT+F+N+Z+3 Inventory list template ALT+F+N+Z+4 Loan comparison calculator template ALT+F+N+Z+5 Personal expenses calculator template ALT+F+N+Z+6 Family budget (monthly) template ALT+F+N+Z+7 To do list template ALT+F+N+Z+8 Sales invoice tracker template ALT+F+N+Z+9 Student schedule template ALT+F+N+Z+A D&B business verification template ALT+F+N+Z+B Home inventory template ALT+F+N+Z+C Generic logbook template ALT+F+N+Z+D Profit loss statement template ALT+F+N+Z+E Student attendance record template ALT+F+N+Z+F Wedding budget template ALT+F+N+Z+G Employee attendance tracker template ALT+F+N+Z+H Expense trends budget template ALT+F+N+Z+I Project tracker template ALT+F+N+Z+J Simple monthly budget template ALT+F+N+Z+K Gantt project planner template ALT+F+N+Z+L Vacations items checklist template ALT+F+N+Z+M Warehouse inventory template ALT+F+N+Z+N Monthly college budget template ALT+F+N+Z+O Calorie amortization schedule template ALT+F+N+Z+P Employee absence schedule template ALT+F+N+L New blank workbook © eforexcel.com Excel Shortcuts Bible ALT+F+O Displays Open ALT+F+O+R Recent workbooks ALT+F+O+K Open from One drive ALT+F+O+C Open from Computer ALT+F+O+A Add a place ALT+F+O+Numbers (1 to..) Opens a file in Recent workbooks ALT+F+S Save As to Computer ALT+F+A Displays Save As ALT+F+A+K Save As to One drive ALT+F+A+C Save As to Computer ALT+F+A+A Add a place for Save As ALT+F+A+Numbers (1 to..) Save As to Recent Folders ALT+F+A+B Browse for Save As ALT+F+P Displays Print ALT+F+P+P Print to default printer for printing ALT+F+P+N Number of copies for printing ALT+F+P+I Displays all printers for printing ALT+F+P+A Displays settings for printing sheets / workbooks ALT+F+P+H From page for printing ALT+F+P+J To page for printing ALT+F+P+C Collated ALT+F+P+O Portrait / Landscape orientation ALT+F+P+L For choosing the paper type like Letter, A4 ALT+F+P+M For choosing page margins ALT+F+P+S For choosing page scaling ALT+F+P+G Page setup ALT+F+P+T For choosing page number in Page Preview ALT+F+H+S Share – Invite people ALT+F+H+E Share – Displays e mail options ALT+F+H+Y1 Share - Bluetooth ALT+F+H+C Save As ALT+F+E+P+A Export as PDF/XPS ALT+F+E+A Export as PDF/XPS (Same as above) ALT+F+E+C+Q+A Save as.xlsx ALT+F+E+C+L+A Save as.xls ALT+F+E+C+O+A Save as.ods ALT+F+E+C+T+A Save as.xltx ALT+F+E+C+M+A Save as.xlsm ALT+F+E+C+R+A Save as.xlsb ALT+F+E+C+X+A Save as.txt ALT+F+E+C+D+A Save as.csv ALT+F+E+C+F+A Save as.prn ALT+F+E+C+V+A Save as Another File Type ALT+F+D Displays Account ALT+F+D+Y1 Change your office theme ALT+F+D+Y2 Change your product key ALT+F+D+S Sign in to Excel ALT+F+D+L Show additional licensing information ALT+F+D+A Display About Excel © eforexcel.com Excel Shortcuts Bible ALT+F+T Display Excel Options © eforexcel.com Excel Shortcuts Bible HOME TAB ALT KEYS ALT+H+X Cut ALT+H+C Copy ALT+H+F+P Format Painter ALT+H+F+O Open clipboard ALT+H+F+F Choose font type ALT+H+F+S Choose font size ALT+H+F+G Increase font size ALT+H+F+K Decrease font size ALT+H+0 Increase decimal ALT+H+1 Apply / remove Bold formatting ALT+H+2 Apply / remove Italics formatting ALT+H+3 Apply / remove Underline formatting ALT+H+4 Decrease indent ALT+H+5 Increase indent ALT+H+9 Decrease decimal ALT+H+B+O Apply bottom border ALT+H+ B+P Apply top border ALT+H+ B+L Apply left border ALT+H+ B+R Apply right border ALT+H+ B+N Apply no border ALT+H+ B+A Apply all border ALT+H+ B+S Apply outside border ALT+H+ B+T Apply thick box border ALT+H+ B+B Apply bottom double border ALT+H+ B+H Apply thick bottom border ALT+H+ B+D Apply top and bottom border ALT+H+ B+C Apply top and thick bottom border ALT+H+ B+U Apply top and double bottom border ALT+H+ B+W Draw border ALT+H+ B+G Draw border grid ALT+H+ B+E Erase border ALT+H+ B+I Line color ALT+H+ B+I+M More colors under Line color ALT+H+ B+Y Line style ALT+H+ B+M More borders ALT+H+H Fill color ALT+H+H+N No fill for Fill color ALT+H+H+M More color for Fill color ALT+H+F+C Font color ALT+H+F+C+M More color for Font color ALT+H+F+N Format cells dialog box with Font tab ALT+H+A+T Top align ALT+H+A+M Middle align ALT+H+A+B Bottom align ALT+H+A+L Left align © eforexcel.com Excel Shortcuts Bible ALT+H+A+C Center align ALT+H+A+R Right align ALT+H+F+Q Orientation ALT+H+F+Q+O Orientation – Angle counterclockwise ALT+H+F+Q+L Orientation – Angle clockwise ALT+H+F+Q+V Orientation – Vertical text ALT+H+F+Q+U Orientation – Rotate text up ALT+H+F+Q+D Orientation – Rotate text down ALT+H+F+Q+M Orientation – Format cell dialog box with Alignment tab ALT+H+W Wrap text ALT+H+M Merge & Center ALT+H+M+C Merge & Center – Merge & center ALT+H+M+A Merge & Center – Merge across ALT+H+M+M Merge & Center – Merge cells ALT+H+M+U Merge & Center – Unmerge cells ALT+H+N Choose number format ALT+H+F+A Format cell dialog box with Alignment tab ALT+H+A+N Accounting number format ALT+H+A+N+M Choose more Accounting number format ALT+H+P Applies the Percentage format with no decimal places ALT+H+K Applies the Accounting format ALT+H+F+M Format cell dialog box with Number tab ALT+H+L+ Conditional formatting ALT+H+L+H Conditional formatting - Highlight cell rules ALT+H+L+H+G Conditional formatting - Highlight cell rules – Greater than ALT+H+L+H+L Conditional formatting - Highlight cell rules – Less than ALT+H+L+H+B Conditional formatting - Highlight cell rules – Between ALT+H+L+H+E Conditional formatting - Highlight cell rules – Equal to ALT+H+L+H+T Conditional formatting - Highlight cell rules – Text that contains ALT+H+L+H+A Conditional formatting - Highlight cell rules – A date occurring ALT+H+L+H+D Conditional formatting - Highlight cell rules – Duplicate values ALT+H+L+H+M Conditional formatting - Highlight cell rules – More rules ALT+H+L+T Conditional formatting – Top / Bottom rule ALT+H+L+T+T Conditional formatting – Top / Bottom rule – Top 10 items ALT+H+L+T+P Conditional formatting – Top / Bottom rule – Top 10% ALT+H+L+T+B Conditional formatting – Top / Bottom rule – Bottom 10 items ALT+H+L+T+O Conditional formatting – Top / Bottom rule – Bottom 10% ALT+H+L+T+A Conditional formatting – Top / Bottom rule – Above average ALT+H+L+T+V Conditional formatting – Top / Bottom rule – Below average ALT+H+L+T+M Conditional formatting – Top / Bottom rule – More rules ALT+H+L+D Conditional formatting – Data bars ALT+H+L+D+M Conditional formatting – Data bars – More rules ALT+H+L+S Conditional formatting – Color scales ALT+H+L+S+M Conditional formatting – Color scales – More rules ALT+H+L+I Conditional formatting – Icon sets ALT+H+L+I+M Conditional formatting – Icon sets – More rules ALT+H+L+N Conditional formatting – New rule ALT+H+L+C Conditional formatting – Clear rules © eforexcel.com Excel Shortcuts Bible ALT+H+L+C+S Conditional formatting – Clear rules – Clear rules from selected cells ALT+H+L+C+E Conditional formatting – Clear rules – Clear rules from entire sheet ALT+H+L+R Conditional formatting – Manage rules ALT+H+T Format as table ALT+H+T+N Format as table – New table style ALT+H+T+P Format as table – New pivot table style ALT+H+J Cell styles ALT+H+J+N Cell styles – New cell style ALT+H+J+M Cell styles – Merge styles ALT+H+I Insert ALT+H+I+ Insert – Insert cells ALT+H+I+ Insert – Insert sheet rows ALT+H+I+ Insert – Insert sheet columns ALT+H+I+ Insert – Insert sheet ALT+H+D Delete ALT+H+D+ Delete – Delete cells ALT+H+D+ Delete – Delete sheet rows ALT+H+D+ Delete – Delete sheet columns ALT+H+D+ Delete – Delete sheet ALT+H+O Format ALT+H+O+H Format – Row height ALT+H+O+A Format – Autofit row height ALT+H+O+W Format – Column width ALT+H+O+I Format – Autofit column width ALT+H+O+D Format – Default width ALT+H+O+U Format – Hide / Unhide ALT+H+O+U+R Format - Hide / Unhide – Hide rows ALT+H+O+U+C Format - Hide / Unhide – Hide columns ALT+H+O+U+S Format - Hide / Unhide – Hide Sheet ALT+H+O+U+O Format - Hide / Unhide – Unhide rows ALT+H+O+U+L Format - Hide / Unhide – Unhide columns ALT+H+O+U+H Format - Hide / Unhide – Unhide sheets ALT+H+O+R Format – Rename sheet ALT+H+O+M Format – Move or copy sheet ALT+H+O+T Format – Tab color ALT+H+O+T+N Format - Tab color – No color ALT+H+O+T+M Format - Tab color – More color ALT+H+O+P Format – Protect sheet ALT+H+O+L Format – Lock cells ALT+H+O+E Format – Format cells dialog box ALT+H+U Autosum - ALT+H+U+S Autosum - Sum ALT+H+U+A Autosum – Average ALT+H+U+C Autosum – Count Numbers ALT+H+U+M Autosum – Max ALT+H+U+I Autosum – Min ALT+H+U+F Autosum – More functions © eforexcel.com Excel Shortcuts Bible ALT+H+F+I Fill ALT+H+F+I+D Fill – Down ALT+H+F+I+R Fill – Right ALT+H+F+I+U Fill – Up ALT+H+F+I+L Fill – Left ALT+H+F+I+A Fill – Across worksheets ALT+H+F+I+S Fill – Series ALT+H+F+I+J Fill – Justify ALT+H+F+I+F Fill – Flash Fill ALT+H+E Clear ALT+H+E+A Clear – Clear all ALT+H+E+F Clear – Clear format ALT+H+E+C Clear – Clear contents ALT+H+E+M Clear – Clear comments ALT+H+E+L Clear – Clear hyperlinks ALT+H+E+R Clear – Remove hyperlinks ALT+H+S Sort & Filter ALT+H+S+S Sort & Filter – Sort A to Z ALT+H+S+O Sort & Filter – Sort Z to A ALT+H+S+U Sort & Filter – Custom sort ALT+H+S+F Sort & Filter – Filter ALT+H+S+C Sort & Filter – Clear ALT+H+S+Y Sort & Filter - Reapply ALT+H+F+D Find & Select ALT+H+F+D+F Find & Select – Find ALT+H+F+D+R Find & Select – Replace ALT+H+F+D+G Find & Select – Go to ALT+H+F+D+S Find & Select – Go to special ALT+H+F+D+U Find & Select – Formulas ALT+H+F+D+M Find & Select - Comments ALT+H+F+D+C Find & Select – Conditional formatting ALT+H+F+D+N Find & Select – Constants ALT+H+F+D+V Find & Select – Data validation ALT+H+F+D+O Find & Select – Select objects ALT+H+F+D+P Find & Select – Selection Pane ALT+H+F+D+ Find & Select - INSERT TAB ALT KEYS ALT+N Insert tab ALT+N+V Create pivot table ALT+N+S+P Recommended pivot table ALT+N+T Create table ALT+N+P Insert picture ALT+N+F Insert picture from online ALT+N+SH Insert shapes ALT+N+M Insert Smart Art ALT+N+S+C Screenshot © eforexcel.com Excel Shortcuts Bible ALT+N+S+C+C Start taking screenshot ALT+N+S+A Apps for office ALT+N+S+A+S See all apps for office ALT+N+R Insert chart - Recommended chart ALT+N+C Insert column chart ALT+N+C+M Insert column chart – More charts ALT+N+B Insert bar chart ALT+N+B+M Insert bar chart – More charts ALT+N+O Insert stock, surface or radar chart ALT+N+O+M Insert stock, surface or radar chart – More charts ALT+N+N Insert line chart ALT+N+N+M Insert line chart – More charts ALT+N+A Insert area chart ALT+N+A+M Insert area chart – More charts ALT+N+S+D Combo chart ALT+N+S+D+C Create combo chart ALT+N+Q Insert pie chart ALT+N+Q+M Insert pie chart – More charts ALT+N+D Insert scatter chart ALT+N+D+M Insert scatter chart – More charts ALT+N+S+Z Pivot chart ALT+N+S+Z+C Pivot chart ALT+N+S+Z+P Pivot chart and pivot table ALT+N+S+V Power view ALT+N+S+L Create line sparklines ALT+N+S+O Create column sparklines ALT+N+S+W Create win/loss sparklines ALT+N+S+F Insert slicer ALT+N+S+T Insert timelines ALT+N+I Insert hyperlinks ALT+N+X Insert textbox ALT+N+H Header and footer view ALT+N+W Insert Wordart ALT+N+G Add a signature line ALT+N+J Insert object ALT+N+E Insert equation ALT+N+U Insert symbol ALT+N+K Insert chart PAGE LAYOUT ALT KEYS ALT+P Page layout tab ALT+P+T+H Themes ALT+P+T+H+B Themes - Browse for themes ALT+P+T+H+A Themes - Current themes ALT+P+T+C Themes - Colors ALT+P+T+C+C Themes - Colors –Customize ALT+P+T+F Themes - Fonts © eforexcel.com Excel Shortcuts Bible ALT+P+T+F+C Themes - Fonts - Customize ALT+P+T+E Themes - Effects ALT+P+M Page setup - Margins ALT+P+M+A Page Setup – Margins - Custom ALT+P+O Page Setup - Orientation ALT+P+S+Z Page Setup - Size ALT+P+S+Z+M Page Setup – More paper size ALT+P+R Page Setup – Print area ALT+P+R+S Page Setup - Print area – Set print area ALT+P+R+C Page Setup - Print area – Clear print area ALT+P+B Page Setup - Break ALT+P+ B+I Page Setup – Insert page break ALT+P+ B+R Page Setup – Remove page break ALT+P+ B+A Page Setup – Reset all page breaks ALT+P+G Page Setup – Insert picture for background ALT+P+I Page Setup – Page setup dialog box with sheet tab ALT+P+S+P Page Setup – Page setup dialog box with page tab ALT+P+W Scale to fit – Width ALT+P+H Scale to fit – Height ALT+P+X Scale to fit – Scale ALT+P+V+G Sheet options – Check / uncheck view gridlines ALT+P+P+G Sheet options – Check / uncheck print gridlines ALT+P+V+H Sheet options - Check / uncheck view headings ALT+P+P+H Sheet options - Check / uncheck print headings ALT+P+S+O Page layout dialog box with sheet tab ALT+P+A+F Arrange - Bring forward ALT+P+ A+F+F Arrange -Bring forward – Bring forward ALT+P+ A+F+R Arrange - Bring forward – Bring to front ALT+P+A+E Arrange - Send backward ALT+P+A+E+B Arrange - Send backward – Send backward ALT+P+A+E+K Arrange - Send backward - Send to back ALT+P+A+P Arrange - Selection pane ALT+P+A+A Arrange - Align ALT+P+ A+A+L Arrange -Align - Align left ALT+P+ A+A+C Arrange - Align - Align center ALT+P+ A+A+R Arrange - Align - Align right ALT+P+ A+A+T Arrange - Align - Align top ALT+P+ A+A+M Arrange - Align - Align middle ALT+P+ A+A+B Arrange - Align - Align bottom ALT+P+ A+A+H Arrange - Arrange - Align - Distribute horizontally ALT+P+ A+A+V Arrange - Align - Distribute vertically ALT+P+ A+A+P Arrange - Align - Snap to grid ALT+P+ A+A+S Arrange - Align - Snap to shape ALT+P+ A+A+G Arrange - Align - View Gridlines ALT+P+A+G Arrange - Group ALT+P+A+G+G Arrange – Group – Group ALT+P+A+G+E Arrange – Group - Regroup ALT+P+A+G+U Arrange – Group - Ungroup ALT+P+A+Y Arrange – Rotate © eforexcel.com Excel Shortcuts Bible ALT+P+A+Y+R Arrange – Rotate – Rotate right 90 degree ALT+P+A+Y+L Arrange – Rotate – Rotate left 90 degree ALT+P+A+Y+V Arrange – Rotate – Flip vertical ALT+P+A+Y+H Arrange – Rotate – Flip horizontal ALT+P+A+Y+M Arrange – Rotate – More rotation options FORMULAS TAB ALT KEYS ALT+M Formulas tab ALT+M+F Insert function ALT+M+U Autosum ALT+M+U+S Autosum – Sum ALT+M+U+A Autosum – Average ALT+M+U+C Autosum – Count numbers ALT+M+U+M Autosum – Max ALT+M+U+I Autosum – Min ALT+M+U+F Autosum – Insert more functions ALT+M+R Recently used functions ALT+M+R+F Recently used functions - Insert more functions ALT+M+I Financial function ALT+M+I+F Financial function - Insert more functions ALT+M+L Logical function ALT+M+L+F Logical function - Insert more functions ALT+M+T Text function ALT+M+T+F Text function - Insert more functions ALT+M+E Date & Time function ALT+M+E+F Date & Time function - Insert more functions ALT+M+O Lookup and Reference function ALT+M+O+F Lookup and Reference function - Insert more functions ALT+M+G Math and Trigonometry function ALT+M+G+F Math and Trigonometry function - Insert more functions ALT+M+Q More functions ALT+M+Q+S More functions – Statistical ALT+M+Q+S+M More functions – Statistical – Insert more functions ALT+M+Q+E More functions – Engineering ALT+M+Q+E+M More functions - Engineering – Insert more functions ALT+M+Q+C More functions – Cube ALT+M+Q+C+M More functions - Cube – Insert more functions ALT+M+Q+I More functions – Information ALT+M+Q+I+M More functions - Information – Insert more functions ALT+M+Q+C More functions – Compatibility ALT+M+Q+C+M More functions - Compatibility – Insert more functions ALT+M+Q+W More functions - Web ALT+M+Q+W+M More functions - Web – Insert more functions ALT+M+M Name manager ALT+M+M Define name ALT+M+M+D Define name - Define name ALT+M+M+A Define name - Apply name © eforexcel.com Excel Shortcuts Bible ALT+M+C Create name from selection ALT+M+P Trace precedents ALT+M+D Trace dependents ALT+M+A Remove Arrows ALT+M+A+A Remove Arrows - Remove Arrows ALT+M+A+P Remove Arrows – Remove precedent arrows ALT+M+A+D Remove Arrows – Remove dependent arrows ALT+M+H Toggles show formulas ALT+M+K Error checking ALT+M+K+K Error checking - Error checking ALT+M+K+E Error checking – Trace Error ALT+M+K+C Error checking – Circular reference ALT+M+V Evaluate formula ALT+M+W Watch window ALT+M+X Calculation options ALT+M+X+A Calculation options – Automatic ALT+M+X+E Calculation options – Automatic except for data tables ALT+M+X+M Calculation options - Manual ALT+M+B Calculate now ALT+M+J Calculate sheet ALT+H+A+C Align center ALT+H+A+L Align left ALT+H+A+R Align right ALT+H+M+C Merge and center ALT+H+M+A Merge Across ALT+H+M+M Merge cells ALT+H+M+U Unmerge cells ALT+Shift+Right Arrow Group select rows/columns ALT+Shift+Left Arrow Ungroup select rows/columns ALT+D+P Open pivot tabled wizard ALT+A+M Remove duplicates ALT+A+E Text to columns Wizard ALT+R+S Spell check ALT+M+N Name manager box ALT+M+V Evaluate formula box ALT+M+W Watch Window ALT+M+X+A Automatic ALT+M+X+E Automatic except Data Tables ALT+M+X+M Manual ALT+M+B Calculate Now ALT+M+J Calculate Sheet DATA TAB ALT KEYS ALT+A+F+A From Access ALT+A+F+W From Web ALT+A+F+T From Text © eforexcel.com Excel Shortcuts Bible ALT+A+F+O From Other Sources ALT+A+X Existing Connections ALT+A+R+A Refresh All > Refresh All ALT+A+R+R Refresh All > Refresh ALT+A+R+S Refresh All > Refresh Status ALT+A+R+C Refresh All > Cancel Refresh ALT+A+R+O Refresh All > Connections Properties ALT+A+O Connections ALT+A+P Properties ALT+A+K Edit Links ALT+A+S+A Sort Ascending (Sort A to Z) ALT+A+S+D Sort Descending (Sort Z to A) ALT+A+S+S Custom Sort ALT+A+T Filter ALT+A+C Clear Filter ALT+A+Y+2 Reapply Filter ALT+A+Q Advanced Filter ALT+A+E Text to Columns ALT+A+F+F Flash Fill ALT+A+M Remove Duplicates ALT+A+V+V Data Validation > Data Validation ALT+A+V+I Data Validation > Clear Invalid Data ALT+A+V+R Data Validation > Clear Validation Circles ALT+A+N Consolidate ALT+A+W+S Scenario Manager ALT+A+W+G Goal Seek ALT+A+W+T Data Table ALT+A+A Relationships ALT+A+G+G Group > Group ALT+A+G+A Group > Auto outline ALT+A+U+U Ungroup > Ungroup ALT+A+U+C Ungroup > Clear outline ALT+A+B Subtotal ALT+A+L Advanced Options / Settings for Outline REVIEW TAB ALT KEYS ALT+R+S Spellings ALT+R+R Research ALT+R+E Thesaurus ALT+R+L Translate ALT+R+C New Comment ALT+R+D Delete Comment ALT+R+V Previous Comment ALT+R+N Next Comment ALT+R+H Show / Hide Comments Toggle ALT+R+A All Comments © eforexcel.com Excel Shortcuts Bible ALT+R+I Show Ink ALT+R+P+S Protect Sheet ALT+R+P+W Protect Workbook ALT+R+W Share Workbook ALT+R+O Protect and Share Workbook ALT+R+U Allow users to Edit Range ALT+R+G Track Changes VIEW TAB ALT KEYS ALT+W+L Normal Page view ALT+W+I Page Break Preview ALT+W+P Page Layout view ALT+W+C Custom view ALT+W+R Ruler check/uncheck ALT+W+V+G Gridlines check/uncheck ALT+W+V+F Formula Bar check/uncheck ALT+W+V+H Headings check/uncheck ALT+W+Q Zoom ALT+W+J 100% Zoom ALT+W+N New Window ALT+W+A Arrange All ALT+W+F+F Freeze Panes ALT+W+F+R Freeze Top Row ALT+W+F+C Freeze First Column ALT+W+S Split ALT+W+H Hide ALT+W+U Unhide ALT+W+B View Side by Side ALT+W+V+S Synchronous scrolling ALT+W+T Reset Window position ALT+W+W+1……. Switch Windows ALT+W+M+V View Macros ALT+W+M+R Record Macros ALT+W+M+U Use Relative References DEVELOPER TAB ALT KEYS ALT+L+V Visual Basic Window ALT+L+P+M Macros Window ALT+L+R Record Macro ALT+L+U Use Relative Reference ALT+L+A+S Macro Security ALT+L+H Add ins ALT+L+J Com Add ins © eforexcel.com Excel Shortcuts Bible ALT+L+I+B Form Controls > Button ALT+L+I+C Form Controls > Combo Box ALT+L+I+H Form Controls > Check Box ALT+L+I+S Form Controls > Spin Button ALT+L+I+I Form Controls > List Box ALT+L+I+P Form Controls > Option Button ALT+L+I+G Form Controls > Group Box ALT+L+I+L Form Controls > Label ALT+L+I+S Form Controls > Scroll Bar ALT+L+I+B Active X Controls > Button ALT+L+I+L Active X Controls > List Box ALT+L+I+T Active X Controls > Text Box ALT+L+I+S Active X Controls > Scroll Bar ALT+L+I+N Active X Controls > Spin Button ALT+L+I+O Active X Controls > Option Button ALT+L+I+A Active X Controls > Label ALT+L+I+I Active X Controls > Image ALT+L+ I+G Active X Controls > Toggle Buttons ALT+L+ I+M Active X Controls > More Controls ALT+L+D+M Design Mode ALT+L+L Properties ALT+L+C View Code ALT+L+N Run Dialog ALT+L+X Source ALT+L+O Map Properties ALT+L+S Expansion Packs ALT+L+F Refresh Data Other Useful Shortcut Keys Key Description ARROW Move one cell up, down, left, or right in a worksheet. KEYS CTRL+ARROW KEY moves to the edge of the current data region in a worksheet. SHIFT+ARROW KEY extends the selection of cells by one cell. CTRL+SHIFT+ARROW KEY extends the selection of cells to the last nonblank cell in the same column or row as the active cell, or if the next cell is blank, extends the selection to the next nonblank cell. LEFT ARROW or RIGHT ARROW selects the tab to the left or right when the Ribbon is selected. When a submenu is open or selected, these arrow keys switch between the main menu and the submenu. When a Ribbon tab is selected, these keys navigate the tab buttons. DOWN ARROW or UP ARROW selects the next or previous command when a menu or submenu is open. When a Ribbon tab is selected, these keys navigate up or down the tab group. In a dialog box, arrow keys move between options in an open drop-down list, or between options in a group of options. DOWN ARROW or ALT+DOWN ARROW opens a selected drop-down list. © eforexcel.com Excel Shortcuts Bible BACKSPACE Deletes one character to the left in the Formula Bar. Also clears the content of the active cell. In cell editing mode, it deletes the character to the left of the insertion point. DELETE Removes the cell contents (data and formulas) from selected cells without affecting cell formats or comments. In cell editing mode, it deletes the character to the right of the insertion point. END Moves to the cell in the lower-right corner of the window when SCROLL LOCK is turned on. Also selects the last command on the menu when a menu or submenu is visible. CTRL+END moves to the last cell on a worksheet, in the lowest used row of the rightmost used column. If the cursor is in the formula bar, CTRL+END moves the cursor to the end of the text. CTRL+SHIFT+END extends the selection of cells to the last used cell on the worksheet (lower-right corner). If the cursor is in the formula bar, CTRL+SHIFT+END selects all text in the formula bar from the cursor position to the end—this does not affect the height of the formula bar. ENTER Completes a cell entry from the cell or the Formula Bar, and selects the cell below (by default). In a data form, it moves to the first field in the next record. Opens a selected menu (press F10 to activate the menu bar) or performs the action for a selected command. In a dialog box, it performs the action for the default command button in the dialog box (the button with the bold outline, often the OK button). ALT+ENTER starts a new line in the same cell. CTRL+ENTER fills the selected cell range with the current entry. SHIFT+ENTER completes a cell entry and selects the cell above. ESC Cancels an entry in the cell or Formula Bar. Closes an open menu or submenu, dialog box, or message window. It also closes full screen mode when this mode has been applied, and returns to normal screen mode to display the Ribbon and status bar again. HOME Moves to the beginning of a row in a worksheet. Moves to the cell in the upper-left corner of the window when SCROLL LOCK is turned on. Selects the first command on the menu when a menu or submenu is visible. CTRL+HOME moves to the beginning of a worksheet. CTRL+SHIFT+HOME extends the selection of cells to the beginning of the worksheet. PAGE Moves one screen down in a worksheet. DOWN ALT+PAGE DOWN moves one screen to the right in a worksheet. CTRL+PAGE DOWN moves to the next sheet in a workbook. CTRL+SHIFT+PAGE DOWN selects the current and next sheet in a workbook. PAGE UP Moves one screen up in a worksheet. ALT+PAGE UP moves one screen to the left in a worksheet. CTRL+PAGE UP moves to the previous sheet in a workbook. CTRL+SHIFT+PAGE UP selects the current and previous sheet in a workbook. SPACEBAR In a dialog box, performs the action for the selected button, or selects or clears a check box. © eforexcel.com Excel Shortcuts Bible CTRL+SPACEBAR selects an entire column in a worksheet. SHIFT+SPACEBAR selects an entire row in a worksheet. CTRL+SHIFT+SPACEBAR selects the entire worksheet. If the worksheet contains data, CTRL+SHIFT+SPACEBAR selects the current region. Pressing CTRL+SHIFT+SPACEBAR a second time selects the current region and its summary rows. Pressing CTRL+SHIFT+SPACEBAR a third time selects the entire worksheet. When an object is selected, CTRL+SHIFT+SPACEBAR selects all objects on a worksheet. ALT+SPACEBAR displays the Control menu for the Microsoft Office Excel window. TAB Moves one cell to the right in a worksheet. Moves between unlocked cells in a protected worksheet. Moves to the next option or option group in a dialog box. SHIFT+TAB moves to the previous cell in a worksheet or the previous option in a dialog box. CTRL+TAB switches to the next tab in dialog box. CTRL+SHIFT+TAB switches to the previous tab in a dialog box. ---- End of Document ---- © eforexcel.com

Use Quizgecko on...
Browser
Browser