![]() If youve been using keyboard shortcuts in Excel 2007, Excel 2003 or earlier versions. Here is the list in a format you can print or clip. The File tab in Excel 2010 replaces the Office orb button in Excel. Which are your favourite time-saving Excel shortcuts? Which ones should be on this list? which means press Alt and H together, then release those keys and press A, then C. It is worth spending a little time to learn the shortcuts on this page, they are the ones people ask me about the most, and to continue discovering more of your own. Shortcuts are a great way to minimise the amount of clicking and selecting that you would have to do when working with large spreadsheets. Microsoft Excel 2007 Keyboard Shortcuts: CTRL combination shortcut keys: CTRL+Shift+(Unhides any hidden rows within the selection. There are many ways to accomplish the same tasks in an Excel spreadsheet. ![]() Select first cell in the row of the active cell. You can usually locate the key just above the key – it’s not the same as that you use all the time. Manage Workflow Ctrl+Shift+V Paste data as block Ctrl+Z Undo last action Ctrl+Y Redo last action Ctrl+, Cancel current command (or ctrl+) ESC, Cancel. Select the first visible cell in the sheet (or bottom-right of freeze panes) Ctrl+Home. + to show formulas and again to hide formulas. This command is found in the Formula Auditing Group of the Formulas tab in Excel. Program Operations Program Settings and Navigation Worksheet Layout Worksheet Navigation Formulas Selections Cell Formatting Data Entry Charts. ![]() Speaking of SUM and formulas in general, few people know that they can do this at all but it’s essential when you need to troubleshoot or audit an existing spreadsheet, when you want a bird’s eye view of how it’s built and check that formulas are consistent. Without going to Excel macro there are still quite a handful of keyboard shortcuts you can master. ![]()
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |