October 2005
Tidbits
- Move a sheet from one workbook to another (MS Excel)
- Track changes in your documents (MS Word)
- No more highlights of new programs! (Windows XP)
- Adieu
Move a sheet from one workbook to another (MS Excel)
If you often work with workbooks that are related to each other, you may have wanted to move or copy a sheet from one into another. It's really quite easy to do! Just follow these steps:
- Open both workbooks and arrange them so that you can see both at the same time. (The easiest way to do this is to select WINDOW from the menu bar, then ARRANGE and select HORIZONTAL.)
- Simply drag the appropriate worksheet tab to move the sheet to the other workbook.
- If you want to COPY rather than MOVE the worksheet, be sure to hold down the CONTROL key while you drag the tab. This keeps the worksheet in the original file and adds it to the other workbook.
Pretty simple, huh?
Track changes in your documents
When you're working on a draft of something, it might be useful to use Word's Track Changes feature. You can turn this feature on and off by choosing TOOLS > TRACK CHANGES from the menu bar. (For you keyboard shortcut enthusiasts, it's CTRL + SHIFT + E.)
Once you turn it on, all of the changes you make to your document will appear in a different color (not a different color for every change, just a different color than your original). Track Changes is not a global setting, so you must turn it on for each document you work in.
The Track Changes feature can also be customized to set specific colors for different authors, as well as options for underlining or using strikethrough and other formatting options. To customize your Track Changes options, go to TOOLS > OPTIONS on the menu bar and select the TRACK CHANGES tab.
This tool can be particularly helpful with documents being worked on by multiple people. Give it a try!
No more highlights of new programs!
If you're an XP user, you've probably come across their highlighting feature whenever you add a new program. Whenever you install a new program, it highlights the program name in the start menu and has a little pop-up window tells you what you already know.
Ready to get rid of that nice little feature? I am! Here's how:
- Right-click on the START button.
- Choose PROPERTIES.
- Click the CUSTOMIZE button.
- Select the ADVANCED tab.
- Deselect the "highlight newly installed programs" check box.
- Click OK.
WooHoo! No more highlights.
Adieu
Farewell until next time from the library system where all the computers are fast, all the books are worth reading, and all the librarians are above average!
This issue of Tidbits was written by Beth Carpenter, Web Services Manager for the Outagamie Waupaca Library System. Please send any comments or questions about this issue to Beth.
Supporting public libraries in Outagamie and Waupaca counties