Excel Shortcuts

In: Computers and Technology

Submitted By abhishek2387
Words 3690
Pages 15
Excel

Excel ShortCut Keys and Tips
Enter data by using shortcut keys
To Complete a cell entry Cancel a cell entry Repeat the last action Start a new line in the same cell Delete the character to the left of the insertion point, or delete the selection Delete the character to the right of the insertion point, or delete the selection Delete text to the end of the line Move one character up, down, left, or right Move to the beginning of the line Edit a cell comment Create names from row and column labels Fill down Fill to the right Fill the selected cell range with the current entry Complete a cell entry and move down in the selection Complete a cell entry and move up in the selection Complete a cell entry and move to the right in the selection Complete a cell entry and move to the left in the selection Press ENTER ESC F4 or CTRL + Y ALT + ENTER BACKSPACE DELETE Enter the time Insert a hyperlink Complete a cell entry Copy the value from the cell above the active cell into the cell or the formula bar Alternate between displaying cell values and displaying cell formulas Copy a formula from the cell above the active cell into the cell or the formula bar Enter a formula as an array formula Display the Formula Palette after you type a valid function name in a formula Insert the argument names and parentheses for a function, after you type a valid function name in a formula Display the AutoComplete list CTRL + SHIFT + : (COLON) CTRL + K ENTER CTRL + SHIFT + " (QUOTATION MARK) CTRL + ` (SINGLE LEFT QUOTATION MARK) CTRL + ' (APOSTROPHE) CTRL + SHIFT + ENTER CTRL + A

CTRL + DELETE Arrow keys HOME SHIFT + F2 CTRL + SHIFT + F3 CTRL + D CTRL + R CTRL + ENTER ENTER SHIFT + ENTER TAB SHIFT + TAB

CTRL + SHIFT +A

ALT + DOWN ARROW Press ALT + ' (APOSTROPHE) CTRL + 1 CTRL + SHIFT +~ CTRL + SHIFT +$ CTRL + SHIFT + % CTRL + SHIFT + ^ CTRL + SHIFT + # CTRL + SHIFT +@ CTRL +…...

Similar Documents

Excel Shortcuts

...Excel Excel ShortCut Keys and Tips Enter data by using shortcut keys To Complete a cell entry Cancel a cell entry Repeat the last action Start a new line in the same cell Delete the character to the left of the insertion point, or delete the selection Delete the character to the right of the insertion point, or delete the selection Delete text to the end of the line Move one character up, down, left, or right Move to the beginning of the line Edit a cell comment Create names from row and column labels Fill down Fill to the right Fill the selected cell range with the current entry Complete a cell entry and move down in the selection Complete a cell entry and move up in the selection Complete a cell entry and move to the right in the selection Complete a cell entry and move to the left in the selection Press ENTER ESC F4 or CTRL + Y ALT + ENTER BACKSPACE DELETE Enter the time Insert a hyperlink Complete a cell entry Copy the value from the cell above the active cell into the cell or the formula bar Alternate between displaying cell values and displaying cell formulas Copy a formula from the cell above the active cell into the cell or the formula bar Enter a formula as an array formula Display the Formula Palette after you type a valid function name in a formula Insert the argument names and parentheses for a function, after you type a valid function name in a formula Display the AutoComplete list CTRL + SHIFT + : (COLON) CTRL + K ENTER CTRL + SHIFT + " (QUOTATION MARK) CTRL +......

Words: 3690 - Pages: 15

Excel

...ADVANCED EXCEL TRAINING Quality Management Objective  To provide the participants with an understanding of the advanced features of MS Excel Today is 7/22/2011 2 Advanced  ® EXCEL Topics Working with Data Lists Naming Cells and Ranges   Conditional Functions Lookup Functions   Pivot Tables Data Validation  Today is 7/22/2011 3 Naming Cells and Ranges Today is 7/22/2011 4 Name cells by using labels Name cells by using existing row and column labels Select the range you want to name, including the row or column labels. On In the Insert menu, point to Name, and then click Create. the Create names in box, designate the location that contains the labels by selecting the Top row, Left column, Bottom row, or Right column check box. Note A name created by using this procedure refers only to the cells that contain values and does not include the existing row and column labels. Today is 7/22/2011 5 Name a Cell or Range Using Names Box  1. Select the cell or range you want to name.  2. Click the Name box on the formula bar.  3. Type a name for the range. A range name can include uppercase or lowercase letters, numbers, and punctuation, but no spaces. Try to use a simple name that reflects the type of information in the range, such as BookTitle.  4. Press Enter. The range name will appear in the Name box whenever you select the range. Today is 7/22/2011 6 Conditional......

Words: 1579 - Pages: 7

The System of Finance Shortcuts

...Commonly Used Shortcut Keys v13.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......

Words: 2359 - Pages: 10

Excel

...Project Description: You are an analyst for an art gallery that is an authorized Greenwich Workshop® fine art dealer. You prepared a list of artwork by James Christensen and need to organize the data using an outline, subtotals, PivotTables, and PivotCharts to aid you in analyzing the data, which you will do in this project. Instructions: For the purpose of grading the project you are required to perform the following tasks: Step Instructions Points Possible 1 Start Excel. Download, save, and open the file named Exploring_e05_Grader_EOC.xlsx. 0 2 Sort the data on the Subtotals worksheet first by the Type column, then by the Art column, both in alphabetical order. 4 3 Subtotal the data at each change in Type. Identify the highest issue price, estimated value, and percent increase. 10 4 Add an automatic outline to the Subtotals worksheet. Group the first and last name columns. Collapse the names columns, and then collapse columns created by the outline (G, H, and I). 7 5 Create a PivotTable on a new worksheet using the data on the Christensen worksheet in the range A1:J19. Use the Type, Est. Value, and Issue Price fields and use the default locations in the PivotTable Layout. 8 6 Modify the Issue Price and Est. Value values to determine the average issue price and average estimated market value by type. 6 7 Insert a calculated field named % Change in Value to determine the percent change in values by type. Format the values in the new column as percentages......

Words: 312 - Pages: 2

Excel Formulas

...Microsoft Excel 2010 Formulas & Functions  Table of Contents Excel 2010 Formulas & Functions ……………………………………………….….. o Formula Basics ……………………………………………….….. o Order of Operation ……………………………………………….….. Conditional Formatting ……………………………………………….….. Cell Styles ……………………………………………….….. Formulas & Functions ……………………………………………….….. Basic Formulas ……………………………………………….….. o Add the Values in Rows or Columns ……………………………………………….….. o Find the Average, Maximum, or Minimum ……………………………………………….….. Ranges & Individual Cells ……………………………………………….….. Copy a Formula ……………………………………………….….. o Using the Fill Handle ……………………………………………….….. o Using Traditional Copy & Paste ……………………………………………….….. Referencing Cells in Formulas ……………………………………………….….. o Relative References ……………………………………………….….. o Absolute References ……………………………………………….….. o Mixed References ……………………………………………….….. o References to Other Worksheets ……………………………………………….….. o Other Workbook References ……………………………………………….….. Quick Reference Guide ……………………………………………….….. o Add, Subtract, Multiple & Divide ……………………………………………….….. o Understanding Error Values ……………………………………………….….. Practical Purposes of Excel Formulas ……………………………………………….….. o Using Date & Time Formulas ……………………………………………….….. Commonly Used Functions & Formulas ……………………………………………….….. o Math & Trig Icon ……………………………………………….….. Logical Icon ……………………………………………….….. Lookup & Reference Icon ……………………………………………….….. Date & Time Icon ……………………………………………….….. AutoSum Icon ……………………………………………….…........

Words: 478 - Pages: 2

Excel

...Microsoft Excel 2010 Formulas & Functions  Table of Contents Excel 2010 Formulas & Functions ……………………………………………….….. o Formula Basics ……………………………………………….….. o Order of Operation ……………………………………………….….. Conditional Formatting ……………………………………………….….. Cell Styles ……………………………………………….….. Formulas & Functions ……………………………………………….….. Basic Formulas ……………………………………………….….. o Add the Values in Rows or Columns ……………………………………………….….. o Find the Average, Maximum, or Minimum ……………………………………………….….. Ranges & Individual Cells ……………………………………………….….. Copy a Formula ……………………………………………….….. o Using the Fill Handle ……………………………………………….….. o Using Traditional Copy & Paste ……………………………………………….….. Referencing Cells in Formulas ……………………………………………….….. o Relative References ……………………………………………….….. o Absolute References ……………………………………………….….. o Mixed References ……………………………………………….….. o References to Other Worksheets ……………………………………………….….. o Other Workbook References ……………………………………………….….. Quick Reference Guide ……………………………………………….….. o Add, Subtract, Multiple & Divide ……………………………………………….….. o Understanding Error Values ……………………………………………….….. Practical Purposes of Excel Formulas ……………………………………………….….. o Using Date & Time Formulas ……………………………………………….….. Commonly Used Functions & Formulas ……………………………………………….….. o Math & Trig Icon ……………………………………………….….. Logical Icon ……………………………………………….….. Lookup & Reference Icon ……………………………………………….….. Date & Time Icon ……………………………………………….….. AutoSum Icon ……………………………………………….…........

Words: 5629 - Pages: 23

Excel

...New Perspectives Excel 2013 Tutorial 3: SAM Project 1a Spring Software ENHANCE A TIMESHEET Project Goal M Project Name Project Goal New Perspectives Excel 2013 Tutorial 3: SAM Project 1a Spring Software ENHANCE A TIMESHEET Project Goal M Project Name Project Goal PROJECT DESCRIPTION Devon Hastings is the human resources director for Spring Software, a software development company in Cambridge, Massachusetts. He has created a workbook for employees to use in recording the hours they work. He would like your help finishing the timesheet. GETTING STARTED * Download the following file from the SAM website: * NP_Excel2013_T3_P1a_FirstLastName_1.xlsx * Open the file you just downloaded and save it with the name: * NP_Excel2013_T3_P1a_FirstLastName_2.xlsx * Hint: If you do not see the .xlsx file extension in the Save file dialog box, do not type it. Excel will add the file extension for you automatically. * With the file NP_Excel2013_T3_P1a_FirstLastName_2.xlsx still open, ensure that your first and last name is displayed in cell B6 of the Documentation sheet. If cell B6 does not display your name, delete the file and download a new copy from the SAM website. PROJECT STEPS 1. On the Employee List worksheet, select cells A1:B1 and then use the Format Painter copy the format only to the range A2:B9. 2. In cell B1 enter bs001, in cell B2 enter cg001, in cell B3 type dh001, and then use Flash......

Words: 790 - Pages: 4

Excel Shortcut

...Excel 2013 Help Page 1 of 8 Keyboard shortcuts in Excel This article describes what Key Tips are and how you can use them to access the ribbon. It also lists Ctrl combination shortcut keys, function keys, and some other common shortcut keys for Microsoft Excel 2013. In this article Keyboard access to the ribbon Will my old shortcuts still work? Ctrl combination shortcut keys Function keys Other useful shortcut keys Keyboard access to the ribbon If you're new to the ribbon, the information in this section can help you understand the ribbon's keyboard shortcut model. The ribbon comes with new shortcuts, called Key Tips. To make the Key Tips appear, press Alt. To display a tab on the ribbon, press the key for the tab—for example, press the letter N for the Insert tab or M for the Formulas tab. This makes all the Key Tip badges for that tab's buttons appear. Then, press the key for the button you want. Will my old shortcuts still work? Keyboard shortcuts that begin with Ctrl will still work in Microsoft Excel 2013. For example, Ctrl+C still copies to the clipboard, and Ctrl+V still pastes from the clipboard. Most of the old Alt+ menu shortcuts still work, too. However, you need to know the full shortcut from memory — there are no screen reminders of what letters to press. For example, try pressing Alt, and then press one of the old menu keys E (Edit), V (View), I (Insert), and so on. A box pops up saying you're using an access key from an earlier version of......

Words: 2819 - Pages: 12

Keyboard Shortcuts

...(Copy the selected item) 8. CTRL+SHIFT while dragging an item (Create a shortcut to the selected item) 9. F2 key (Rename the selected item) 10. CTRL+RIGHT ARROW (Move the insertion point to the beginning of the next word) 11. CTRL+LEFT ARROW (Move the insertion point to the beginning of the previous word) 12. CTRL+DOWN ARROW (Move the insertion point to the beginning of the next paragraph) 13. CTRL+UP ARROW (Move the insertion point to the beginning of the previous paragraph) 14. CTRL+SHIFT with any of the arrow keys (Highlight a block of text) SHIFT with any of the arrow keys (Select more than one item in a window or on the desktop, or select text in a document) 15. CTRL+A (Select all) 16. F3 key (Search for a file or a folder) 17. ALT+ENTER (View the properties for the selected item) 18. ALT+F4 (Close the active item, or quit the active program) 19. ALT+ENTER (Display the properties of the selected object) 20. ALT+SPACEBAR (Open the shortcut menu for the active window) 21. CTRL+F4 (Close the active document in programs that enable you to have multiple documents opensimultaneously) 22. ALT+TAB (Switch between the open items) 23. ALT+ESC (Cycle through items in the order that they had been opened) 24. F6 key (Cycle through the screen elements in a window or on the desktop) 25. F4 key (Display the Address bar list in My Computer or Windows Explorer) 26. SHIFT+F10 (Display the shortcut menu for the selected item) 27. ALT+SPACEBAR (Display the System menu......

Words: 1126 - Pages: 5

Computer Shortcuts

...· * More than 100 Keyboard Shortcuts must read & Share Keyboard Shortcuts (Microsoft Windows) 1. CTRL+C (Copy) 2. CTRL+X (Cut) ... 3. CTRL+V (Paste) 4. CTRL+Z (Undo) 5. DELETE (Delete) 6. SHIFT+DELETE (Delete the selected item permanently without placing the item in the Recycle Bin) 7. CTRL while dragging an item (Copy the selected item) 8. CTRL+SHIFT while dragging an item (Create a shortcut to the selected item) 9. F2 key (Rename the selected item) 10. CTRL+RIGHT ARROW (Move the insertion point to the beginning of the next word) 11. CTRL+LEFT ARROW (Move the insertion point to the beginning of the previous word) 12. CTRL+DOWN ARROW (Move the insertion point to the beginning of the next paragraph) 13. CTRL+UP ARROW (Move the insertion point to the beginning of the previous paragraph) 14. CTRL+SHIFT with any of the arrow keys (Highlight a block of text) SHIFT with any of the arrow keys (Select more than one item in a window or on the desktop, or select text in a document) 15. CTRL+A (Select all) 16. F3 key (Search for a file or a folder) 17. ALT+ENTER (View the properties for the selected item) 18. ALT+F4 (Close the active item, or quit the active program) 19. ALT+ENTER (Display the properties of the selected object) 20. ALT+SPACEBAR (Open the shortcut menu for the active window) 21. CTRL+F4 (Close the active document in programs that enable you to have multiple documents opensimultaneously) 22. ALT+TAB (Switch between the open items) 23. ALT+ESC (Cycle through items...

Words: 1148 - Pages: 5

Shortcut

...Support Sign in Cart0 ------------------------------------------------- Top of Form  Bottom of Form  Manage my account  Ask the community  Contact Answer Desk  Find downloads Keyboard shortcuts for Windows * Email * Print Support for Windows XP has ended Microsoft ended support for Windows XP on April 8, 2014. This change has affected your software updates and security options. Learn what this means for you and how to stay protected. Support for Windows Server 2003 ended on July 14, 2015 Microsoft ended support for Windows Server 2003 on July 14, 2015. This change has affected your software updates and security options. Learn what this means for you and how to stay protected. Summary This article lists keyboard shortcuts that you can use with Windows. More information Windows system key combinations * F1: Help * CTRL+ESC: Open Start menu * ALT+TAB: Switch between open programs * ALT+F4: Quit program * SHIFT+DELETE: Delete item permanently * Windows Logo+L: Lock the computer (without using CTRL+ALT+DELETE) Windows program key combinations * CTRL+C: Copy * CTRL+X: Cut * CTRL+V: Paste * CTRL+Z: Undo * CTRL+B: Bold * CTRL+U: Underline * CTRL+I: Italic Mouse click/keyboard modifier combinations for shell objects * SHIFT+right click: Displays a shortcut menu containing alternative commands * SHIFT+double click: Runs the alternate default command (the second item on the menu) * ALT+double click: Displays properties *......

Words: 1247 - Pages: 5

Excel

...Applied Statistics Microsoft Excel Decomposition may reduce appeal emphasis on applications. Flow charts help make the analysis decision by identifying technique, computing statistics, and interpreting results. Associated data set accompanies the set purports to build a excel spreadsheet that discovers formula, illustrates the parameters, observes dynamic graphs and simulations that recodes, edits, validate, charts, and automatically links equations, data, and formulas to recalculate the data analysis. Excel recognizes statistical capability conjunction that carries out complex algorithms that implement correlated data columns. Excel quickly analyzes and interprets information filtered into a spreadsheet so the process is much easier then working out these formulas by hand. Excel spreadsheets create charts, graphs, and filters data all into one. Excel uses all of the basic mathematical operations such as addition, subtraction, division, and multiplication. Fractions and decimals are just as common for interpretation data into a excel spreadsheet. An advantage about excel is you can place any formula into the spreadsheet whether in ascending or descending order and using the same formula, it will automatically compute the answer for the next equation. Another advantage is if information is inaccurate, you can go back and check your work with just a click, unlike using y calculations or by hand you have to erase so much and start all over again, which could be time......

Words: 377 - Pages: 2

Excel

...of employees eligible for each award amount (Hint use column J). Copy this formula for all categories in this column using absolute cell references as necessary. b) In cell D4, enter a SumIF (p. EX 407) formula to calculate total amount of award money earned by all employees in the company. Copy this formula for all categories in this column using absolute cell references as necessary. Use the Data Table Sheet: In cell D3 use a cell reference (p. EX 311) to the Monthly Payment amount (cell B10) a) Complete the two-variable data table b) Format the payment amounts in the table as Currency style NO decimal places. Also using the Data Table Sheet: a) Create a PrintTable macro (p. EX 458), using Ctrl+p for the shortcut. b) Set the print area to print the two variable data table (cells D2:H13) c) Add your name in the left footer d) Select Print Preview and then stop the recording e) Insert a button in cells A14:B16 and apply (assign) the Print macro to it Developer tab, Insert, Button (1st row, 1st column under Form Controls). Draw a box in the area specified range and then click on PrintTable macro to assign it to the button. f) Change the macro button name to PrintTable. g) Save your workbook as a Macro-Enabled workbook and use the name Exam2Practice.xlsm. Use the Solver Sheet: Background: Hospitals are increasing their use of high-tech equipment. Image Medtech manufactures this type of......

Words: 1218 - Pages: 5

Excel

...Terms Definitions The First step in creating an effective workseet is to make sure you __________. Understand what is required In Excel, a number can contain the charaters ________. 0 1 2 3 4 5 6 7 8 9 The cell being copied is called the source area (copy area). The range of cells recieving the copy is called the ________. receiving range You ________ a worksheet to emphasize certain entires and make the worksheet easier to read and understand. Format Pressing the _________ keyboard shorcut key(s) selects cell A1. CTRL + HOME How many chart types does Excel offer? 11 Which of the following keys is an alternative to double-clicking the cell to edit it? F2 Which of the following Opton buttons gives options for filling cells following a fill operation? Auto Fill Options A ________ cell in Excel has a numerical value of zero. Blank The ________ AutoComplete list contains those functiond that akohabetically match the letters you type following thr equal sign. Formula The most popular background color is _______. White ________ text often provides a strong visual appeal. Underlined To open the format cells dialog box with the Alignment sheet active, click the Format Cells ________. Dialog Box Launcher Which of the following is an extension of the fill patten Sunday, Tuesday? Thursday, Saturday, Monday Which of the following formula contains the absolute cell reference? =$B$4 A(n) _______ chart provides a simple way to show trends and variatons in a range of data...

Words: 423 - Pages: 2

Microsoft Excel

...Using Microsoft Excel Getting Started Using Microsoft Excel About Excel What is a Spreadsheet? Microsoft Excel is a program that’s used for creating spreadsheets. So what is a spreadsheet? Before personal computers were common, “spreadsheet” referred to large sheets of lined paper, which were used by people in various businesses to record facts and figures in rows and columns, and then make calculations based on the information. When personal computers first began appearing, one of the first applications was a program released in 1979 called VisiCalc. It was used as a tool for performing spreadsheet style calculations that would have been to difficult to do on a calculator. The program quickly became so popular that people began buying personal computers for their businesses just so they could use VisiCalc. VisiCalc Since then, many other spreadsheet programs have been popular over the years, such as Quattro Pro and Lotus 123. Microsoft Excel was first released in 1985 with newer versions being released every couple of years. The most recent version is Excel 2003 (version 11). © Stephen O’Neil 2005 Page 1 Of 17 www.oneil.com.au/pc Using Microsoft Excel Getting Started How Do Spreadsheets Work? Computer spreadsheets are based on their old paper formats. A spreadsheet on a computer uses rows and columns to record information such as text and numbers, such as the example below. Graduates from University 1996 1997 1998 1999 2000 2001......

Words: 4397 - Pages: 18

Petroleum vs Natural Gas essay | Kunststoffindustrie & Chemie | In Extremis (2017)