Shortcuts Excel Mac Keyboard Settings

Shortcuts Excel Mac Keyboard Settings

To use these shortcuts, you may have to change your Mac keyboard settings to change the Show Desktop shortcut for the key.

If youd like to change the direction of these shortcuts using the mouse, on the Excel menu, click Preferences, click Edit, and then, under.

For quick access to these shortcuts, you can change your Apple system preferences so you dont have to press the FN key every time you use a function key shortcut.

As Microsoft products, Excel, Word, and PowerPoint have some of the same shortcuts.

But most below are specific to using Microsoft Excel and will make managing your data a breeze.

Moving around your spreadsheets and workbooks Moving between cells, sheets, and screens using keyboard shortcuts can get you where you need to be with your data much faster.

Move up, down, left, or right one cell: Arrow keys Move between cells (unlocked sheet): Tab key Move to the start of a row: Home or Fn Left arrow Move to the start of the sheet: Control Home or Control Fn Left arrow Move to the last cell used in a sheet: Control End or Control Fn Right arrow Move up a screen: Page Up or Fn Up arrow Move down a screen: Page Down or Fn Down arrow Move a screen to the right: Option Page Down or Fn Option Down arrow Move a screen to the left: Option Page Up or Fn Option Up arrow Move to the next sheet in the workbook: Control Page Down or Option Right arrow Move to the previous sheet in the workbook: Control Page Down or Option Left arrow Go to the active cell: Control Delete Show the Go To dialog box: Control G Show the Find dialog box: Control F or Shift F5 Selecting cells Save yourself and your mouse a little work with these shortcuts for selecting cells, rows, columns, and screens.

Edit the active cell: Control U Edit the selected cell: F2 Copy: Command C Cut: Command X Paste: Command V Paste Special: Command Option V Clear: Delete Remove the selection: Control Hyphen (-) Undo: Command Z Redo: Command Y Hide a column: Command Right parenthesis or Control Right parenthesis Hide a row: Command Left parenthesis or Control Left parenthesis Unhide a column: Command Shift Right parenthesis or Control Shift Right parenthesis Unhide a row: Command Shift Left parenthesis or Control Shift Left parenthesis Group selected cells: Command Shift K Ungroup selected cells: Command Shift J Fill down: Command D Fill right: Command R Formatting data Like in a word processing app like Microsoft Word, you can format data in your Excel workbook cells and these shortcuts make it simple.

Expand or collapse the Formula Bar: Control Shift U Display the Formula Builder: Shift F3 Display the Formula Builder (after adding a function name): Control A Start a formula: Equal sign () Enter a formula as an array formula: Command Shift Return or Control Shift Return Calculate the active sheet: Shift F9 Insert the AutoSum formula: Command Shift T Insert the current date: Control Semicolon (;) Insert the current time: Command Semicolon (;) Cancel an entry in a cell or the Formula Bar: Escape key Wrapping it up While this big list of keyboard shortcuts for Excel gives you lot to work with, its not the end.

There are plenty of other shortcuts you can use when working with spreadsheets and workbooks.

Pop open the Help menu in Excel and search for keyboard shortcuts.

Also, take a look at these keyboard shortcuts for Numbers on Mac or our complete list of shortcuts for other Mac apps.

Tagged: Apps Excel Keyboard Shortcuts Mac app Microsoft Office Numbers Shortcut Shortcuts Tutorial MORE FROM iDB Keyboard shortcuts for Microsoft Word on Mac Keyboard shortcuts for Numbers on Mac Keyboard shortcuts for the TV app on Mac Newsletter Get updates directly into your inbox.

Home Apps Tutorials Jailbreak News Jailbreak Tweaks Downloads Wallpapers Accessories Deals Podcasts Write for iDB Contact Us.

Shortcuts For Mac Excel