Since I tend to reopen files repeatedly, I like Microsoft Office's list of recently used files that appears at the bottom of the File menu in Office 2003 apps, and on the right side of the window that opens when you click the Office button in their 2007 counterparts. (These documents are also accessible via the My Recent Documents button on the left side of Open and Save As dialog boxes in Office 2003.)
What I don't like is the default of four documents that Office 2003 shows on the File menu. Since I'm likely to cycle through more than four files at a time, I reset the number to the maximum of nine. Of course, many people prefer to show no recent documents in this list. Fortunately, changing this setting is a breeze.
To change the number of files shown in your recently opened list in Office 2003 apps, click Tools > Options > General, and change the number in the "Recently used file list" up to the top limit of nine, or down to zero, if you prefer to see no files listed. (See below for a Registry tweak that disables this feature in all Office applications.) When you're done, click O.
.jpg)
Increase or decrease the number of recently opened files listed on Office 2003's File menu via this setting.
(Credit: Microsoft)The list of recently used files is enhanced in Office 2007 by adding these entries to the right pane of the window that appears when you click the Office button. You can show as many as 50 files in this pane, though they may not fit (my version of Office 2007 defaults to showing the 17 most recently opened files).
The file names are now easier to read because they're no longer truncated by the narrow width of Office 2003's File menu. You're also able to keep certain files on this list by clicking their pin icon on the right. Normally, the least recently used file would drop off the list automatically, as the maximum number of files was reached.
Add more files to the recently used list in Office 2007, or reduce the number to zero to show none.
(Credit: Microsoft)If you find the "Recently used file list" option grayed out in Office 2003, it could be due to a setting in the Tweak UI add-on for Windows that disables this option. To enable it, double-click the Tweak UI icon in the Control Panel, choose the IE tab, and check "Add new documents to Documents on Start Menu." Microsoft has more information about this in a Knowledge Base article.
Another way to customize your list of recent documents is via a Registry tweak. Just be sure to back up your Registry by creating a restore point before you make any changes. Microsoft provides step-by-step instructions for clearing your list of recently used Office files via the Registry.
Tomorrow: tweak Windows XP's list of My Recent Documents and Vista's Recent Items.
I was thinking about upgrading to a wide-screen display, but then I realized that the programs I use most often are up-and-down, not side-to-side.
So instead of shelling out a couple hundred dollars for a new monitor, I maximized my available screen space by tweaking the full-screen views in Word, Excel, and other Office apps.
Access menu options in full-screen view
To get the big-picture view of your documents, worksheets, and other Office files, there's no substitute for the full screen. You may think Office's full-screen option is an all-or-nothing affair: Either you see no menus or toolbars, or you see all of them.
In fact you can access just the standard menus (File, Edit, View, etc.) in Office 2003's full-screen mode by pressing F10 or Alt, and then pressing the underlined letters to access that menu's options or simply moving the mouse pointer to the top of the screen. The menu disappears once you've selected an option, or you can remove it manually by pressing F10 or Alt again, or Esc.
You can access other toolbars from full-screen view in Office 2003 apps by right-clicking the Close Full Screen button and choosing the one you want from the pop-up menu. Then press the Alt key to toggle between the toolbar you selected and the standard menu. Close the toolbar by right-clicking the Close Full Screen button again and unchecking it. Press Esc to exit full-screen view.
Open any toolbar in Office 2003's full-screen mode by right-clicking the Close Full Screen button and choosing it from the pop-up menu.
(Credit: Microsoft)There's no reason to leave the toolbar you need at the top of the screen. Move it to either side of the screen, the bottom of the window, or float it anywhere by dragging the "handle" on the left edge to your desired location.
If no single toolbar has the options you use most often, create your own by right-clicking any toolbar and choosing Customize > Toolbars > New. Give the toolbar a name, select a template (choosing Normal.dot makes it available to all documents), and click OK. Fill your new toolbar by clicking the Commands tab, selecting an entry in the Categories window, and dragging the desired command to the toolbar. When all your options are in place, click Close.
Add items to your custom toolbar by dragging them out of the Commands list and placing them onto the toolbar.
(Credit: Microsoft)Bonus tip: Access items on Windows' Start menu from full-screen view by pressing the Windows key, or Ctrl-Esc if your keyboard lacks such a key.
Keyboard shortcuts for moving around big Excel worksheets
Most of the worksheets you create in Excel will be deeper and wider than you can view in full-screen mode. The fastest way to navigate a monster worksheet is to use keyboard shortcuts: Ctrl-right arrow moves you to the last cell containing data in the selected row; Ctrl-left arrow to the first such cell in the row; Ctrl-down arrow to the last cell with data in the selected column; Ctrl-up arrow to the first such cell in the column; Ctrl-Home to the top-left cell of the worksheet; Ctrl-End to the bottom-right cell; Ctrl-Page Up moves you to the next worksheet; Ctrl-Page Down to the previous one; Alt-Page Up moves you one screen to the left; and Alt-Page Down one screen to the right. Microsoft provides a complete list of Excel keyboard shortcuts.
What about Office 2007?
While Word 2007 and Excel 2007 retain the Full Screen views of their predecessors (press Alt-V, U), you can't access the main menus (File, Edit, etc.) the way you can in Office 2003 apps, nor is the mini-Full Screen toolbar visible for accessing other toolbars, though you can view standard formatting options by right-clicking anywhere in the document or worksheet. Word 2007 adds the Full Screen Reading view, which preserves your Quick Access toolbar and View Options at the top of the screen, while also showing two pages of the document side by side. You can scroll to other pages two at a time by clicking the hand icon that appears in the bottom-right corner of the window, and the bottom-left and -right corners of subsequent pages of the document. You also get a jump menu at the top of the window for moving to specific sections or pages of the file.
Unfortunately, while you can add comments to the document in this mode, you can't make changes to the file itself. That's why I'm glad you can still work in full-screen mode, though you lose easy access to toolbars. Perhaps there's a way to return toolbar access in this mode in Office 2007's ribbon apps that I don't know about. Or maybe somebody has written an add-on that returns this functionality. I'll keep looking and let you know what I find.
Tomorrow: take a look under Windows' hood with Process Explorer and Event Viewer/Windows Event Log.
You trust Microsoft Office with your most important documents, spreadsheets, e-mail, and presentations. Unfortunately, many of the default security settings in Office applications may not provide a sufficient level of protection for your data, your system, and your reputation. Follow these steps to fine-tune the security settings in Office 2003; tomorrow I'll cover the new security options in Office 2007's Trust Center and elsewhere.
Office 2003 lets you encrypt files so that you need a password to read or edit them. In Word 2003, open the document and click Tools > Protect Document. To restrict the styles that can be applied to the file, check Limit formatting to a selection of styles, and click Settings. Uncheck the styles you don't want to allow, or choose one of the other style-restriction options, and click OK. To make the document read-only, check Allow only this type of editing in the document, and select one of the options in the drop-down menu: Tracked changes, Comments, Filling in forms, or No changes (Read only).
Choose an option in Word 2003's Protect Document dialog box to restrict access to the document.
You can also designate the people who can access the file by clicking More users, entering their user names or e-mail addresses, and clicking OK. When you're done, click Yes, Start Enforcing Protection. In the resulting dialog box, choose either Password and enter the password twice that will decrypt the file, or select User authentication, which allows the people you designate to remove the file's protection.
The User authentication option requires Microsoft's Information Rights management, which requires the Windows Rights Management client. This in turn requires a .NET Passport account, and your agreement to the "free trial," though there's no indication if or when the trial will end. Microsoft promises to maintain the privacy of your files, and to make them available for three months after the trial ends, if you maintain the .NET Passport account. There may be a good reason to go this route, but to keep things simple, I stick with the password option. To remove these settings, click Tools > Unprotect document, and enter the password (if you chose this method of protection).
Choose Password and enter the password that will open the file, or select User authentication to allow the people you designate to read, edit, and/or comment on the document.
To protect a worksheet or file in Excel 2003, click Tools > Protection, and choose your preferred protection method: Protect Sheet, Allow Users to Edit Ranges, Protect Workbook, or Protect and Share Workbook. If you choose the first option, you're prompted to enter a password to unlock the sheet, and you can limit the actions people can take when working on the sheet. The second selection opens a dialog box in which you can specify the ranges that will be unlocked by a password by clicking New and entering the ranges. You can allow specific people to edit, or list the users who can't edit the range without a password by clicking Permissions and entering their user or group names. The third and fourth options are similar to the first, but apply to the entire workbook rather than a specific worksheet.
In PowerPoint 2003, click Tools > Options > Security, enter a password that will let the presentation be opened or modified, and click the Advanced button to select an encryption type. This dialog box also lets you remove hidden data from the file, and adjust your macro security settings (the default allows only signed macros from trusted sources, though this is of questionable value since "trusted sources" is pretty meaningless).
Outlook 2003's security options let you encrypt outgoing attachments, restrict the sites that can send you scripts and active content (the same list that's in your Internet Options), and limit the receipt of images and file downloads. But two of the most important things you can do to protect yourself from malware in Outlook are to turn off the Reading Pane (aka Preview Pane), and to view your mail as plain text. To deactivate the Reading Pane, click View > Reading Pane > Off. And to switch from HTML mail to the safer plain text, click Tools > Options > E-mail Options, check Read all standard mail in plain text, and click OK. When you want to view a message in its original HTML format, click the beige message bar across the top of the message window and select Display as HTML.
Protect yourself from malicious messages in Outlook 2003 by selecting "Read all standard mail in plain text" in the program's E-mail Options.
Protect your reputation with the Remove Hidden Data tool: Maybe you're one of the many Office users who have suffered the embarrassment of sending someone (or a lot of someones) a file that hadn't had its revisions and comments deleted. To minimize the chances of the public seeing more of your files than you intend, download Microsoft's free Remove Hidden Data tool. (I described this program and four other great Office freebies in an earlier post.)
Tomorrow: get more out of the new security options in Office 2007.
On Tuesday I reported on Microsoft Outlook 2007's unexcused absence from my Vista PC. I thought the problem might due to Outlook 2003 being installed on the same machine. When I upgraded to Office 2007, the older versions of the apps remained on my system, even though I never used them. This didn't appear to be a problem until Outlook 2007 took a hike.
My second surprise was my inability to uninstall Office 2003. Vista's Programs and Features Control Panel applet (which XP calls Add or Remove Programs) would pop up this error message: "This patch package could not be opened. Contact the application vendor to verify that this is a valid Windows Installer patch package." You'll find more information about this and similar Windows error messages in this Microsoft knowledgebase article.
The fix entails downloading and running Microsoft's Windows Installer CleanUp Utility (this link starts the download automatically). The program also helps cure problems you encounter when trying to install Office and other apps that rely on the Windows Installer, including Adobe Acrobat. After you download and install the program, open it by clicking its shortcut on the Start menu, select the app from the list, and click Remove > OK > Exit.
Microsoft's Windows Installer CleanUp Utility can fix programs that refuse to install or be removed from your system.
Pay attention to Microsoft's warnings about this tool: It changes your Registry, an activity that's always fraught with peril. Also, if you reinstall the program, make sure you use the same directory as the previous installation to avoid placing duplicate copies of files on your hard drive.
I'm happy to report that Outlook 2007 has remained in place since I removed my old Office apps using the installer cleanup tool. I can't say for sure that the two problems are related, but a fix is a fix.
Monday: Clear space on your hard drive by manually deleting the unnecessary files that auto-cleanup tools leave behind.
Microsoft is killing off a feature in Office 2003 that the company said helped save time, but also ran the risk of exposing confidential information.
As part of Service Pack 3 of Office 2003, which will be available Tuesday as a free download from Microsoft's Web site, Microsoft is disabling Word 2003's "fast save" feature, which works by saving the changes made since the last save, rather than rewriting the whole document to disk.
"While the Fast Save feature speeds up the document-saving process by saving only the changes made to a document, the saved document may contain metadata, such as comments, erased text, previous versions, and authorship," Microsoft said in a white paper on the update. "Disabling Fast Save ensures that confidential data is protected against improper disclosure."
The change is part of what is expected to be the last major update to Office 2003. Service Pack 3 comes nine months after the broad release of Office 2007. It also includes a number of fixes and security enhancements and is designed to work better than prior Office 2003 versions with Windows Vista and Internet Explorer 7. Microsoft still recommends large businesses test the software to make sure it plays nice with their collection of software.
- prev
- 1
- next
