Premium Essay

Excel Shortcuts

In: Computers and Technology

Submitted By ssriram1990
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 + SHIFT + !…...

Similar Documents

Premium Essay

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)......

Words: 3690 - Pages: 15

Premium Essay

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

Free Essay

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

Free Essay

Excel Short Keys

...Ctrl+Z Undo Ctrl+C Enter, Ctrl+V Ctrl+X Copy, Paste, Multiple Paste, Cut Ctrl+F, Ctrl+H Find, Find&Replace Ctrl+P, Ctrl+S, Ctrl+F4, Alt+F4 Print, Save, Close, Close Excel Ctrl+Arrow Move to edge of region Ctrl+* Select current region Ctrl+A Select all cells Ctrl+Home Ctrl+End Select A1, Select last cell in used range Ctrl+Shift+End Select from active cell to last cell in used range. Ctrl+Shift+Home Select from active cell to A1 Ctrl+Page Down Ctrl+Page Up Move to the next sheet, Move to the previous sheet Ctrl+Tab Move to next open workbook Ctrl+N Open new workbook Shift+F11 Insert new worksheet Shift+F3 Paste function window =+FunctionName+Ctrl+A Insert new function Alt+F11 Open VBE Ctrl+Shift+Enter Array formula Ctrl+F3, F3 Define name, Paste name Ctrl+Spacebar Shift+Spacebar Select columns, Select rows Ctrl+1, Ctrl+B, Ctrl+U Format cells, Bold, Underline Ctrl+; , Ctrl+shift+: Current date, Current time | | | | |Rate this tip | |  RATING: | |Email Tip | |Top of Form | |2.96 | | | | ...

Words: 1257 - Pages: 6

Free Essay

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

Free Essay

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

Premium Essay

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

Premium Essay

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

Premium Essay

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

Premium Essay

Excel

...P rate and y = T P rate. Possible values range from (0, 0) to (1, 1). The “classification” that assigns “Test Negative” to every score has FP rate of 0 and TP rate of 0, represented as point (0, 0). The “classification” that assigns “Test Positive” to every value has FP rate of 1 and TP rate of 1, represented as the point (1, 1). Joining all known (x, y) points by straight lines, the area under the resulting empirical ROC curve is known as the Area Under the Curve or AUC. The AUC ranges from 0.5, for a test no better than chance, to 1, for a perfect test. The Area Under the Curve is calculated by the summation of the average height multiplied by the width, as follows: ! ! T P (n) + T P (n + 1) 1 2 (F P (n + 1) F P (n)) See Excel Spreadsheets for examples of calculating each point on an empirical ROC Curve. 2 2.1 2.1.1 Information Measures Probability Review Basic Probability Definitions Joint probability: p(X, Y ) The probability that both X and Y are true. Joint probability is commutative: p(X, Y ) = p(Y, X). Conditional probability: p(X|Y ) The probability that X is true, given that Y is true. Note that “Rates,” PPV and NPV are Conditional Probabilities: True Positive Rate = p(T P T est|+), 3 False Negative Rate = p(F N T est|+), False Positive Rate = p(F P T est| ), True Negative Rate = p(T N T est| ), Positive Predictive Value = p(+|T est P ositive), Negative Predictive Value = p( |T est N egative). Marginal probability:......

Words: 4475 - Pages: 18

Premium Essay

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

Premium Essay

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

Premium Essay

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

Premium Essay

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

Premium Essay

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