Shortcut_Keys_2003_2007_Mac_v5.0a

Shortcut_Keys_2003_2007_Mac_v5.0a - Commonly Used Shortcut...

Info iconThis preview shows page 1. Sign up to view the full content.

View Full Document Right Arrow Icon
This is the end of the preview. Sign up to access the rest of the document.

Unformatted text preview: Commonly Used Shortcut Keys Excel 97-2003 v 5.0 Action Keystroke Action Keystroke 1 Anchoring cells F4 (in edit cell mode (F2)) 25 Go to end (contiguous range) Ctrl+Arrow Keys 2 Auditing toolbar Alt T U 26 Go to precedent cell(s) / Return Ctrl+[ / F5, Enter 3 ...Trace precedents Alt T U T 27 Group rows or columns Alt D G or (Shift+Alt+ ) 4 ...Trace dependents Alt T U D 28 ...Hide grouped range Alt D G H 5 ...Remove arrows Alt T U A 29 ...Show grouped range Alt D G S 6 Auto sum Alt+= 30 ...Ungroup rows or columns Alt D G or (Shift+Alt+ ) 7 Borders – outside area Ctrl+Shift+7 31 Highlight a contiguous range Ctrl+Shift+Arrow Keys 8 Borders – remove all Ctrl+Underscore (Ctrl+Shift+–) 32 Highlight entire column / row Ctrl+Spacebar / Shift+Spacebar 9 Clear Alt E A 33 Move a sheet / Copy a sheet Alt E M / Alt E M, Alt+C 10 Comment – inserting Shift+F2 or (Alt I M) 34 Name a cell Alt I N D or (Ctrl+F3) 11 Comment – deleting Alt E A M 35 Page Break Preview / Normal Alt V P / Alt V N 12 Copy / Cut Ctrl+C / Ctrl+X 36 Page setup… Alt F U… 13 … Paste (after copy or cut) Ctrl+V or (Enter) 37 Print Ctrl+P or (Alt F P) 14 Copy, Paste special formats Ctrl+C, Alt E S T 38 Print preview Alt F V 15 Copy, Paste special formulas Ctrl+C, Alt E S F 39 Redo Ctrl+Y 16 Delete / Insert Ctrl+– / Ctrl++ 40 Rename sheet Alt O H R 17 Deselect to original cell Shift+Backspace 41 Repeat F4 18 Edit cell / Highlight precedents F2 42 Replace Ctrl+H 19 Fill right / Fill down Ctrl+R / Ctrl+D 43 Set print area Alt F T S 20 Font – change size Ctrl+Shift+P 44 Tools options Alt T O… 21 Format cells… Ctrl+1 or (Alt O E) 45 Undo Ctrl+Z 22 Function – inserting Alt I F or (Shift+F3) 46 Workbooks – toggle Ctrl+Tab 23 Go to F5 or (Ctrl+G) 47 Worksheets – move between Ctrl+Page Up / Ctrl+Page Down 24 Go to constants (highlight inputs) F5, Alt+S O X 48 Zoom – sizing / return to 100% Alt V Z / Alt V Z 1 *These shortcuts will not work properly for Parallels, VM ware, or Boot Camp without first making some changes to your keyboard settings. Please see TTS’s Setting Up Your Mac for detailed instructions. Additionally, please hold down the Function key on your Mac to use the Page Up/Page Down, Home, End, & Delete functions. © 1999-2010 Training The Street, Inc. All rights reserved. 1 Commonly Used Functions Excel 97-2003 v 5.0 To insert a function in a cell, use either Alt I F or Shift+F3 (“Function Wizard”). Note: If typing the syntax of a formula, Ctrl+A shows the function arguments. Type of Function Absolute function And function Choose function Columns function Comp. annual growth rate Count function Hlookup function If statement Indirect function Match function Net present value Offset function Or function Sum-of-years digits deprec. Text function Vlookup function Common Use Parity check If statement logic Scenarios To count N periods (e.g., rate function) IRR and growth over a period (1) Data mining Used to reference inputs on an output page Error handling and switches Used to change references within a formula Used to search for specific items in a cell range Discounted cash flow analysis (2) Scenarios If statement logic Modeling depreciation Footnotes, titles, and subtitles Used to reference inputs on an output page (1) Compound annual growth rate formula: ⎡⎛ FV ⎞ ⎤ ⎢⎜ ⎟ ⎥− 1 ⎢⎝ PV ⎠ ⎥ ⎣ ⎦ 1 N © 1999-2010 Training The Street, Inc. All rights reserved. Formula =ABS(number) =AND(logical argument1, logical argument2…..) =CHOOSE(index number, value1, value2…..) =COLUMNS(reference range) =RATE(periods, payment, -PV, FV, type) =COUNT(value1, value2, value3…..) =HLOOKUP(lookup, array, row index, range lookup) =IF(logical test, value if true, value if false) =INDIRECT(ref_text, [a1]) =MATCH(lookup_value,lookup_array,[match_type]) =NPV(rate, value1, value2, value3…..) =OFFSET(reference, rows, columns, height, width) =OR(logical argument1, logical argument2…..) =SYD(cost, salvage, life, period) =TEXT(value, “format of text”) =VLOOKUP(lookup, array, col. index, range lookup) (2) Net present value formula: CF1 CF2 CFN + + ... 1 2 (1 + r) (1 + r) (1 + r)N 2 Commonly Used Shortcut Keys Excel 2007 v 5.0 Action Keystroke Action Keystroke 1 Anchoring cells F4 (in edit cell mode (F2)) 25 Go to end (contiguous range) Ctrl+Arrow Keys 2 Auditing toolbar Alt M… (See "Formula Auditing") 26 Go to precedent cell(s) / Return Ctrl+[ / F5, Enter 3 ...Trace precedents Alt M P 27 Group rows or columns Alt A G G or (Shift+Alt+ ) 4 ...Trace dependents Alt M D 28 ...Hide grouped range Alt A H 5 ...Remove arrows Alt M A A 29 ...Show grouped range Alt A J 6 Auto sum Alt+= 30 ...Ungroup rows or columns Alt A U U or (Shift+Alt+ ) 7 Borders – outside area Ctrl+Shift+7 31 Highlight a contiguous range Ctrl+Shift+Arrow Keys 8 Borders – remove all Ctrl+Underscore (Ctrl+Shift+–) 32 Highlight entire column / row Ctrl+Spacebar / Shift+Spacebar 9 Clear Alt H E 33 Move a sheet / Copy a sheet Alt H O M, Alt+C 10 Comment – inserting Shift+F2 or (Alt R C) 34 Name a cell Alt M M D or (Alt M N N) or (Ctrl+F3) 11 Comment – deleting Alt R D 35 Page Break Preview / Normal Alt W I / Alt W L 12 Copy / Cut Ctrl+C / Ctrl+X 36 Page setup… Alt P S P 13 … Paste (after copy or cut) Ctrl+V or (Enter) 37 Print Ctrl+P or (Alt F P) 14 Copy, Paste special formats Ctrl+C, Alt H V S T or (Ctrl+Alt+V T) 38 Print preview Alt F W V or (Ctrl + F2) 15 Copy, Paste special formulas Ctrl+C, Alt H V F or (Ctrl+Alt+V F) 39 Redo Ctrl+Y 16 Delete / Insert Ctrl+– / Ctrl++ 40 Rename sheet Alt H O R 17 Deselect to original cell Shift+Backspace 41 Repeat F4 18 Edit cell / Highlight precedents F2 42 Replace Ctrl+H 19 Fill right / Fill down Ctrl+R / Ctrl+D 43 Set print area Alt P R S 20 Font – change size Alt H F S or (Ctrl+Shift+P, Alt S) 44 Tools (Excel) options Alt F I… 21 Format cells… Ctrl+1 or (Alt H O E) 45 Undo Ctrl+Z 22 Function – inserting Alt M F or (Shift+F3) 46 Workbooks – toggle Ctrl+Tab 23 Go to F5 or (Ctrl+G) 47 Worksheets – move between Ctrl+Page Up / Ctrl+Page Down 24 Go to constants (highlight inputs) F5, Alt+S O X 48 Zoom – sizing / return to 100% Alt W Q / Alt W J *These shortcuts will not work properly for Parallels, VM ware, or Boot Camp without first making some changes to your keyboard settings. Please see TTS’s Setting Up Your Mac for detailed instructions. Additionally, please hold down the Function key on your Mac to use the Page Up/Page Down, Home, End, & Delete functions. © 1999-2010 Training The Street, Inc. All rights reserved. 3 Commonly Used Functions Excel 2007 v 5.0 To insert a function in a cell, use either Alt M F or Shift+F3 (“Function Wizard”). Note: If typing the syntax of a formula, Ctrl+A shows the function arguments. Type of Function Absolute function And function Choose function Columns function Comp. annual growth rate Count function Hlookup function If statement Indirect function Match function Net present value Offset function Or function Sum-of-years digits deprec. Text function Vlookup function Common Use Parity check If statement logic Scenarios To count N periods (e.g., rate function) IRR and growth over a period (1) Data mining Used to reference inputs on an output page Error handling and switches Used to change references within a formula Used to search for specific items in a cell range Discounted cash flow analysis (2) Scenarios If statement logic Modeling depreciation Footnotes, titles, and subtitles Used to reference inputs on an output page (1) Compound annual growth rate formula: ⎡⎛ FV ⎞ ⎤ ⎢⎜ ⎟ ⎥− 1 ⎢⎝ PV ⎠ ⎥ ⎣ ⎦ 1 N © 1999-2010 Training The Street, Inc. All rights reserved. Formula =ABS(number) =AND(logical argument1, logical argument2…..) =CHOOSE(index number, value1, value2…..) =COLUMNS(reference range) =RATE(periods, payment, -PV, FV, type) =COUNT(value1, value2, value3…..) =HLOOKUP(lookup, array, row index, range lookup) =IF(logical test, value if true, value if false) =INDIRECT(ref_text, [a1]) =MATCH(lookup_value,lookup_array,[match_type]) =NPV(rate, value1, value2, value3…..) =OFFSET(reference, rows, columns, height, width) =OR(logical argument1, logical argument2…..) =SYD(cost, salvage, life, period) =TEXT(value, “format of text”) =VLOOKUP(lookup, array, col. index, range lookup) (2) Net present value formula: CF1 CF2 CFN + + ... 1 2 (1 + r) (1 + r) (1 + r)N 4 Commonly Used Shortcut Keys Mac Excel 2008 OS X Tiger 10.4.9 or higher v 5.0 Action Keystroke Action Keystroke 1 Anchoring cells Cmd+T (in edit cell mode (Ctrl+U)) 25 Go to end (contiguous range) Ctrl+Arrow Keys 2 Auditing toolbar Ctrl+F2 T Enter AU Enter 26 Go to precedent cell(s) / Return Ctrl+ [ (Open Bracket) / F5 Enter 3 ...Trace precedents Ctrl+F2 T Enter AU Enter Enter 27 Group rows or columns Cmd+Shift+K 4 ...Trace dependents Ctrl+F2 T Enter AU Enter T 28 ...Hide grouped range Ctrl+F2 D Enter GR Enter H Enter 5 ...Remove arrows Ctrl+F2 T Enter AU Enter A 29 ...Show grouped range Ctrl+F2 D Enter GR Enter SH Enter 6 Auto sum Cmd+Shift+T 30 ...Ungroup rows or columns Cmd+Shift+J 7 Borders – outside area Borders – remove all Cmd+Option+0 (zero) Cmd+Option+ (minus) 31 8 32 Highlight a contiguous range Highlight entire column / row Ctrl+Shift+Arrow Keys Ctrl+Spacebar / Shift+Spacebar 9 Clear All Ctrl+F2 E Enter A Enter 33 Move a sheet / Copy a sheet Ctrl+F2 E Enter M / (Cmd+R) 10 Comment – insert or read Shift+F2 34 Name a cell Ctrl+L 11 Comment – delete Ctrl+F2 E Enter C Enter C Enter 35 Page Break Preview / Normal Ctrl+F2 V Enter P Enter / N Enter 12 Copy / Cut Ctrl (or Cmd)+C / Ctrl (or Cmd)+X 36 Page setup… Ctrl+F2 F Enter P Enter 13 … Paste (after copy or cut) Ctrl (or Cmd+V or Enter) 37 Print Ctrl+P 14 Copy, Paste special formats Ctrl+F2 E Enter Paste Special, Cmd+T 38 Print preview Ctrl+F2 F Enter 15 Copy, Paste special formulas Delete / Insert Ctrl+F2 E Enter Paste Special, Cmd+F 39 16 40 Redo Rename sheet Cmd+Y Ctrl+F2 FO Enter S Enter Enter 17 Deselect to original cell Shift+Backspace 41 Repeat Cmd+Y 18 Edit cell / Highlight precedents Ctrl+U 42 Replace Ctrl+H Ctrl+R / Ctrl+D Cmd+Shift+ (period) / (comma) 43 Fill right / Fill down 20 Font – change size 19 - Ctrl+ - (minus) / Ctrl+ I . , Set print area 44 Tools (Excel) options Print Preview Ctrl+F2 F Enter PR Enter Cmd+ (comma) , 21 Format cells… Cmd+1 45 Undo Ctrl (or Cmd)+Z 22 Function – inserting Shift+F3 46 Workbooks – toggle Ctrl+Tab 23 Go to F5 (or Ctrl+G) 47 Worksheets – move between Fn+Ctrl+ Down Arrow / Up Arrow 24 Go to constants (highlight inputs) F5 Cmd+S Cmd+O Cmd+X Enter 48 Zoom – sizing / (return to 100%) Ctrl+F2 V Enter Z Enter / (Cmd+1) *These shortcuts will not work properly without first making some changes to your keyboard settings. Please see TTS’s Setting Up Your Mac for detailed instructions. Additionally, please hold down the Function key on your Mac to use the Page Up/Page Down, Home, End, & Delete functions. © 1999-2010 Training The Street, Inc. All rights reserved. Cmd = 5 Commonly Used Functions Mac Excel 2008 OS X Tiger 10.4.9 or higher v 5.0 To insert a function in a cell, use either Ctrl+A or Shift+F3 (“Formula Builder”). Note: If typing the syntax of a formula, Ctrl+A shows the function arguments. Type of Function Absolute function And function Choose function Columns function Comp. annual growth rate Count function Hlookup function If statement Indirect function Match function Net present value Offset function Or function Sum-of-years digits deprec. Text function Vlookup function Common Use Parity check If statement logic Scenarios To count N periods (e.g., rate function) IRR and growth over a period (1) Data mining Used to reference inputs on an output page Error handling and switches Used to change references within a formula Used to search for specific items in a cell range Discounted cash flow analysis (2) Scenarios If statement logic Modeling depreciation Footnotes, titles, and subtitles Used to reference inputs on an output page (1) Compound annual growth rate formula: ⎡⎛ FV ⎞ ⎤ ⎢⎜ ⎟ ⎥− 1 ⎢⎝ PV ⎠ ⎥ ⎣ ⎦ 1 N © 1999-2010 Training The Street, Inc. All rights reserved. Formula =ABS(number) =AND(logical argument1, logical argument2…..) =CHOOSE(index number, value1, value2…..) =COLUMNS(reference range) =RATE(periods, payment, -PV, FV, type) =COUNT(value1, value2, value3…..) =HLOOKUP(lookup, array, row index, range lookup) =IF(logical test, value if true, value if false) =INDIRECT(ref_text, [a1]) =MATCH(lookup_value,lookup_array, [match_type]) =NPV(rate, value1, value2, value3…..) =OFFSET(reference, rows, columns, height, width) =OR(logical argument1, logical argument2…..) =SYD(cost, salvage, life, period) =TEXT(value, “format of text”) =VLOOKUP(lookup, array, col. index, range lookup) (2) Net present value formula: CF1 CF2 CFN + + ... 1 2 (1 + r) (1 + r) (1 + r)N 6 ...
View Full Document

Ask a homework question - tutors are online