Action Windows Mac Undo ctrl + z F1 / Command + z Cut text from the active cell ctrl + x F2 / Command + c Edit a cell comment SHIFT + F2 Shift + F2 Copy text from the active cell ctrl + c F3 Open the Formula Builder SHIFT + F3 Shift + F3 Paste text into the active cell ctrl + v F4 Repeat the last Find (Find Next) Shift + F4 Close the window ctrl + F4 Command + q / Command + F4 Display the ' Go To ' dialog box F5 F5 Display the ' Find ' dialog box ctrl + f Command + f / Shift + F5 Restore the window size. How to create a contact group in outlook 2011 for mac. Ctrl + F5 Command + F5 Move to the next pane in a workbook that has been split F6 F6 Move to the previous pane in a workbook that has been split SHIFT + F6 Shift + F6 Move to the next workbook window ctrl + F6 command + F6 Move to the previous workbook window ctrl + Shift + F6 comand + Shift + F6 Check spelling F7 F7 Turn on extend selection mode F8 F8 Add to the selection Shift+ F8 Shift+ F8 Display the ' Macro ' dialog box Alt + F8 Option + F8 Calculate all sheets in all open workbooks F9 F9 Calculate the active sheet. Shift + F9 SHIFT + F9 Display a contextual(right-click) menu. Shift + F10 SHIFT + F10 Maximize or restore the workbook window Ctrl + F10 Command + F10 Make the first button on a floating toolbar active OPTION + F10 Insert a new chart sheet. F11 F11 Insert a new sheet. Excel for mac & not working. Shift + F11 Shift + F11 Insert an Excel 4.0 macro sheet Command + F11 Display the ' Save As' dialog box F12 F12 Display the ' Open' dialog box Command + F12 Display the ' Print' dialog box CONTROL + SHIFT + F12. Windows shortcuts in blue. Mac shortcuts in red. Excel for mac 2011 latest version. Most current packages for Office for Mac. The following table lists the most current packages for Office for Mac and for the individual applications, such as Word and Excel. All packages are 64-bit only. The build date is listed in parentheses, in a YYMMDD format, after the version number. In past versions of Excel, I could freeze panes vertically or horizontally by moving my cursor to the edge of the spreadsheet until a small icon like this appeared: I could then drag the icon over (or down) to freeze the pane. ![]() ![]() Editing Copy ctrl+ c ctrl+ c Paste ctrl+ v ctrl+ v Undo ctrl+ z ctrl+ z Redo ctrl+ y ctrl+ y File Open ctrl+ o ctrl+ o New ctrl+ n ctrl+ n Print ctrl+ p ctrl+ p Save ctrl+ s ctrl+ s Save as f12 ⌘+ shift+ s Go to next workbook ctrl+ tab ⌘+ ~ Close file ctrl+ f4 ctrl+ w Close all open Excel files alt+ f4 ctrl+ q Ribbon Show ribbon accelerator keys alt Show/hide ribbon ctrl+ f1 ⌘+ opt+ r Formatting Open Format dialog ctrl+ 1 ⌘+ 1 Bold ctrl+ b ⌘+ b Italic ctrl+ i ⌘+ i Underline ctrl+ u ⌘+ u Number format ctrl+ shift +! Ctrl+ shift +! Chloe, Unfortunately for a Mac, that command does not exist, but there are ways to get close to the Windows functionality: a) You can Enable Ctrl + Arrows by disabling Mission Control settings on your Mac by following these steps: 1. Go to System Preferences > Keyboard. Go to “Keyboard shortcuts” tab. Click “Mission Control” in the left window. Expand the “Mission Control” tab in the right window and click off “Move left a space” and “Move right a space” b) You can enable Ctrl+Spacebar for highlighting columns by disabling Spotlight Search 1.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |