Essay on Microsoft Excel and Alt

Submitted By LalAmritashwar1
Words: 2353
Pages: 10
Open Document
Commonly Used Shortcut Keys v6.0 Excel 97-2003

Action
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24

Keystroke
F4 (in edit cell mode (F2)) Alt T U Alt T U T Alt T U D Alt T U A Alt+= Ctrl+Shift+7 Ctrl+Underscore (Ctrl+Shift+–) Alt E A Shift+F2 or (Alt I M) Alt E A M Ctrl+C / Ctrl+X Ctrl+V or (Enter) Ctrl+C, Alt E S T Ctrl+C, Alt E S F Ctrl+– / Ctrl++ Shift+Backspace F2 Ctrl+R / Ctrl+D Ctrl+Shift+P Ctrl+1 or (Alt O E) Alt I F or (Shift+F3) F5 or (Ctrl+G)
25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48

Action
Go to end (contiguous range) Group rows or columns ...Hide grouped range ...Show grouped range ...Ungroup rows or columns Highlight a contiguous range Highlight entire column / row Move a sheet / Copy a sheet Name a cell Page Break Preview / Normal Page setup… Print Print preview Redo Rename sheet Repeat Replace Set print area Tools options Undo Workbooks – toggle Worksheets – move between Zoom – sizing / return to 100%

Keystroke
Ctrl+Arrow Keys Alt D G or (Shift+Alt+) Alt D G H Alt D G S Alt D G or (Shift+Alt+) Ctrl+Shift+Arrow Keys Ctrl+Spacebar / Shift+Spacebar Alt E M / Alt E M, Alt+C Alt I N D or (Ctrl+F3) Alt V P / Alt V N Alt F U… Ctrl+P or (Alt F P) Alt F V Ctrl+Y Alt O H R F4 Ctrl+H Alt F T S Alt T O… Ctrl+Z Ctrl+Tab Ctrl+Page Up / Ctrl+Page Down Alt V Z / Alt V Z 1
Preparing Financial Professionals for Success

Anchoring cells Auditing toolbar ...Trace precedents ...Trace dependents ...Remove arrows Auto sum Borders – outside area Borders – remove all Clear Comment – inserting Comment – deleting Copy / Cut … Paste (after copy or cut) Copy, Paste special formats Copy, Paste special formulas Delete / Insert Deselect to original cell Edit cell / Highlight precedents Fill right / Fill down Font – change size Format cells… Function – inserting Go to

Go to precedent cell(s) / Return Ctrl+[ / F5, Enter

Go to constants (highlight inputs) F5, Alt+S O X

© 1999-2012 All rights reserved.

Commonly Used Functions

Excel 97-2003

© 1999-2012 All rights reserved.

Preparing Financial Professionals for Success

Commonly Used Shortcut Keys v6.0 Excel 2007

Action
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24

Keystroke
F4 (in edit cell mode (F2)) Alt M… (See "Formula Auditing") Alt M P Alt M D Alt M A A Alt+= Ctrl+Shift+7 Ctrl+Underscore (Ctrl+Shift+–) Alt H E Shift+F2 or (Alt R C) Alt R D Ctrl+C / Ctrl+X Ctrl+V or (Enter) Ctrl+C, Alt H V S T or (Ctrl+Alt+V T) Ctrl+C, Alt H V F or (Ctrl+Alt+V F) Ctrl+– / Ctrl++ Shift+Backspace F2 Ctrl+R / Ctrl+D Alt H F S or (Ctrl+Shift+P, Alt S) Ctrl+1 or (Alt H O E) Alt M F or (Shift+F3) F5 or (Ctrl+G)
25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48

Action
Go to end (contiguous range) Group rows or columns ...Hide grouped range ...Show grouped range ...Ungroup rows or columns Highlight a contiguous range Highlight entire column / row Move a sheet / Copy a sheet Name a cell Page Break Preview / Normal Page setup… Print Print preview Redo Rename sheet Repeat Replace Set print area Tools (Excel) options Undo Workbooks – toggle Worksheets – move between Zoom – sizing / return to 100%

Keystroke
Ctrl+Arrow Keys Alt A G G or (Shift+Alt+) Alt A H Alt A J Alt A U U or (Shift+Alt+) Ctrl+Shift+Arrow Keys Ctrl+Spacebar / Shift+Spacebar Alt H O M, Alt+C Alt M M D or (Alt M N N) or (Ctrl+F3) Alt W I / Alt W L Alt P S P Ctrl+P or (Alt F P) Alt F W V or (Ctrl + F2) Ctrl+Y Alt H O R F4 Ctrl+H Alt P R S Alt F I… Ctrl+Z Ctrl+Tab Ctrl+Page Up / Ctrl+Page Down Alt W Q / Alt W J
Preparing Financial Professionals for Success

Anchoring cells Auditing toolbar ...Trace precedents ...Trace dependents ...Remove arrows Auto sum Borders – outside area Borders – remove all Clear Comment – inserting Comment – deleting Copy / Cut … Paste (after copy or cut) Copy, Paste special formats Copy, Paste special formulas Delete / Insert Deselect to original cell Edit cell / Highlight
Show More

Related Documents: Essay on Microsoft Excel and Alt

My Resume Essay

Amanda Martin 5220 Harrison Forest Way Knoxville, TN 37921 newday103010@yahoo.com Phone: 865-385-7353 Alt: 865-985-0123 SUMMARY: I have good people skills, very well organized, and a team player. I can use Excel, Word, Microsoft Office. I am a quick learner when it comes to things that I have never done before. EXPERIENCE: September 2012 to Present Reinhart Food Service transportation dispatch Louisville, TN I make sure that all of the drivers have all paperwork need to be able to deliver…

Words 911 - Pages 4

PowerPoint2010SBS 9780735626911 SampleC Essay

Sample Chapters Copyright © 2010 by Online Training Solutions, Inc. All rights reserved. To learn more about this book visit Microsoft Learning at: http://go.microsoft.com/fwlink/?LinkId=192149 Contents Introducing Microsoft PowerPoint 2010 . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . ix Modifying the Display of the Ribbon . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . xiii Features and Conventions of This Book . . . . .…

Words 9219 - Pages 37

Questions On Strong Security

requires GDI+ (which can be downloaded for free at Microsoft's website). Windows XP and higher already include GDI+; for Windows 2000 you need to install it, if it's not installed already. No .NET framework is required. [2.x] KeePass requires the Microsoft .NET Framework (which can be downloaded for free at…

Words 3186 - Pages 13

Essay Social Media Business Model Analysis - Case Tencent, Facebook, and Myspace

l Social Media Business Model Analysis - Case Tencent, Facebook, and Myspace Logistics Master's thesis Xiaoyan Hu 2011 Department of Information and Service Economy Aalto University School of Economics ABSTRACT The term of social media is becoming increasingly popular presently, the amount of social media users is growing dramatically, and the monetization of social media has been discussed in publications but not in details. Nowadays, the most frequently used approach to make money for…

Words 34791 - Pages 140