Was this information helpful?

Ctrl Backspace. Move active cell clockwise in selection.

Move active cell down in selection. Move active cell up in selection. Shift Enter. Move active cell right in a selection. Move active cell left in a selection. Shift Tab. Extend selection by one cell right. Extend selection by one cell left. Extend selection by one cell up. Extend selection by one cell down. Extend the selection to the last cell right. Extend the selection to the last cell left. Extend the selection to the last cell up. Extend the selection to the last cell down. Extend selection up one screen. Shift PgUp. Extend selection down one screen.

Shift PgDn. Extend selection right one screen. Alt Shift PgDn. Extend selection left one screen. Alt Shift PgUp. Extend selection to start of row. Shift Home. Extend selection to first cell in worksheet. Ctrl Shift Home. Extend selection to last cell in worksheet. Ctrl Shift End. Toggle extend selection mode. Fn F8. Display 'Go To' dialog box. Ctrl G. Select cells with comments. Ctrl Shift O. Select current region around active cell. Select current region. Select current array.

Select row differences. Select column differences.

222 Excel shortcuts for Windows and Mac

Ctrl Shift. Select direct precedents. Ctrl [. Select all precedents. Select direct dependents. Ctrl ]. Select all dependents. Select visible cells only. Alt ;. Edit the active cell. Insert or edit comment. Shift F2. Cancel entry. Select one character right. Select one character left. Move one word right. Move one word left. Select one word right. Select one word left. Select to beginning of cell. Select to end of cell. Shift End. Delete to end of line. Ctrl Delete.

Frequently used shortcuts

Delete character to the left of cursor. Delete character to the right of cursor. Fn Delete. Start a new line in the same cell. Alt Enter. Enter and move down. Enter and move up. Enter and move right. Enter and move left. Complete entry and stay in same cell. Ctrl Enter. Enter same data in multiple cells. Insert current date. Ctrl ;. Insert current time. Ctrl Shift: Fill down from cell above. Ctrl D. Fill right from cell left. Ctrl R. Copy formula from cell above. Ctrl '. Copy value from cell above. Ctrl Shift ". Add hyperlink. Ctrl K. Display AutoComplete list. Flash fill.

Ctrl E. Format almost anything. Ctrl 1. Display Format Cells with Font tab selected. Ctrl Shift F.

Thank you for your feedback!

Apply or remove bold formatting. Ctrl B. Apply or remove italic formatting. Ctrl I. Apply or remove underscoring. Ctrl U. Apply or remove strikethrough formatting. Ctrl 5. Add or remove the shadow font style. Add or remove the outline font style. Align center.

Align left. Align right. Alt H 6. Remove indent. Alt H 5. Increase font size one step. Alt H FG. Decrease font size one step. Alt H FK. Apply general format. Apply currency format. Apply percentage format. Apply scientific format. Apply date format. Apply time format. Apply number format.


  • Mac Excel Keyboard Shortcuts | xosogewuce.ml.
  • mac full coverage liquid foundation!
  • next release of microsoft office for mac?
  • Excel video training!
  • Table of Contents:?
  • uninstall software mac os 10.8.

Copyright Terms of Use. A wiki-style reference database for keyboard shortcuts. Comments Export as: Table of Contents: Function keys Moving and scrolling in a sheet or workbook Previewing and printing Entering data on a sheet Working in cells or the Formula bar Formatting and editing data Working with a selection Selecting cells, columns, or rows Charts Data forms Filters and PivotTable reports Outlining data Toolbars Windows Dialog boxes. Turn off the Mac OS X keyboard shortcut for this key. On the Keyboard tab, select the check box for Use all F1, F2, etc.

The following table provides the function key shortcuts for Excel for Mac. Use a screen reader to explore and navigate Excel. Basic tasks using a screen reader with Excel. 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. Keyboard shortcuts in Excel for Mac. Expand your Office skills. Get new features first. Was this information helpful? Yes No. Any other feedback? How can we improve it? Send No thanks. Thank you for your feedback!

Create a custom keyboard shortcut for Office for Mac - Office Support

It sounds like it might be helpful to connect you to one of our Office support agents. Contact Support. Copy the image of the screen and save it to a Screen Shot file on your desktop. Delete the character to the left of the insertion point, or delete the selection.

Excel shortcuts on the Mac - key differences

Delete text to the end of the line Note: Display the Formula Builder after you type a valid function name in a formula. Edit the active cell and position the insertion point at the end of the line. Copy the value from the cell above the active cell into the cell or the formula bar. Copy a formula from the cell above the active cell into the cell or the formula bar. Extend the selection to the last cell used on the sheet lower-right corner. Turn on the capability to extend a selection by using the arrow keys.