Information management and technology assurance

EXCEL    To add a line break inside an individual cell, position your cursor at the place you want the break and press Alt+Enter.     To synchronize data from one cell to another (even in another worksheet), go to the source cell, press =, then go to the target

If you have a file or folder that you use fairly often but you do not want to clutter your desktop or your Start menu with shortcut icons, consider this method suggested by Paul McClain, controller at the Hillcrest Medical Center in Tulsa, Okla.: In Office 2003’s Word or Excel,

Q: I get loads of e-mails, and while I appreciate your suggestions, I’m just a low-tech guy and would like to remain low-tech—if you get my meaning. So, is there some easy way to bring more order to my inflow of e-mails without making my life more complicated by loading

Q: My partner says there’s an F4 shortcut to creating absolute cell references in Excel formulas, but for the life of me I can’t make it work. What am I doing wrong?   A: Your partner is right, but while I can’t tell you what you’re doing wrong, I can

Several readers questioned my suggestion about using a USB flash memory thumb drive to add zip to a computer’s operating system (“Boost Your System Memory With a USB Flash Memory Stick,” June 09, page 86). On further investigation, I am scratching that suggestion. I’ve since learned that not only doesn’t

Q: I just got a new ultralight notebook for when I travel. It has one of those super-fast solid-state drives. My maintenance program for my regular hard-drive computers in the office includes regularly running a defragmentation program. That way, I can be assured that they will always be able to

Q: To make an Excel table fit better on a page when I print it, I frequently have to transpose it—that is, move all the data from, say, rows 1, 2 and 3 and put them into columns A, B and C. To do that I have to move each

Q: I just started using Office 2007, and it contains a couple of things I can’t figure out. One, which I find most intriguing, is a pushpin. When I click on the Office icon to save a document, a list of Recent Documents appears, just like in Office 2003, but

Q: What’s your take on Microsoft’s new search site, Bing? A: I found Bing to be very good. In some ways it’s better than Google, but in some ways it’s not as good—or at least no better. The bottom line: I like them enough that I decided to keep both

Q: When I’m working in an Excel spreadsheet, sometimes I need to do some quick calculations, and the Calculator that comes with Office would be the perfect tool—except it’s only accessible when I switch out of the Excel window. It should be right where I need it—on top of the

Q: I use Outlook to handle my e-mail, calendar and to-do list. While it serves many of my needs, I wish it could do more. For example, when someone sends me an e-mail, it’s easy to add that person to my Contacts list, but when I want to save other

Q: I was reading your December 2008 item “Create a Shortcut for Easy Access to System Restore” (page 103), and it occurred to me I could free up loads of space on my crowded hard drive by getting rid of old, useless restore points. The trouble is, I can’t access

After reading my response in the column item “Design a Personal Paper Calendar in Outlook” (May 2009, page 77), Brandon B. Buhler, manager of Global IFRS and Offerings Services for Deloitte & Touche LLP (USA), suggested another way to create a paper calendar in Outlook. He says Microsoft’s Calendar Printing