Spreadsheets are extremely important for most businesses. 95% of American firms use spreadsheets for financial reporting, and half of the average company’s decisions are made based on a spreadsheet. If you ask CEOs for the best spreadsheet software, Microsoft Excel tops the list. Excel’s high level of complexity and wide range of possibilities, delight the most expert users but can significantly slow basic users down.
If you don’t know how to get the most out of Excel, KeyRocket is here to help! As part of our ongoing effort to better teach keyboard shortcuts, we’ve collected some statistics about the most used ones on Excel 2010. By making it a habit to use shortcuts for five or six basic Excel tasks, you can get things done faster, but you’ll also feel like you finally have control over Excel, not the other way around! You’ll also be able to focus more on your content, like gathering and verifying input data to avoid spreadsheet errors, which is one of the biggest problems in companies.
Start using them regularly, and you’ll soon realize why shortcuts are life-savers in Excel. If you have trouble remembering the shortcuts, just download KeyRocket to learn them at your pace. And don’t forget to pin the app to your taskbar so you can access the list of your own most-used shortcuts in just two clicks (or a single shortcut, of course).
1. Ctrl+C / V. Copies the selected cells / Inserts the contents of the Clipboard at the insertion point and replaces any selection. Available only after you have cut or copied an object, text, or cell contents.
2. Ctrl+Shift+Down/Up Arrow. Extends the selection of cells to the last nonblank cell in the same column or row as the active cell, or if the next cell is blank, extends the selection to the next nonblank cell.
3. Ctrl+Arrows. Down arrow: Moves to the bottom of the current data region in a worksheet. Left Arrow: Moves to the left corner of the current data region in a worksheet. Right-Arrow: Moves to the right corner of the current data region in a worksheet. Up-Arrow: Moves to the top of the current data region in a worksheet.
4. Ctrl+Page Down/Up. Moves to the next sheet in a workbook/Moves to the previous sheet in a workbook.
5. Esc. Cancels an entry in the cell or Formula Bar. Closes an open menu or submenu, dialog box, or message window. It also closes full screen mode when this mode has been applied, and returns to normal screen mode to display the ribbon and status bar again.
6. F2. Edits the active cell and positions the insertion point at the end of the cell contents. It also moves the insertion point into the Formula Bar when editing in a cell is turned off.
7. Ctrl+Shift+Down Arrow. Extends the selection of cells to the last nonblank cell in the same column or row as the active cell, or if the next cell is blank, extends the selection to the next nonblank cell.
8. Ctrl+S. Saves the active file with its current file name, location, and file format.
Speaking of Excel 2010 shortcuts, if your Office Suite is running in Spanish (like mine), have you ever noticed that Ctrl + N is theoretically used for two actions: to bold text and to create a new document? I say theoretically because Ctrl+N doesn’t work at all to open a new document… Fortunately for our Spanish-speaking friends, KeyRocket is working to create customized shortcuts, so you can set up your own combination of keys for every action. Soon, that bug in Spanish Excel 2010 will be fixed. In the meantime, I guess we’ll have to keep using the mouse for ‘abrir un nuevo documento’.