Tips for Working in All the Applications in Office 2008 for Mac If you’re working with Office 2008 for Mac, you can use some of the same tips no matter which of the four applications you’re in. The actions in the following list work whether you’re in Word, PowerPoint, Excel, or Entourage:. Selecting stuff: Hold down the Shift key to extend the selection contiguously; hold down the Apple key to select noncontiguous words/sentences/paragraphs/cells/rows/columns/slides. Creating projects: Create projects with Watch Folders in Entourage’s Project Center. If you do, then all the files associated with the project — even ones you didn’t create with an Office application — will be available in the Project Gallery’s Project Center tab. Using Undo and Redo: All the Office applications have virtually unlimited Undos (shortcut: Apple key+Z) and Redos (shortcut: Apple key+Y).
That’s cool, but the Undo and Redo icons in the Standard Toolbar of all the applications (except Entourage) have drop-down lists that contain all the actions you can undo or redo. Focusing on the task at hand: Don’t forget the contextual menu, available by right-clicking (or Control-clicking) a word, cell, document, object, or almost anything else in a document. This menu usually contains commands that are useful only in the context of what you clicked and can save you time and effort.
Where to Find Some of the Odd Things in Office 2008 for Mac Office 2008 for Mac is full of handy apps and helpful tools. The following list tells you where to find some of Office 2008’s unusual or out-of-the-way features and commands:. Clip Art: Office includes a tasty selection of clip art images; launch the Clip Gallery by choosing Insert→Picture→Clip Art (Word and Excel) or Insert→Clip Art (PowerPoint). Symbols (such as ©, ™, ® or €): Choose View→Object Palette and click the Symbol tab (third from the left).
AutoCorrect On/Off: The AutoCorrect feature in all the Office applications can be a real timesaver. But sometimes it interferes with getting things done. When that happens, you can turn individual AutoCorrect items — such as Replace Straight Quotes with Smart Quotes Automatically as You Type or Automatic Bulleted or Numbered Lists — on or off by choosing Tools→AutoCorrect and then deselecting the check box for the item. Application Preferences: You would think they’d be in the Tools menu, but you’d be wrong — you find them in the Word, Excel, PowerPoint, or Entourage menus. Or skip the menu and use the keyboard shortcut: Apple key+, (comma). Preferences are specific features, such as spelling and grammar checking, automatic saving, and WYSIWYG font menus, that you can turn on or off.
Keyboard Shortcuts in Office 2008 for Mac Office 2008 for Mac is full of handy keyboard shortcuts that make accomplishing a variety of tasks quick and easy. Make the shortcuts in the following list, which apply to all the Office 2008 applications, second nature to your fingers: Command Keyboard Shortcut New Document Apple key+N Open a Document Apple key+O Open Project Gallery Apple key+Shift+P Save Apple key+S Print Apple key+P Find Apple key+F Select All Apple key+A Undo Apple key+Z Redo Apple key+Y Search Help Apple key+shift+? Minimize to Dock Apple key+M. Where to Find Help with Office 2008 for Mac If you’re having trouble figuring out how to access a feature or application in Office 2008 for Mac, help is closer than you may think. Try the resources in the following list, starting with the first one, which is the Office Help feature. You can hit the links to the Web sites listed if you don’t find what you need in the Help menu.
Office Help: Choose Help→ Application Name (that is, Word, Excel, Entourage, or PowerPoint) Help, or press Apple key+Shift+? Of course, the first place to look for help is in the Office Help system. More often than not you’ll find the answer you’re looking for here.: These pages offer official support tips from the experts at Microsoft. You can find help for Office in general as well as help for each of the applications.: These pages are online forums where Office users post questions and other Office users answer them. You often discover that your question has already been asked and answered here.
If you're used to working with Excel on Windows, one of the most confusing aspects of using Excel on a Mac is shortcuts. Even basic shortcuts you've been using for years in Windows may not work as you expect. After a few problems, you might wind up thinking that Mac shortcuts are 'totally different' or somehow 'broken'.
Excel for Mac - Customize your keyboard shortcuts. However, it still does not address all of the keyboard shortcuts that were available in Excel 2011 for Mac. Specifically, Paste Values, which was CMD+SHIFT+V. It would be super-helpful to get this back, please. Excel 2008 Screen. Keystroke Shortcuts. The Fundamentals. The Standard Toolbar. By using the keyboard arrow keys. • To Select a Cell Range: Click the first.
In reality, Excel shortcuts on the Mac are quite capable, you just have to understand and adjust to certain differences. In this article, I'll walk you through the key differences you need to be aware of to work productively with Excel shortcuts on a Mac.
Also see: // 3 minute video 1. Special symbols One of more confusing aspects of keyboard shortcuts on the Mac are the symbols you'll see for certain keys. For example, the Command key is abbreviated as ⌘, the Control key with ⌃, and the option key as ⌥. These symbols have a long history on the Mac, and you'll find them in menus everywhere. The Mac Finder – abbreviations appear in all applications, not just Excel You'll see these symbols in menus across all applications, so they're not specific to Excel. There really aren't too many symbols, so I recommend that you bite the bullet and memorize them. The table below shows some example shortcuts with a translation.
![2008 2008](/uploads/1/2/5/5/125521335/378333792.jpg)
Command Shortcut Translation New workbook ⌘N Command N Save As ⌘⇧S Command Shift S Toggle ribbon ⌘⌥R Command Option R Paste Special ⌃⌘V Control Command V Select row ⇧Space Shift Space 2. Function keys Like their counterparts in the Windows world, Mac keyboards have function keys. These keys sit at the top of the keyboard and are labeled F1 to F12 on standard keyboards and F13, F14 and higher on extended keyboards. Standard Mac keyboard with 12 function keys As you know, function keys are uses for many shortcuts in Excel. For example, you can use F1 for help, F7 for spelling, and shift + F3 to insert a function. But if you try these shortcuts directly on a Mac, they don't work.
By default, Function keys on a Mac control the computer itself, things like screen brightness, volume, video pause and play, and so on. This means that if press only the function keys in Excel, you'll end up controlling the Mac, and not Excel. To make function keys work like you expect in Excel, you need to add a key: the function or fn key. You'll find the fn key in the lower left on your keyboard. Here are a few examples: Command Windows Mac New chart F11 fn F11 Calculate worksheets F9 fn F9 Open Spelling F7 fn F7 Evaluate formula F9 fn F9 If you really hate using the fn key, you can change this behavior by changing a preference at System Preferences Keyboard. Here you can check a box that will that will change function key behavior to work like 'standard function keys'.
If you do this, however, note that you won't be able to use function keys for things like Brightness, Volume, etc. Unless you hold down the fn key. In essence, this setting reverses behavior so that you need to use fn to control the Mac. Personally, I like using the function keys to control the computer, so I leave this setting alone, and just the fn key when needed in Excel. Missing keys Another difference that may trip you up on a Mac is certain keys are missing.
Unless you're using an extended keyboard, keys like Home, End, backspace, Page up, and Page down are nowhere to be found. This is a problem, because many of these keys are used in Excel shortcuts. The solution is to use specific substitutions, as shown in the table below. Windows Mac equivalent Home fn arrow left End fn arrow right Page Up fn arrow up Page Down fn arrow down Screen right fn option arrow down Screen left fn option arrow up Move to Last cell fn control arrow right Move to first cell fn control arrow left Delete fn Delete Backspace Delete The substitutions let you perform the same actions you can do in Windows.
However, T hey can make some shortcuts seem complicated on a Mac because you have to use more keys. Note: If you're using an extended keyboard on a Mac, you don't need to worry about substitutions, since you'll have keys for Home, End, Page up, etc. Extended keyboards have all the keys 4. Ribbon shortcuts In the world of shortcuts, perhaps the most painful difference on a Mac is a lack of ribbon shortcuts. In Excel on Windows, you can use so called accelerator keys to access almost every command in Excel using only your keyboard. This doesn't matter much when you're performing an action that has a dedicated shortcut (i.e.
Control + B for bold), since dedicated shortcuts are faster than ribbon shortcuts. But when you want to trigger an action that doesn't have a dedicated shortcut (like sort, hide gridlines, align text, etc.), it hurts a bit. Excel ribbon in Windows with accelerator keys visible. No equivalent on the Mac! Just different Finally, some Excel shortcuts are just plain different on a Mac. For example, the shortcut for Edit Cell in Windows is F2, and on a Mac, it's Control + U. The shortcut to toggle absolute and relative references is F4 in Windows, while on a Mac, its Command T.
For a complete list of Windows and Mac shortcuts, see. If you want to see more Excel shortcuts for the Mac in action, see our our. These videos come from our.
Whenever we use a shortcut, we show both the Windows and Mac version. Excel 2016/Office 365 With the introduction of Excel 2016 on the Mac, Microsoft has started to adjust Mac shortcuts to be more aligned with Windows. As of February 2016, many Windows shortcuts can be used in Excel 2016/Office 365.
For example, you can use fn + F4 to toggle between absolute and relative references, Control + Shift + L to toggle a filter on and off, etc. So far, all the shortcuts that have been adjusted to match Windows shortcuts remain backward compatible with previous Mac only shortcuts. For example while fn F4 toggles references on the Mac, the old shortcut Command + T still works as well.