Microsoft Excel Sorting Mac App Microsoft

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.

Select a column: Control Space bar Select a row: Shift Space bar Select the sheet: Command A Select visible cells: Command Shift Asterisk () Expand the selection by one cell: Shift Arrow key Expand the selection to the start of the row: Shift Home or Shift Fn Left arrow Expand the selection to the start of the sheet: Control Shift Home or Control Shift Fn Left arrow Expand the selection down a screen: Shift Page Down or Shift Fn Down arrow Expand the selection up a screen: Shift Page Up or Shift Fn Up arrow Expand the selection to the last cell used: Control Shift End or Control Shift Fn Right arrow Editing cells Once you use the above options for selecting cells, use these shortcuts to edit them or their data.

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 Sorting 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 For Mac Sorting