Premium Essay

Excel Shortcuts

In:

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

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

Words: 2819 - Pages: 12

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) CTRL + `...

Words: 3690 - Pages: 15

Premium Essay

Bernard Madoff

...want, instead, they have decided to create shortcuts to get to the point where everything come to their hands very easily and they actually get more than they really need and they really want. This is the case of those people who get tired of regular jobs that don’t pay off as they expected, so they start dealing with drugs along the world. These people they don’t even think about how they affect society by bringing the different king=ds of drugs into the market. They don’t even care if they target market in most of the cases are young kids who are not conscious of what they do and start consuming their drugs without knowing that they are destroying their own lives. Another example is a different kind of people who have the opportunity to serve their communities by doing a good job and investing their time by performing well at different scenarios. These people who work for the biggest companies and markets in the world, like people working at Wall Street. They do have the chance to get more comfortable living standards. However, they never end up getting what they really want and also decide to create some other shortcuts in order to get more, even though they have to betray other people’s trust. These people don’t measure the consequences of their acts and most of the times they end up on jail, empty- handed. This was the case of the famous Bernard Madoff, the most famous person in the US, for having created a $50 billion dollars shortcut. The next pages are dedicated to explain...

Words: 357 - Pages: 2

Free Essay

Deep Residual Learning for Image Recognition

...Deep Residual Learning for Image Recognition Kaiming He Xiangyu Zhang Shaoqing Ren Microsoft Research Jian Sun Deeper neural networks are more difficult to train. We present a residual learning framework to ease the training of networks that are substantially deeper than those used previously. We explicitly reformulate the layers as learning residual functions with reference to the layer inputs, instead of learning unreferenced functions. We provide comprehensive empirical evidence showing that these residual networks are easier to optimize, and can gain accuracy from considerably increased depth. On the ImageNet dataset we evaluate residual nets with a depth of up to 152 layers—8× deeper than VGG nets [41] but still having lower complexity. An ensemble of these residual nets achieves 3.57% error on the ImageNet test set. This result won the 1st place on the ILSVRC 2015 classification task. We also present analysis on CIFAR-10 with 100 and 1000 layers. The depth of representations is of central importance for many visual recognition tasks. Solely due to our extremely deep representations, we obtain a 28% relative improvement on the COCO object detection dataset. Deep residual nets are foundations of our submissions to ILSVRC & COCO 2015 competitions1 , where we also won the 1st places on the tasks of ImageNet detection, ImageNet localization, COCO detection, and COCO segmentation. 20 10 56-layer test error (%) 20 Abstract training...

Words: 5761 - Pages: 24

Premium Essay

Accounting

...Efficiency Improvements To improve your efficiency, it is helpful to know and use keyboard shortcuts. These allow you to use Excel much more quickly than by using a mouse. The following is a list of commonly used functions in Excel that you are expected to memorize. We encourage you to practice these shortcut keys, and if you do not understand a shortcut description to look it up via the Internet to learn more about how it works. These shortcuts will be tested on future quizzes and exams. For those interested, additional shortcuts can be found at http://office.microsoft.com/en-us/excelhelp/excel-shortcut-and-function-keys-HP001111659.aspx (these will not be tested). Code CTRL+( CTRL+) CTRL+9 CTRL+0 CTRL+A Description Unhides any hidden rows within the selection. Unhides any hidden columns within the selection. Hides the selected rows. Hides the selected columns. Selects the entire worksheet. If the worksheet contains data, CTRL+A selects the current region. Pressing CTRL+A a second time selects the entire worksheet. Applies or removes bold formatting. Copies the selected cells. Uses the Fill Down command to copy the contents and format of the topmost cell of a selected range into the cells below. Displays the Find dialog box. Applies or removes italic formatting. Creates a new, blank file. Displays the Print dialog box. Saves the active file with its current file name, location, and file format. Applies or removes underlining. Inserts the contents of the Clipboard at the insertion...

Words: 627 - Pages: 3

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

Premium Essay

Microsoft Server 1 Lab 6.1

...What is the average value of processor queue length on the W2kzzcomputer? 0.700 6.What subheading are available in the system stability report selection? Software unitalls, application failure, hardware failure, windows and miscellaneous 7.Waht logs are available by default? Application,security,setup,system and forward event 8.What is most recent Event id logged to the Application log? Application,security,setup,system,forward events 9.What is the most recent Event ID logged to security log? 4634 10.What is most recent event id logged to setup log? 1610 11. What is most recent event id logged to system log? 7036 12.How many events are displayed in this custom view? 52 13.What is the keyboard shortcut to begin a network capture? F5 14.What appears in the Capture Filter pane? 15.Does anything appear in the Network Conversations pane? no 16.Does anything appear in the Network Conversations pane? All traffic,my traffic, 17.Where will WSUS downloads be stored by default? (c:/wsus) 18.What database does WSUS use by Default? MSDE 19.What types of updates does WSUS download by default? Automatic updates 20.What nodes are available under the W2K40 node?...

Words: 260 - Pages: 2

Premium Essay

Dell Manual

...Me and My Dell © 2014 Dell Inc. NOTE: A NOTE indicates important information that helps you make better use of your computer. CAUTION: A CAUTION indicates potential damage to hardware or loss of data if instructions are not followed. WARNING: A WARNING indicates a potential for property damage, personal injury, or death. Copyright © 2014 Dell Inc. All rights reserved. This product is protected by U.S. and international copyright and intellectual property laws. Dell™ and the Dell logo are trademarks of Dell Inc. in the United States and/or other jurisdictions. All other marks and names mentioned herein may be trademarks of their respective companies. 2014 – 08 Rev. A02 Contents Windows 8.1 Features Signing in Microsoft account Local account 12 12 12 12 Locking and unlocking your computer Accessing the desktop Turning off your computer Start screen and tiles Apps Closing an app Snapping apps 12 13 13 14 14 14 14 More Information 15 Setting Up Your Computer Connecting To The Internet Connecting to the Internet Using LAN Connecting to the Internet Using WLAN Connecting to the Internet Using WWAN Setting up Audio Configuring 5.1/7.1 Audio Connecting 5.1 Speakers Connecting 7.1 Speakers Setting Up Your Printer 16 16 16 16 17 18 18 19 20 21 Contents  3 Setting Up Your Webcam Integrated Webcam External Webcam Setting up Bluetooth 22 22 22 22 About Your Computer Power Adapter Battery Coin-Cell Battery Touchpad Display Touchscreen...

Words: 18778 - Pages: 76

Free Essay

Topic

...Show All The shortcut keys described in this Help topic refer to the U.S. keyboard layout. Keys on other layouts may not correspond exactly to the keys on a U.S. keyboard. For keyboard shortcuts in which you press two or more keys simultaneously, the keys to press are separated by a plus sign (+) in Microsoft Word Help. For keyboard shortcuts in which you press one key immediately followed by another key, the keys to press are separated by a comma (,). To print this topic, press TAB to select Show All, press ENTER, and then press CTRL+P. Help task pane and Help window Using the Help task pane and Help window Menus, toolbars, task panes, and dialog boxes Access and use menus and toolbars Access and use task panes Resize and move toolbars, menus, and task panes Use dialog boxes Use edit boxes within dialog boxes Use the Open, Save As, and Insert Picture dialog boxes Quick reference Common tasks done in a Microsoft Word document Language bar Speech and handwriting recognition E-mail Sending e-mail messages Working with documents and Web pages Create, view, and save documents Find, replace, and browse through text Undo and redo actions Switch to another view Outline view Printing and previewing documents Reviewing documents Reading layout view References, footnotes, and endnotes Working with Web pages Editing and moving text and graphics Delete text and graphics Copy and move text and graphics Insert special characters Insert characters by using character...

Words: 438 - Pages: 2

Premium Essay

Keme

...1. Deleting the data and clearing the row. Deleting Cells and Data in Excel 2007 In Microsoft Office Excel 2007, when you need to delete data, remove formatting in a cell selection, or remove entire cells, rows, or columns, you have many options depending on your objective. Excel can perform two kinds of cell deletions in a worksheet: clearing cell data and deleting the cell. Clearing cell contents Clearing just deletes or empties the cell’s contents or formatting without removing the cell from the worksheet, which would alter the layout of the surrounding cells. To get rid of just the contents of a cell selection, just select the range of cells to be cleared and press the Delete key. If you want to get rid of more than just the contents of a cell selection, like cell formatting or cell comments, select the cell(s) and follow these steps: 1. Click the Clear button (the one with the eraser) in the Editing group on the Ribbon’s Home tab. 2. Click one of the following options on the Clear drop-down menu: * Clear All gets rid of all formatting, notes, and entries in the cell selection. * Clear Formats deletes only the formatting from the cell selection without touching anything else. * Clear Contents deletes only the cell entries, just like pressing the Delete key. * Clear Comments removes the notes in the cell selection but leaves everything else intact. Deleting cells, rows, or columns Deleting gets rid of the whole kit and caboodle...

Words: 5625 - Pages: 23

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 Total Nursing...

Words: 4397 - Pages: 18

Premium Essay

Nothing

...------------------------------------------------- Top of Form Bottom of Form ------------------------------------------------- Top of Form Excel shortcut and function keys Hide All Important notice for users of Office 2003    To continue receiving security updates for Office, make sure you're running Office 2003 Service Pack 3 (SP3). The support for Office 2003 ends April 8, 2014. If you’re running Office 2003 after support ends, to receive all important security updates for Office, you need to upgrade to a later version such as Office 365 or Office 2013. For more information, see Support is ending for Office 2003. The following lists contain CTRL combination shortcut keys, function keys, and some other common shortcut keys, along with descriptions of their functionality. For more extensive reference information on all available shortcuts and their specific uses, see Keyboard shortcuts. To print this topic, press TAB to select Show All, press ENTER, and then press CTRL+P.  Note   If an action you use often does not have a shortcut key, you can record a macro to create one. CTRL combination shortcut keys Key | Description | CTRL+( | Unhides any hidden rows within the selection. | CTRL+) | Unhides any hidden columns within the selection. | CTRL+& | Applies the outline border to the selected cells. | CTRL+_ | Removes the outline border from the selected cells. | CTRL+~ | Applies the General number format. | CTRL+$ | Applies the Currency format with...

Words: 2545 - Pages: 11

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

Words: 2359 - Pages: 10

Premium Essay

Computer

...Microsoft Excel 2010 Understanding the Basics                 Table of Contents Opening Excel 2010 ………………………………………………………… Components of Excel ………………………………………………………… The Ribbon ………………………………………………………… o Contextual Tabs ………………………………………………………… o Dialog Box Launcher ………………………………………………………… o Quick Access Toolbar ………………………………………………………… Key Tips ………………………………………………………… The New Page Layout View ………………………………………………………… File Tab ………………………………………………………… Formatting Cells ………………………………………………………… o Format Painter ………………………………………………………… o Clear Cell Contents or Formats ………………………………………………………… o Formatting Tips ………………………………………………………… AutoSum ………………………………………………………… Adding Headers and Footers ………………………………………………………… Microsoft Templates ………………………………………………………… Navigating in Excel ………………………………………………………… o Navigate between Worksheets ………………………………………………………… o Insert, Move, & Rename Worksheets ………………………………………………………… o Navigation Keystrokes ………………………………………………………… o Select & Move Worksheet Cells ………………………………………………………… o Range Selection Techniques ………………………………………………………… Modifying Cells ………………………………………………………… o Understanding Text, Values & Formulas ………………………………………………………… o Editing Cells & Entering Expressions ………………………………………………………… o Insert Worksheet Rows & Columns ………………………………………………………… o Delete Worksheet Rows & Columns ………………………………………………………… o Resize Worksheet Rows & Columns ………………………………………………………… Entering...

Words: 5380 - Pages: 22

Premium Essay

Aaaaaaaaaa

...MS-EXCEL FOR CHARTERED ACCOUNTANTS SUNIL B GABHAWALLA CHARTERED ACCOUNTANT WESTERN INDIA REGIONAL COUNCIL OF THE INSTITUTE OF CHARTERED ACCOUNTANTS OF INDIA TABLE OF CONTENTS 1 2 Basics & Beyond......................................................................................................... 4 1.1 Introduction......................................................................................................... 4 1.2 The EXCEL Screen............................................................................................. 4 1.3 Moving Around................................................................................................... 5 Data Entry ................................................................................................................... 8 2.1 Text ..................................................................................................................... 8 2.2 Number (including date, time, percent) .............................................................. 8 2.3 Formulae ............................................................................................................. 8 2.4 Functions............................................................................................................. 9 2.5 AutoComplete ..................................................................................................... 9 2.6 AutoCorrect........................................................................................

Words: 16077 - Pages: 65