For example, if you select the top, left-hand corner cell of the data area within an Excel Table, Ctrl+Shift+Right arrow will select the entire top row of data and, with that row still selected, Ctrl+Shift+Down arrow will select the rest of the data area of the Table. Using the Ctrl key with a navigation key will extend the navigation to the end of the current area (which will vary depending on context) and holding down the Shift key at the same time will change the navigation to a selection. There are some general techniques when using keyboard shortcuts to navigate through workbooks or to select content. Particularly since the main file operations were relegated to the File Ribbon tab, using keyboard shortcuts rather than the mouse or trackpad to access these commands can save a large number of small amounts of time: Ctrl+S Note that this only applies to the last action so, if you make two or more format changes, only the most recent will be repeated by using F4. For example, if you were to apply a highlight to the selected cell, you could then select any cell, or set of cells, and use F4 to apply the same highlight. Although it doesn’t always work as you would expect, the F4 key will often repeat the last action you performed. Undo (Ctrl+Z) and Redo (Ctrl +Y) would come a close second for frequency of use. Possibly, the shortcuts I use most are those for cut, copy and paste which, remembered in that order, correspond to three adjacent keys: Ctrl+X Alternatively, you can type ‘Keyboard shortcuts’ directly in the Search box in the Title Bar and select the ‘Keyboard shortcuts in Excel’ option: The Help pane should appear and you can type ‘keyboard shortcuts’ into the search box. For a comprehensive list of keyboard shortcuts, organised by category, click on the Help Ribbon tab, then select Help from the Help group. If you do find keyboard shortcuts useful then there are several ways to discover the shortcuts that are available. The benefits of using shortcuts can also change depending on where you are using Excel – for example, when sitting at a desk with plenty of room to use a mouse, compared to using an over-sensitive trackpad on a cramped and busy train. How much difference using keyboard shortcuts makes will depend on how you use Excel, your keyboard skills and how comfortable you are using a mouse or a trackpad. Many people will use many more keyboard shortcuts and others fewer. Given that lots of comprehensive lists of keyboard shortcuts are available, this will be a personal selection of some of the keyboard shortcuts and techniques that I find particularly useful. In this article, we will look at other keyboard shortcuts that can help speed up further aspects of Excel. One section of the previous post in this series was devoted to the use of keyboard shortcuts to help with data entry. Excel how to: speed up data entry – making data entry as quick and efficient as possible by knowing the effect of some key Excel options and features, together with some useful keyboard shortcuts.Part 2 – using the three number styles to set up your own number formats that can be applied directly from the commands in the Number group of the Home Ribbon tab. Excel how to: speed up formatting using Excel Styles.Part 1 – using Excel Styles to format Excel cells with a single click and to help implement the ICAEW 20 Principles for Good Spreadsheet Practice. Excel how to: speed up entering formulae – Dynamic Arrays – how the recent introduction of Dynamic Arrays can dramatically reduce the number of formulae you need to enter in the first place.Excel how to: speed up formulae - using Excel tables part 2 – adding calculated columns to an Excel Table.Excel how to: speed up formulae - using Excel tables – creating dynamic references by referring to Table columns and using Table structured references to make formulae easier to understand.Excel how to: speed up entering formulae part 2 - using Range Names to make formulae easier to enter and understand.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |