/en/excel-tips/use-transpose-to-flip-data-on-its-side/content/ Absolute references with the F4 keyIf you're typing a formula, you may sometimes want a cell reference to stay locked on a specific cell or cell range even if the formula is copied. To do this, you'll need to change the cell reference to an absolute reference by adding dollar signs before the row and column (for example, $D$2). Although you can type the dollar signs manually, the F4 key on your keyboard allows you to add both dollar signs with a single keystroke. If you create formulas frequently, this shortcut can save you a lot of time. Watch the video below to learn how to use the F4 shortcut. On some keyboards, the F4 key controls the computer's volume or screen brightness by default. In that case, you may have to hold down the Fn (Function) key before pressing F4. /en/excel-tips/add-a-new-row-with-a-shortcut/content/ If you work with large amounts of data in Microsoft Excel, you may find yourself in need of a way to lock cells to protect them from being modified. There are a few different ways to do this, but the quickest and most efficient way is to use a keyboard shortcut. In this article, we'll show you 15 different keyboard shortcuts that you can use to lock cells in Excel. 1. Ctrl + Shift + 1 This shortcut will lock all cells in the selected range. To use it, first select the cells that you want to lock, then press and hold the Ctrl and Shift keys, and finally press the 1 key. All of the cells in the selection will be locked. 2. Ctrl + Shift + 2 This shortcut will lock only the cells in the top row of the selection. To use it, select the cells that you want to lock, then press and hold the Ctrl and Shift keys, and finally press the 2 key. Only the cells in the top row of the selection will be locked. 3. Ctrl + Shift + 3 This shortcut will lock only the cells in the bottom row of the selection. To use it, select the cells that you want to lock, then press and hold the Ctrl and Shift keys, and finally press the 3 key. Only the cells in the bottom row of the selection will be locked. 4. Ctrl + Shift + 4 This shortcut will lock only the cells in the left column of the selection. To use it, select the cells that you want to lock, then press and hold the Ctrl and Shift keys, and finally press the 4 key. Only the cells in the left column of the selection will be locked. 5. Ctrl + Shift + 5 This shortcut will lock only the cells in the right column of the selection. To use it, select the cells that you want to lock, then press and hold the Ctrl and Shift keys, and finally press the 5 key. Only the cells in the right column of the selection will be locked. 6. Ctrl + Shift + 6 This shortcut will lock only the cells in the top-left corner of the selection. To use it, select the cells that you want to lock, then press and hold the Ctrl and Shift keys, and finally press the 6 key. Only the cells in the top-left corner of the selection will be locked. 7. Ctrl + Shift + 7 This shortcut will lock only the cells in the top-right corner of the selection. To use it, select the cells that you want to lock, then press and hold the Ctrl and Shift keys, and finally press the 7 key. Only the cells in the top-right corner of the selection will be locked. 8. Ctrl + Shift + 8 This shortcut will lock only the cells in the bottom-left corner of the selection. To use it, select the cells that you want to lock, then press and hold the Ctrl and Shift keys, and finally press the 8 key. Only the cells in the bottom-left corner of the selection will be locked. 9. Ctrl + Shift + 9 This shortcut will lock only the cells in the bottom-right corner of the selection. To use it, select the cells that you want to lock, then press and hold the Ctrl and Shift keys, and finally press the 9 key. Only the cells in the bottom-right corner of the selection will be locked. 10. Ctrl + Shift + A This shortcut will lock all cells in the worksheet. To use it, press and hold the Ctrl and Shift keys, and then press the A key. All cells in the worksheet will be locked. 11. Ctrl + Shift + B This shortcut will lock only the cells in the first column of the worksheet. To use it, press and hold the Ctrl and Shift keys, and then press the B key. Only the cells in the first column of the worksheet will be locked. 12. Ctrl + Shift + C This shortcut will lock only the cells in the first row of the worksheet. To use it, press and hold the Ctrl and Shift keys, and then press the C key. Only the cells in the first row of the worksheet will be locked. 13. Ctrl + Shift + D This shortcut will lock only the cells in the last column of the worksheet. To use it, press and hold the Ctrl and Shift keys, and then press the D key. Only the cells in the last column of the worksheet will be locked. 14. Ctrl + Shift + E This shortcut will lock only the cells in the last row of the worksheet. To use it, press and hold the Ctrl and Shift keys, and then press the E key. Only the cells in the last row of the worksheet will be locked. 15. Ctrl + Shift + F This shortcut will lock only the cells in the first cell of the worksheet. To use it, press and hold the Ctrl and Shift keys, and then press the F key. Only the cells in the first cell of the worksheet will be locked. F4 is one of the most used shortcuts in Excel. It locks a reference, making it absolute to some extent depending on how many times you press it. Written in Excel terms, it “toggles absolute and relative references”. If you can’t get it to work, here’s why: 1: You are using a MAC The F4 shortcut to lock a reference only works on Windows. If you’re running MAC, use the shortcut: ⌘ + T to toggle absolute and relative references. 2: Your marker is not INSIDE the reference when you use the shortcut You can’t select a cell and press F4 and have it change all references to absolute. You need to have your marker placed inside the reference in the formula before it works when you hit the shortcut. After you hit F4 once, it looks like this. 3: You are using a laptop keyboard Laptop keyboards are smaller than stationary ones so typically, the F-keys (like F4) are used for something else. This is easily fixed! Just hold down the Fn key before you press F4 and it’ll work. That’s it 🙂 Now, you’re ready to use absolute references in your formulas.
This article describes the keyboard shortcuts, function keys, and some other common shortcut keys in Excel for Windows. This table lists the most frequently used shortcuts in Excel.
Top of Page The ribbon groups related options on tabs. For example, on the Home tab, the Number group includes the Number Format option. Press the Alt key to display the ribbon shortcuts, called Key Tips, as letters in small images next to the tabs and options as shown in the image below.
You can combine the Key Tips letters with the Alt key to make shortcuts called Access Keys for the ribbon options. For example, press Alt+H to open the Home tab, and Alt+Q to move to the Tell me or Search field. Press Alt again to see KeyTips for the options for the selected tab. Depending on the version of Office you are using, the Search text field at the top of the app window might be called Tell Me instead. Both offer a largely similar experience, but some options and search results can vary. In Office 2013 and Office 2010, most of the old Alt key menu shortcuts still work, too. However, you need to know the full shortcut. For example, press Alt, and then press one of the old menu keys, for example, E (Edit), V (View), I (Insert), and so on. A notification pops up saying you're using an access key from an earlier version of Microsoft Office. If you know the entire key sequence, go ahead, and use it. If you don't know the sequence, press Esc and use Key Tips instead. To go directly to a tab on the ribbon, press one of the following access keys. Additional tabs might appear depending on your selection in the worksheet.
Top of Page
Top of Page
Top of Page In Excel 2013, you can paste a specific aspect of the copied data like its formatting or value using the Paste Special options. After you’ve copied the data, press Ctrl+Alt+V, or Alt+E+S to open the Paste Special dialog box.
Tip: You can also select Home > Paste > Paste Special. To pick an option in the dialog box, press the underlined letter for that option. For example, press the letter C to pick the Comments option.
Top of Page
Top of Page
Top of Page Use the following keys to refresh data from external data sources.
Top of Page Use the following keyboard shortcuts with Power Pivot in Microsoft 365, Excel 2019, Excel 2016, and Excel 2013.
Top of Page
Top of Page
Top of Page Excel help center Basic tasks using a screen reader with Excel Use a screen reader to explore and navigate Excel Accessibility support for Excel
This article describes the keyboard shortcuts, function keys, and some other common shortcut keys in Excel for Mac.
Notes:
This table itemizes the most frequently used shortcuts in Excel for Mac.
Top of Page Some Windows keyboard shortcuts conflict with the corresponding default macOS keyboard shortcuts. This topic flags such shortcuts with an asterisk (*). To use these shortcuts, you might have to change your Mac keyboard settings to change the Show Desktop shortcut for the key.
Top of Page
Top of Page
Tip: To use the arrow keys to move between cells in Excel for Mac 2011, you must turn Scroll Lock off. To toggle Scroll Lock off or on, press Shift+F14. Depending on the type of your keyboard, you might need to use the Control, Option, or the Command key instead of the Shift key. If you are using a MacBook, you might need to plug in a USB keyboard to use the F14 key combination. Top of Page
Top of Page
Top of Page
Top of Page
Top of Page
* These shortcuts might move in another direction other than down or up. If you'd like to change the direction of these shortcuts using the mouse, select Excel > Preferences > Edit, and then, in After pressing Return, move selection, select the direction you want to move to. Top of Page
Top of Page
Top of Page
Top of Page Excel for Mac uses the function keys for common commands, including Copy and Paste. For quick access to these shortcuts, you can change your Apple system preferences, so you don't have to press the Fn key every time you use a function key shortcut.
Note: Changing system function key preferences affects how the function keys work for your Mac, not just Excel for Mac. After changing this setting, you can still perform the special features printed on a function key. Just press the Fn key. For example, to use the F12 key to change your volume, you would press Fn+F12. If a function key doesn't work as you expect it to, press the Fn key in addition to the function key. If you don't want to press the Fn key each time, you can change your Apple system preferences. For instructions, go to Change function key preferences with the mouse. The following table provides the function key shortcuts for Excel for Mac.
Top of Page
Top of Page Excel help center Use a screen reader to explore and navigate Excel Basic tasks using a screen reader with Excel Screen reader support for Excel
This article describes the keyboard shortcuts in Excel for iOS.
Notes:
Top of Page
Top of Page
Top of Page Excel help & learning Screen reader support for Excel Basic tasks using a screen reader with Excel Use a screen reader to explore and navigate Excel
This article describes the keyboard shortcuts in Excel for Android.
Notes:
Top of Page Excel help & learning Screen reader support for Excel Basic tasks using a screen reader with Excel Use a screen reader to explore and navigate Excel
This article describes the keyboard shortcuts in Excel for the web.
Notes:
These are the most frequently used shortcuts for Excel for the web.
Top of Page Excel for the web offers access keys, keyboard shortcuts to navigate the ribbon. If you’ve used access keys to save time on Excel for desktop computers, you’ll find access keys very similar in Excel for the web. In Excel for the web, access keys all start with Alt+Windows logo key, then add a letter for the ribbon tab. For example, to go to the Review tab, press Alt+Windows logo key, R. If you're using Excel for the web on a Mac computer, press Control+Option to start.
To go directly to a tab on the ribbon, press one of the following access keys:
Top of Page The shortcuts in this table can save time when you work with the ribbon tabs and ribbon menus.
Top of Page
Tip: If a spreadsheet opens in the Viewing mode, editing commands won’t work. To switch to Editing mode, press Alt+Windows logo key, Z, M, E.
Top of Page
Top of Page
Top of Page
Top of Page
Top of Page
Top of Page
Top of Page
Top of Page
Top of Page Access the common features quickly by using the following shortcuts:
Top of Page Excel for the web works in a browser. Browsers have keyboard shortcuts, some of which conflict with shortcuts that work in Excel on the desktop. You can control these shortcuts, so they work the same in both versions of Excel by changing the Keyboard Shortcuts settings. Overriding browser shortcuts also enables you to open the Excel for the web Help by pressing F1.
Excel help center Use a screen reader to explore and navigate Excel Basic tasks using a screen reader with Excel Screen reader support for Excel |