|
|
While viewing a Word document in the Print Preview window, you might notice a typo, or something else that you'd like to fix quickly, before printing. However, the pointer is a magnifying glass, and when you click on the page you just zoom in or out. To edit the document, you can turn off the magnifier: In Excel 2007, remove the check mark from Magnifier in the Ribbon, to turn it off. In Excel 2003, click the Magnifier button on the toolbar, to turn it off. After you turn off the Magnifier, the pointer will change to an I-beam, and you can click on the document and edit it.
I've been using Microsoft Word since 1985, starting with Word for Mac and eventually moving to the Windows version for Word 6.0. As with other Office programs, some great new features have been added, and other features, that were working just fine, have been removed or changed. Don't get me started on Word's numbering. Most of my Word documents are currently in Word 2003, but I'm experimenting with Word 2007, in case some of my clients decide to switch. One of the new features that I've discovered is the automatic Cover Sheet. Insert a Cover Page To automatically add a cover page to the front of the Word document: On Word's Ribbon, click the Inert tab. Click the Cover Page command, to open the list of cover page options. Click on one of the options to select it. Add Details to the Cover Page On the cover page that's inserted,
Continue reading Add a Cover to a Word 2007 Document
In Outlook, as you start typing a name in the To box, a drop down list may appear, showing names of people to whom you've previously sent an email. Sometimes those names are out of date, and the list includes old email addresses. In my Outlook drop down lists there are multiple entries for some people – a current address and one or more older addresses. When sending email to those people, I waste time trying to remember which address is the correct one. I'd like to get rid of the old items in the list, so the correct addresses are the only ones left. Remove the Old Addresses Create a new email message Start typing a name in the To box When the drop down list appears, click the down arrow (or up arrow) key on your keyboard, to move to the name that you want
Continue reading Remove Old Addresses From Outlook Drop Down List
In Excel, if you divide 2 by 8, the result is 0.25. if you format the cell as a fraction, the cell might show 1/4 as the result.
What if you want to show the result as a ratio? How can you get the cell to show 1:4 instead of 1/4? There may be other ways, but here's the formula that I used.
=B2/GCD(B2,C2) & ":" & C2/GCD(B2,C2)
This formula requires that the Analysis ToolPak be installed, in Excel 2003 and earlier versions. It divides each cell by the greatest common divisor (GCD), and puts a colon between the two numbers. Would you use a different formula? __________________
I've been reviewing Word documents recently, and sometimes I'm halfway down the document and have to check on something that was in an earlier part of the file. I could scroll up, to check the text, then scroll back down to the current spot, but that's not too efficient. It's easier, and more efficient, to split the Word window, so I can see two sections at the same time. To split the window, you can choose Window|Split, then click where you want the split. Another way to create a split it to point to the Split marker, at the top of the Vertical Scroll Bar, and drag it to the position you want. Remove the Split To remove the Split marker, double-click on it. ______________
At the right of the Outlook 2007 you can display a To-Do Bar that shows a navigation calendar, a list of upcoming appointments and a task list. Very handy! When I open Outlook to check my email, I can see my calendar and tasks at a quick glance. Here's what the top of the To-Do Bar looks like. Unfortunately, it's not as useful as I first thought, since the To-Do Bar doesn't show all day events. So, if you've added a conference that will span a few days, or entered the birthdays for your friends and family members, those won't show up. Fortunately, my mom's birthday is in February, so I noticed this problem just in time! And if you didn't get a birthday card from me, it's Outlook's fault. Show Outlook Today I'll keep using the To-Do Bar, because I have a wide monitor, and the To-Do Bar
Continue reading No All Day Events in Outlook 2007 To-Do Bar
Occasionally it's useful to see two main windows in Outlook 2007 at the same time. For example, if you're clearing out your Inbox, you might want to check your Contact list, to see if someone's name is already in there. Instead of flipping back and forth between views, you can open a second window. Show the Navigation Pane If the Navigation Pane isn't visible, click the View menu, then click Navigation Pane and click Normal. To open a second window: In the Navigation Pane, right-click on a button, such as Contacts. Note: If the Navigation Pane is minimized, or the buttons are displayed as icons at the bottom of the Navigation Pane, you can right-click on those. Click on Open in New Window ________________________
Continue reading Open a Second Window in Outlook 2007
I'm reviewing Word files and inserting comments for the author. I'd like to see my comments in balloons along the sidebar, but Word won't cooperate, and shows them in a Reviewing Pane, at the bottom of the window.
I have trouble editing my comments in the Reviewing Pane. Usually when you select text and start typing, the selected text is replaced with the new text. Not in the Reviewing Pane, unfortunately, where new text is inserted beside the selected text.
It's a real annoyance, and time waster. Editing works just fine in the balloons, which is one of the reasons that I prefer them.
How To Show Balloons in Word 2003
After a few minutes of searching through the menus and options, I figured out how to show the balloons.
First, choose either Print Layout view or Web Layout view. Balloon comments will only display in these
Continue reading Show Word Comments in Balloons
It's been several years (decades?) since I studied Latin, so I can't translate any of this, but when designers need a block of text they often use Lorem Ipsum. This focuses attention on the design, rather than the text.
You could use this when setting up a web layout or Word template, to show a client how the end product might look with different fonts and styles.
There's a handy website where you can specify exactly how much text you need, and it will generate it for you, in paragraphs or bulleted lists. Then, copy and paste the results to your document.
When testing layouts in Word, I usually use the RAND function to generate random text (type =RAND() and press Enter). It creates English text instead of Latin, but is quick and easy to use.
Continue reading Random Writings
Outlook has an Out of Office Assistant that will notify people that you're not in the office, but unfortunately it's only available if you're using Exchange Server. What about me? I don't have Exchange Server, and like to leave my office occasionally.
If I'll be out of the office for more than a day or two, I notify most of my clients, but sometimes forget to tell a few people. If they email me, I don't want them to think I'm ignoring them. Fortunately, if you don't have Exchange Server, you can create your own AutoReply.
I keep forgetting how to do this, so next time I travel I can follow these AutoReply instructions for Outlook 2003 on the Microsoft website. First you'll create a message template, then set up a rule in Outlook, to determine who gets the message, and when.
When you leave the office, turn on the
Continue reading I'm Not Here Right Now
|
|
Recent Comments