The Analysis Tool Pack is not included in the Mac version and needs a separate program as a work-around. Note, Solver was added back into Excel 2011 with. Solver Tutorial: Excel 2011 (Mac) Summary: This tutorial will show how you can activate Solver and the Analysis ToolPa k in Excel 2011 for Mac.This also works for files in the Finder. Command-C: Copy the selected item to the Clipboard. Note: If a shortcut requires pressing two or more keys at the same time, this topic separates the keys with a plus sign (+). Most shortcuts will work in earlier versions of Excel.Many of the shortcuts that use the Ctrl key on a Windows keyboard also work with the Control key in Office 2016 for Mac. Printed quick reference card We also have a laminated quick reference card with a full set of Excel shortcuts for Mac and Windows: Click here to learn more Disclaimer These shortcuts were tested on Excel 2010 for Windows, and Excel 2011 for the Mac. If you like to work with the keyboard, spend some time learning Excel's built-in keyboard shortcuts and creating custom.In some apps, you can undo and redo multiple commands. You can then press Shift-Command-Z to Redo, reversing the undo command. Command-Z: Undo the previous command. This also works for files in the Finder.To minimise all windows of the front app, press Option-Command-M. Command-M: Minimise the front window to the Dock. To view the front app but hide all other apps, press Option-Command-H. Command-H: Hide the windows of the front app. To find the previous occurrence, press Shift-Command-G. Command-G: Find Again: Find the next occurrence of the item previously found.
(If you use multiple input sources to type in different languages, these shortcuts change input sources instead of showing Spotlight. To perform a Spotlight search from a Finder window, press Command-Option-Space bar. Command-Space bar: Show or hide the Spotlight search field. To close all windows of the app, press Option-Command-W. Command-W: Close the front window. Shift-Command-N: Create a new folder in the Finder. Learn more about screenshots. Or use Shift-Command-3 or Shift-Command-4 for screenshots. Control-Command-Power button:* Force your Mac to restart, without prompting to save any open and unsaved documents. Control-Power button* or Control-Media Eject : Display a dialogue asking whether you want to restart, sleep or shut down. Control-Shift-Power button* or Control-Shift-Media Eject : Put your displays to sleep. Option-Command-Power button* or Option-Command-Media Eject : Put your Mac to sleep. Power button: Press to turn on your Mac or wake it from sleep. Press and hold for 1.5 seconds to put your Mac to sleep.* Continue holding to force your Mac to turn off. This helps you to avoid using them unintentionally. Shift-Command-Q: Log out of your macOS user account. Control-Command-Q: Immediately lock your screen. If any open documents have unsaved changes, you will be asked whether you want to save them. Control-Option-Command-Power button* or Control-Option-Command-Media Eject : Quit all apps, then shut down your Mac. If any open documents have unsaved changes, you will be asked whether you want to save them. Excel 2011 Shortcuts Software Updates AgainShift-Command-G: Open a Go to Folder window. Shift-Command-F: Open the Recents window, showing all of the files you viewed or changed recently. Shift-Command-D: Open the desktop folder. Shift-Command-C: Open the Computer window. (3) In Software Update preferences, check for software updates again. Shift-Command-T: Show or hide the tab bar in Finder windows. Shift-Command-R: Open the AirDrop window. Shift-Command-P: Show or hide the Preview pane in Finder windows. Shift-Command-O: Open the Documents folder. Option-Command-L: Open the Downloads folder. Shift-Command-K: Open the Network window. Option-Command-N: Create a new Smart Folder. Control-Command-A: Make an alias of the selected item. Command-K: Open the Connect to Server window. Command-Slash (/): Hide or show the status bar in Finder windows. Command-2: View the items in a Finder window as a list. Command-1: View the items in the Finder window as icons. Option-Command-Y: View a Quick Look slideshow of the selected files. Command-Y: Use Quick Look to preview the selected files. Option-Command-V: Move the files in the Clipboard from their original location to the current location. Option-Command-T: Show or hide the toolbar when a single tab is open in the current Finder window. Command-Up Arrow: Open the folder that contains the current folder. Command-Right Bracket (]): Go to the next folder. Command-Left Bracket ([): Go to the previous folder. Command-4: View the items in a Finder window in a gallery. This works only when in list view. Left Arrow: Close the selected folder. This works only when in list view. Right Arrow: Open the selected folder. Command-Down Arrow: Open the selected item. Control-Brightness Up or Control-Brightness Down: Change the brightness of your external display, if supported by your display. This works with either Brightness key. Option-Brightness Up: Open Displays preferences. Command-Brightness Down: Turn video mirroring on or off when your Mac is connected to more than one display. Option-Shift-Command-Delete: Empty the Bin without confirmation dialogue. Command-Mission Control: Show the desktop. Option-Mission Control: Open Mission Control preferences. Add the Control key to this shortcut to make the adjustment on your external display, if supported by your display. Free avast download for macThis works with either Keyboard Brightness key. Option-Keyboard Brightness Up: Open Keyboard preferences. Option-Shift-Volume Up or Option-Shift-Volume Down: Adjust the sound volume in smaller steps. This works with any of the volume keys. Option-Volume Up: Open Sound preferences. The pointer changes while you drag the item. Option key while dragging: Copy the dragged item. Command key while dragging to another volume: Move the dragged item to the other volume, instead of copying it. Command key while double-clicking: Open a folder in a separate tab or window. Option key while double-clicking: Open the item in a separate window, then close the original window. This works only when in list view. Option-click a disclosure triangle: Open all folders within the selected folder. The pointer changes while you drag the item. Command-I: Italicise the selected text, or turn italics on or off. Command-B: Boldface the selected text, or turn boldfacing on or off. Click the Go menu in the Finder menu bar to see shortcuts for opening many commonly used folders, such as Applications, Documents, Downloads, Utilities and iCloud Drive.The behaviour of these shortcuts may vary with the app you're using. Learn how to use Command or Shift to select multiple items in the Finder. Control-Command-D: Show or hide the definition of the selected word. Command-D: Select the Desktop folder from within an Open dialogue or Save dialogue. Command-T: Show or hide the Fonts window. Control-D: Delete the character to the right of the insertion point. Control-H: Delete the character to the left of the insertion point. Option-Delete: Delete the word to the left of the insertion point. Command-Semicolon ( ): Find misspelled words in the document. Fn-Down Arrow: Page Down: Scroll down one page. Fn-Up Arrow: Page Up: Scroll up one page. Control-K: Delete the text between the insertion point and the end of the line or paragraph.
0 Comments
Leave a Reply. |
AuthorLori ArchivesCategories |