Keyboard shortcuts in Excel for Windows
※ Download: Excel shortcuts
Note for Mac users: To access the F keys F1—F12 , you'll have to hold the Fn key before pressing any F key -- unless you've. Here are a few shortcuts that'll make you a formula wiz: Start a formula e. For example, ALT, W, P switches the worksheet to Page Layout view.
That means we no longer have Excel workbooks open inside of one application window. This will subtract a cell using the SUM formula by adding a negative sign before the cell you're subtracting.
Keyboard shortcuts in Excel for Windows - Ctrl+Shift+percent % Apply the Scientific number format with two decimal places.
I've mostly avoided the obvious and essential shortcuts that also work in other apps such as Ctrl+Z for undo and Ctrl+C for copy, Ctrl+B for bold, etc. F1: Access the Excel help file Press F1 to access the Excel help file. Alt: Access the ribbon Every single Ribbon command in Excel can be accessed via the keyboard. Type that letter or combo to use it. I've added the camera to the ribbon to quickly take screenshots, using Alt+4, as shown below: 4. Ctrl+;: Enter the current date Using Ctrl+; saves time checking and entering the date. I find myself using this a lot. Rather than clicking on the bottom-of-screen tabs, use Ctrl+PgUp and Ctrl+PgDn to quickly navigate between sheets. Shift+Space selects an entire row. You can then use the shift keys plus the arrow keys as appropriate to select additional rows or columns. It will add up the numbers in all cells above. Use this method instead of endless scrolling to save time. Alt+Enter: Multiple lines in one cell line break In some cases you may want multiple lines of data or text you typed into a cell to appear on several lines also called inserting a line break. Instead of entering the text in another cell, press ALT+ENTER. That way you'll start a new line while typing or editing data. F6: Switch between tools For all those anti-mouse users out there, F6 is the ultimate shortcut. It allows you to switch between the worksheet, the ribbon, task pane, and zoom controls. ESC: Cancel changes Press ESC while you are editing the text or formula in a cell to exit the cell and cancel any changes that you may have made. Shift + F3 : List of functions Not sure if you need to use a SUMIF or COUNTIF? Open the list of available functions using Shift+F3. CRTL+ALT+SHIFT+F9: Update formulas CTRL+ALT+SHIFT+F9 rechecks dependent formulas, and then calculates all cells in all open workbooks, including cells not marked as needing to be calculated. Very useful when you have user defined functions. Alt + F11: Open macro editor One of my personal favorite and most used Excel shortcuts is ALT+F11 to open the macro editor. Some of my most used macros are and. Here's a quick summary of all the shortcuts that you can print off or Pin for quick reference later:.
Backspace Deletes one character to the left in the Formula Bar. All contents © 1998-2014 by MrExcel Consulting All rights reserved. CTRL+1 Displays the Format Cells dialog box. Why am I sharing this with you. CTRL+9 Hides the selected rows. Checkout my article on the to learn more. Press this shortcut key after selecting the range, to only select the visible cells. ALT, W, Excel shortcuts switches the worksheet to Normal view. Ctrl+F8 performs the Size command on the Control menu for the workbook window when a workbook is not maximized. In a data form, it moves to the first field in the next record. End mode is shown in the status bar when it is on. Rather than manually retyping each piece of the code into excel shortcuts respective column, users can leverage a series of string functions to deconstruct the sequence as needed: LEFT, MID, or RIGHT.
