Move and scroll in a sheet or workbook. Enter data on a sheet. Work in cells or the Formula bar. Format and edit data. Select cells, columns, or rows. Work with a selection. Use charts. Sort, filter, and use PivotTable reports. Outline data. Use function key shortcuts.
Change function key preferences with the mouse. Top of Page. Some Windows keyboard shortcuts conflict with the corresponding default MacOS keyboard shortcuts. To use these shortcuts, you might have to change your Mac keyboard settings to change the Show Desktop shortcut for the key.
Tip: To use the arrow keys to move between cells in Excel for Mac , you must turn Scroll Lock off. Depending on the type of your keyboard, you might need to use the Control, Option, or the Command key instead of the Shift key.
Note: Some smaller keyboards do not have this key. Edit the active cell and then clear it or delete the preceding character in the active cell as you edit the cell contents. Display the Formula Builder after you type a valid function name in a formula. Apply the currency format with two decimal places negative numbers appear in red with parentheses.
Apply the number format with two decimal places, thousands separator, and minus sign - for negative values. Alternate between hiding objects, displaying objects, and displaying placeholders for objects.
Select cells in a row that don't match the value in the active cell in that row. You must select the row starting with the active cell.
If you don't hold the Shift key while you drag and drop, the selected cells will be cut from the original location and pasted to the new location not inserted. Move from left to right within the selection, or move down one cell if only one column is selected. Move from right to left within the selection, or move up one cell if only one column is selected. Display the Filter list or PivotTable page field pop-up menu for the selected cell.
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. 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. Display a pop-up menu on object button menu , such as by clicking the button after you paste into a sheet. On the Keyboard tab, select the checkbox for Use all F1, F2, etc. If you're familiar with keyboard shortcuts on your MacOS computer, the same key combinations work with Excel for iOS using an external keyboard, too. The shortcuts listed in this article are the only ones that will work in this version of Excel.
To quickly find a shortcut, you can use the Search. Navigate the worksheet. Work in cells or the formula bar. If you're familiar with keyboard shortcuts on your Windows computer, the same key combinations work with Excel for Android using an external keyboard, too. Work with cells. If you use Narrator with the Windows 10 Fall Creators Update, you have to turn off scan mode in order to edit documents, spreadsheets, or presentations with Office for the web.
For more information, refer to Turn off virtual or browse mode in screen readers in Windows 10 Fall Creators Update. When you use Excel for the web, we recommend that you use Microsoft Edge as your web browser. Because Excel for the web runs in your web browser, the keyboard shortcuts are different from those in the desktop program.
Quick tips for using keyboard shortcuts with Excel for the web. Access keys: Shortcuts for using the ribbon. Keyboard shortcuts for editing cells.
Keyboard shortcuts for entering data. Keyboard shortcuts for editing data within a cell. Keyboard shortcuts for moving and scrolling within worksheets.
Keyboard shortcuts for working with objects. Keyboard shortcuts for working with cells, rows, columns, and objects. Keyboard shortcuts for moving within a selected range. Keyboard shortcuts for calculating data. Control keyboard shortcuts in Excel for the web by overriding browser keyboard shortcuts. In Search or Tell Me , type a word or the name of a command you want available only in Editing mode. Search or Tell Me searches for related options and provides a list.
Use the Up and Down arrow keys to select a command, and then press Enter. Excel for the web offers access keys, keyboard shortcuts to navigate the ribbon. Note: To learn how to override the browser's Alt-based ribbon shortcuts, go to Control keyboard shortcuts in Excel for the web by overriding browser keyboard shortcuts.
Go to the Search or Tell Me field on the ribbon and type a search term. Open the Insert tab and insert a function, table, chart, hyperlink, or threaded comment. Open the Review tab and use the Accessibility Checker or work with threaded comments and notes. Open the View tab to choose a view, freeze rows or columns in your worksheet, or show gridlines and headers.
Cycle through all the various combinations of absolute and relative references when a cell reference or range is selected in a formula. Extend selection to the last nonblank cell in the same column or row as the active cell, or if the next cell is blank, to the next nonblank cell. 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. Microsoft wants to provide the best possible experience for all our customers.
If you have a disability or questions related to accessibility, please contact the Microsoft Disability Answer Desk for technical assistance. The Disability Answer Desk support team is trained in using many popular assistive technologies and can offer assistance in English, Spanish, French, and American Sign Language. Please go to the Microsoft Disability Answer Desk site to find out the contact details for your region. If you are a government, commercial, or enterprise user, please contact the enterprise Disability Answer Desk.
Office Accessibility. Notes: The shortcuts in this topic refer to the US keyboard layout. A comma sign , in a shortcut means that you need to press multiple keys in order. Notes: To quickly find a shortcut in this article, you can use the Search. Notes: The settings in some versions of the Mac operating system OS and some utility applications might conflict with keyboard shortcuts and function key operations in Office for Mac.
This article describes the keyboard shortcuts in Excel for iOS. Notes: If you're familiar with keyboard shortcuts on your MacOS computer, the same key combinations work with Excel for iOS using an external keyboard, too.
This article describes the keyboard shortcuts in Excel for Android. In the Save changes in box, select the current document name or template that you want to save the keyboard shortcut changes in. In the Categories box, select the category that contains the command or other item that you want to assign a keyboard shortcut to or remove a keyboard shortcut from.
In the Commands box, select the name of the command or other item that you want to assign a keyboard shortcut to or remove a keyboard shortcut from.
Any keyboard shortcuts that are currently assigned to that command or other item appear in the Current keys box, or below the box with the label Currently assigned to.
In the Press new shortcut key box, press the combination of keys that you want to assign. For example, press CTRL plus the key that you want to use. Look at Current keys or Currently assigned to to see whether the combination of keys is already assigned to a command or other item. If the combination is already assigned, type a different combination. Important: Reassigning a combination of keys means that you can no longer use the combination for its original purpose. Hide Private Photos on iPhone.
All Microsoft's PowerToys for Windows. Take Screenshot by Tapping Back of iPhone. Windows 11 Default Browser. Browse All Windows Articles. Windows 10 Annual Updates. OneDrive Windows 7 and 8. Copy and Paste Between Android and Windows. Protect Windows 10 From Internet Explorer. Mozilla Fights Double Standard. Connect to a Hidden Wi-Fi Network. Change the Size of the Touch Keyboard. Reader Favorites Take Screenshot on Windows. Mount an ISO image in Windows. Boot Into Safe Mode. Where to Download Windows Legally.
Expand selected item. Collapse current item. Open list for currently selected item. Toggle Au t oFilter. Sort data ascending A -Z. Sort data descending Z -A. Display Fie l d List pane. Add new total field using s um summary. Add new total field using c ount summary. Add new total field using m in summary. Add new total field using ma x summary. Add new total field using av e rage summary. Add new total field using standard d eviation summary. Add new total field using standard deviation popula t ion summary.
Turn subtotals and grand totals on or off for selected field. Add a calculated detail f ield. Move selected field to row area. Move selected field to column area.
Move selected field to filter area. Move selected field to detail area. Apply the general number format to values. Apply the currency format to values. Apply the percentage format to values. Apply the exponential number format to values. Apply the date format to values. Apply the time format, with the hour, minute, and AM or PM, to values in the selected total or detail field.
Apply the numeric format, with two decimal places, thousands separator, and a minus sign for negative values, to values in the selected total or detail field. Make text bold in the selected field of the PivotTable view.
Make text underlined in the selected field of the PivotTable view. Make text italic in the selected field of the PivotTable view. Toggle the Navigation Pane. Cycle between open windows. Restore the selected minimized window when all windows are minimized. Turn on Resize mode for the active window when it is not maximized; press the arrow keys to resize the window.
0コメント