Microsoft Excel Mac App Microsoft

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

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.

Microsoft Excel Mac App Microsoft

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.

Microsoft Excel Mac Download