Looking for a Tutor Near You?

Post Learning Requirement »
x

Choose Country Code

x

Direction

x

Ask a Question

x

x
x
For better view click here
x
Hire a Tutor
DISCOVER

Keyboard Shortcuts

Loading...

Published in: Advanced Excel
3,279 Views

List of keyboard shortcuts for MS Excel, PowerPoint Keep practising and save your TAT at your workplace. Those who are using MAC, they can use the mac keyboard shortcut list and make a difference.

Prabhas P / Pune

18 years of teaching experience

Qualification: MBA/PGDM (University of Madras, Chennai - 2009)

Teaches: Advanced Excel, MS Office

Contact this Tutor
  1. BREAKING INTO WALLSTREET The Fundamentals Mac Excel 2008 / 2011+ Quick Reference — The Most Important Keyboard Shortcuts for Finance (1B, PE, HF/AM, ER, CF, etc.) http://breakingintowallstreet.com Rows & Columns Basic Formatting 3€ F12 Esc o S c x z Ctrl + H Tab Open File New File Print Save File Save File AS Close File Close Excel Exit Dialog Copy Cut Undo Redo Select All Find Replace Switch Windows Options Menu Repeat Last Action Ctrl + Spacebar Shift + Spacebar Ctrl + I Ctrl + Right Mouse Button + E Shift + K Shift + Alt + Right 3€ Shift + J Shift + Alt + Left Ctrl + O Ctrl + Shift + O Ctrl + 9 Ctrl + Shift + 9 Select Column Select Row Insert Cells / Rows / Columns Delete Cells / Rows / Columns Insert Cut Cells and Shift Over Group Rows / Columns Group Rows / Columns Ungroup Rows / Columns Ungroup Rows / Columns Hide Columns Show Columns Hide Rows Show Rows + Option + R Show/Hide Ribbon Menu Navigation & Data Selection Workbooks & Worksheets Arrow Keys Ctrl + Arrows Shift + Arrows Shift + Ctrl + Arrows Shift + F8 Move Around Jump to Boundary Select Cells Select to Boundary Select Multiple Areas Ctrl + Tab Shift + Fli No shortcut Ctrl + Fn + Up Ctrl + Fn + Down No shortcut Shift + Ctrl + Fn + Up / Down No shortcuts New Workbook Switch Workbook New Worksheet Del Worksheet Move to Left Worksheet Move to Right Worksheet Move / Copy Worksheet Select Multiple Worksheets Hide Worksheet Show Worksheet Rename Worksheet Color Tab 1 Ctrl + V Ctrl + V, Ctrl + V, Ctrl + V, 1, Alignment -k Shift -k -k Alt + O -k Alt + Shift + Ctrl + Shift + Ctrl + ! Shift + Ctrl + @ Shift + Ctrl + # Shift + Ctrl + $ Shift + Ctrl + % Shift + Ctrl + TEXT(Cell, Format) No shortcuts No shortcut Format Dialog Paste Special Paste Formats Paste Values Paste Formulas Align Left / Center/ Right Change Indent Bold Italics Underline Strikethrough Add Borders Delete Borders Number Time Date Currency Percentage Scientific Displays cell using custom format Auto-Fit Col. Auto-Fit Row Column Width Row Height Conditional Formatting Editing Cells Ctrl + U Del Ctrl + Arrows Ctrl + Shift + Arrows Ctrl + Option + Enter Ctrl + Enter / Tab / Shift + Tab Edit Cell Delete Cell Contents Skip Word(s) Highlight Word(s) New Line in Cell Edit and... Stay in Place / Go Left / Go Right
  2. BREAKING INTO WALLSTREET Dates & Times Mac Excel 2008 / 2011+ Quick Reference — The Most Important Keyboard Shortcuts for Finance (1B, PE, HF/AM, ER, CF, etc.) Formulas and Calculations http://breakingintowallstreet.com Common Built-In Functions DATE (Year, Month, Day) Creates new Date NETWORKDAYS Business days (Start, End Date) EOMONTH (Start Date, # Months) Ctrl + • in between 2 dates Last day of month after # months Current Time Current Date Text Tools & Functions No shortcut -LEFT RIGHT MID -FIND SEARCH -LEN SUBSTITUTE REPLACE No shortcut TRIM -PROPER UPPER -LOWER Text File Import Chars from left Chars from right Chars from... Search for text within text Same, but not case sensitive Length of text Replace text in text with search Same, but use position instead Text to Columns Deletes Extra Spaces Capitalize All First Letters Make All caps Make All Lower Ctrl + L Tab Shift + F3 Ctrl + V, Ctrl + V, Ctrl + D Ctrl + R Ctrl + Ctrl + Value If Error) Enter Formula Refresh All Anchor Cell Name Cell Jump to Cell Use Suggested Name Enter Built-ln Function Paste Formulas Paste Formats & Formulas Copy Down Copy Right Copy from Above Go to Formulas Go to Constants Show Formulas Calculates only if no error Lookups & Related Functions SUM + Shift + T COUNT AVERAGE MAX MIN SUMIF / SUMIFS COUNTIF / COUNTIFS SUMPRODUCT ABS OR AND NPV (Discount Rate, Cash Flows) XNPV (Rate, Values, Dates) =IRR (Values) XIRR (Values, Dates) Sum Numbers Sum Adjacent Cells Count # Entries Average Maximum Minimum Conditional Sum Conditional Count Multiply and Sum Range Absolute Value Conditional One Must Be True All Must Be True Net Present Value of Cash Flows NPV with irregular dates Internal Rate of Return of Investment IRR with irregular dates VLOOKUP (Value, Table, Column #) HLOOKUP (Value, Table, Row MATCH (Value, Row or Column Range) -INDEX (Table, Row Col =INDIRECT (Ref) ADDRESS (Row # , Col # ) Match Value in Left Column and Return from Column # Match Value in Top Row and Return from Row # Find Item's Position in Row/Column Return Item at Row # and Column # Returns cell at reference given by text Creates cell reference Database and Array Functions Display & Printing No shortcut Ctrl + + Mouse Scroll Wheel No shortcuts Freeze Panes Zoom Page Setup Set Print Range to Selected Area Print Preview Page Break View Normal View Toggle Gridlines DSUM (DB, Field, Criteria) DCOUNT (DB, Field, Criteria) Ctrl + Shift + Enter TRANSPOSE (Rows or Columns) Sums records that match criteria Counts records that match criteria Enter Array Function Converts rows to columns and vice versa
  3. BREAKING INTO WALLSTREET Auditing Formulas Mac Excel 2008 / 2011+ Quick Reference — The Most Important Keyboard Shortcuts for Finance (1B, PE, HF/AM, ER, CF, etc.) Filtering, Sorting & Validating http://breakingintowallstreet.com Macros, VBA, and Forms Ctrl + [ Ctrl + ] No shortcuts Shift + Ctrl + { Shift + Ctrl + } F5 + Enter Shift + F2 Shift + F2 + Del No shortcut Immediate Precedents Immediate Dependents Trace Precedents Trace Dependents Erase Traces All Precedents All Dependents Jump to Original Cell Add/Edit Comment Del Comment Show All Comments Highlight Cells w/ Comments Shift + R No shortcuts Shift + F No shortcut Right Mouse Button + E + V No shortcut No shortcut Data Validation Settings Input Message Error Alert Validation criterva; Allow: Sort Data Sort Ascending Sort Descending Filter Data Advanced Data Filter Filter by Cell's Properties Remove Duplicates Validate Data No shortcuts Option + F8 Record Macro Macro name: Color Code Shortcut key: Ctrl-Shift* C Store macro in: This Workbook Description: VBA Editor Run Macro Object Browser Immediate Window Form Control Use Relative References Record Macro View Macros Q] In-cell dropdown between -SES13:5ES15 Z] Apuly these changes to all other cells With the same Operating Case: Pivot Tables ettvngs Cancel 2 1 2 3 No shortcut Pivot Table ent anservetive se anagement Color codes cells black, blue, and green. Graphs & Charts PivotTable Fields Choose fields ta add to report: Name Company Name Telephone Address City State Region Order Dollar Amount Order Date Order Time C] Sales REP ID MORE TABLES..v Drag fields between areas below: Y FILTERS ut Data By... Cal ulate... Scenarios & Sensitivities CHOOSE (Number, Iteml, Item2.. • ) OFFSET(Cell, # Rows, # Cols) No shortcuts Select from List based on Number Move # of Rows and Columns from Cell Scenario Manager Goal Seek Data Table No shortcuts Wal-Mart Stores, Inc. - Net Present Value Sensitivity - Terminal Growth Rates Discount Rate 5.0% 5.5% Column Chart Line Chart Pie Chart Bar Chart Text Box Combo Chart Recommended Chart Add Chart Element Design Tab Layout Tab Format Tab 2.8% 2.3% 1.8% 1.3% 0.8% 0.3% 4.5% Data Table Bow input cell: Column input cell; Cancel 125.00 108.51 95.90 85.95 77.89 71.24 Row Input Cell = Discount Rate Column Input Cell Terminal Growth Rate
  4. BREAKING INTO WALLSTREET Mac Excel 2008 / 2011+ Quick Reference — The Most Important Keyboard Shortcuts for Finance (1B, PE, HF/AM, ER, CF, etc.) http://breakingintowallstreet.com Custom Number Formats Format Cells Number Alignment Categonj: General Number Currency Accounting Date Time Percentage Fraction Scientific S ecial CUSta m Font Border Sample Iype: Fill Protection Example Data: 5 -1200 Wal-Mart Displayed As: 5.0x (1,200.00) Balanced! Used For: Valuation Multiples Negative Expenses Balance Sheet Checks Model - Wal-Mart Titles & Headers [81ue]O.O - h." mm mnvss mm:ssv0 Blue 0.0 x: Re - Text on Left: [Blue]O.O - Tyge the number format code, using one of the existing codes as d starting point. Delete Remove 1. 2. 3. 4. The order for Custom Number Formats is: [Positive Style]; [Negative Style]; [Zero Style]; [Text Style] If you include the "@" symbol and text, the text will appear and the "@" will be replaced by what's in the cell. [Red] and [Blue] can be used for color coding. For more on custom number formats, please see our separate guide — this is just a brief summary. Categories: Edit View Insert Format Tools Data Current keys: Control* Z Command Press new shortcut key: Descri ption Undo (Edit menu) Customize keyboard Edit Undo Redo cut Copy Paste Paste Special... Formatting Custom Keyboard Shortcuts — Mac Excel 2008 / 2011+ In the Mac versions of Excel, you have to go to the "Tools" menu (it may be under "File" and then "Options" depending on the Excel version) and then select "Customize Keyboard" there to create these shortcuts. See the screenshot to the left — these shortcuts work the same way mechanically as on Windows, but the dialog box to create them looks different and you have to access that dialog box differently. Reverses the last command or deletes the last entry you typed. To reverse more than one action at a time, click the arrow next to the Undo button, and then click the actions you want to undo. The command name changes to Can't Undo if you cannot reverse the last action.
  5. BREAKING INTO WALLSTREET Mac Excel 2008 / 2011+ Quick Reference — The Most Important Keyboard Shortcuts for Finance (1B, PE, HF/AM, ER, CF, etc.) http://breakingintowallstreet.com The Optimal Excel Settings - IMPORTANT! You have to go through a bunch of different steps to get Mac Excel to work properly. Let's review those steps: STEP 1: Go to System Preferences (98 + ,) outside of Excel and select the "Keyboard" (see screenshot on the right): STEP 2: Then, go to the "Keyboard Shortcuts" tab and then "Keyboard & Text Input" and change the following options (see screenshot below): Show All To change a shortcut. double-click the shortcut and hold down the new keys. 000 personal General Desktop & Screen Saver Hardware COS & DVDs Displays Internet & Wireless iCtoud Mail, Contacts System Preferences Security & Privacy Trackpad Spotlight Print & Scan Energy Network Date & Time Mission Control keyboard Bluetooth Software update Language & Text Mouse Sharing System Users & Groups calendars Parental Controls Notifications Sound Startup Disk Dashboard & Dock Exposé & Spaces Front Row Keyboard & Text Input Screen Shots Services Spotlight @ Universal Access Application Shortcuts Dictation Time Machine Accessibility & Speech Move ocusto e Doc focus to active or next window ove focus to the window toolbar ve focus to the floating window M focus to next window in app'... MO focus to the window drawer MO focus to Status menus Selec the previous input source Select Xt source in Input menu *Space •€9€Space Restore Defaults Full Keyboard Access: In windows and dialogs. pr ss Tab to move keyboard focus between: nd lists only r• All controls Press to change this seWng, Make sure both of these are SELECTED. STEP 3: Then, go into the Excel Preferences or Options menu within Excel by pressing 9€ + , inside the program and make the following changes: Back/Forward Authoring General Excel Preferences Show All View Search Excel Preferences Can disable / change these if you're a Chart power user. Formulas and Lists Calculation Error Checking Sharing and Privacy Edit Custom Lists Security Teh Aut ct sup AutoComplete Feedback Tables Ribbon Filter Save Set Compatibility alculations to "Automatic Except Data Tables" and Enable Iterative Calculations.
  6. BREAKING INTO WALLSTREET Mac Excel 2008 / 2011+ Quick Reference — The Most Important Keyboard Shortcuts for Finance (1B, PE, HF/AM, ER, CF, etc.) http://breakingintowallstreet.com STEP 4: Now, go back to the System Preferences menu outside of Excel and select Exposé & Spaces and/or "Keyboard" (depending on wha€s visible on your screen). If you leave the Mac on its default settings, built-in shortcuts in the system software may interfere with essential Excel shortcuts such as Ctrl + Spacebar, so we're going to disable some of that functionality in this part of the process. STEP 5: Uncheck "Enable Spaces" if you actually have the Exposé & Spaces option and it looks something like the menu below: System Preferences Personal Appearance Hardware CDS & DVDS Show All Desktop & Screen Saver D splays Dock Energy Bluetooth Parental Controls Exposé & Spaces Keyboard Sharing Software update Lang uage & Text Mouse Speech 10 Security print & fax Spotlight Internet & Wireless Startup Disk Time Machine Universal Access Exposé Spaces Make sure this is UNCHECKED Exposé • Spaces "q Mobile Me System Accounts Other Picker e Network Oate & Time HMV Flig4Mac Spaces i e t s organize your into groups to reduce desktop Clutter. Enable Spaces IC Show Spaces in menu bar ROWS Columns: @ Soace STEP 6: Now, within the "Keyboard" option (if that's available), go to "Keyboard Shortcuts" and then "Mission Control" and DISABLE the shortcuts shown on the right. They should be the OPPOSITE of what's in this screenshot. Yes, we should really find a screenshot that has both of these unchecked and disabled — it's on the list (I don't have a Mac setup myself, which makes this difficult). STEP 7: Go to "Spotlight" on the left-hand side and make sure "Show Spotlight Search Field" is DISABLED. See the screenshot below: eon Keyboard Kevboard Shortcuv. To change a shortcut. doub eon Keyboard Keyboard Keyboard Shortcuts TO change a shortcut, double—click the shortcut and hold down the new keys. Launchpad & Dock Display Mission Control Keyboard & Text Input Screen Shots Services Spotlight @ Universal Access Application Shortcuts Mission Control Application windows Show Desktop Show Dashboard Move left a space Move right a space Switch to Desktop 1 Switch to Desktop 2 Switch to Desktop 3 Switch to Desktop 4 You should FIO UNCHECK both of these: Fll F12 Launchpad & Dock Mission Control Keyboard & Text.. Screen Shots Services Spotlight Application Shor... Show Spotlight search field U Show Spotlight window # Space %Space Restore Defaults Full Keyboard Access; In Windows and dialogs. press Tab to move keyboard focus between: @Text boxes and lists only Q) All controls Press Control+F7 to Change this setting.

Need a Tutor or Coaching Class?

Post an enquiry and get instant responses from qualified and experienced tutors.

Post Requirement

Related Study Notes

Upload Study Notes

If you have your own Study Notes which you think can benefit others, please upload on LearnPick. For each approved Study Note you will get 100 Credit Points and 100 Activity Score which will increase your profile visibility.

Upload Now
Home > Study Notes > Keyboard Shortcuts