Information management and technology assurance

Q: A colleague showed me how to add the path and file name to an Excel spreadsheet, and that’s real handy. But the Header screen (see screenshot below) leaves much to be desired: It doesn’t tell what each of those 10 icons does. Sure, I can figure it out from

Q: When I’m not at my computer, I experience what I call calendar withdrawal. Sure, I could carry a little pocket paper calendar, but then I’d have to keep it synced with Outlook. No, thank you. And unlike our president, I’m not about to go high-tech with a data phone.

Q: I run XP and Office 2003, and I was rummaging through the Options menu (click on Tools, Options), and in the Save tab I came across an option to Save AutoRecover info every:. And then it gives you the choice of how frequently you want it to save. Huh?

Some of the worksheets in my Excel files are in landscape orientation and some are portrait. To maintain the orientations when I print the entire file, I print each worksheet separately, which is time-consuming. Is there some way to do the task in one print order? Obviously you never tried

When I copy something in Word, say, with Ctrl+C, and then move on to edit and even copy material in some other part of my document, is there a way to retrieve the snippets I copied for later use? Absolutely. The tool you need to exploit is the Office Clipboard,

When I boot up my Windows XP computer, I keep getting a pop-up above my system tray that says: Updates are ready for your computer. Click here to install these updates. How do I know this is not some kind of virus? There is no indication who is sending them.

Help! Something happened to my shortcut keys in Word. They got all botched up. I know how to reset them, so that’s not my question. But what I discovered when I started to reset them was that I have way more shortcuts than I thought I had— and for tasks

When I used Word 2003, I could italicize a whole word by putting the cursor anywhere in the word and then pressing Ctrl+I. But when I do that in Word 2007, nothing happens. What’s up? Word 2007 can do it, but you have to tell it to. Here’s how: Click

There are a handful of people I communicate with by e-mail a half-dozen times a day. Each time I want to send them a note I have to set up a new e-mail and either click for their address or type it in. There has to be a better, faster

I usually enhance my memos with borders—lines and dashes—but it’s a tedious job clicking all those keys. I know I can do it by going to the Format menu and clicking on Borders and Shading, but that’s even more cumbersome. Is there an easier way to do it? Yes, there’s

I can’t tell you how many times I accidentally pressed the Insert (Ins) key and innocently typed over a complex paragraph that I worked on for more than an hour. Thanks for the blessed Ctrl+Z keystrokes, which undid my accidental erasures. Isn’t it about time the Insert key was removed

Ctrl+1: Displays the Format Cells dialog box. Ctrl+2: Applies or removes bold formatting. Ctrl+3: Applies or removes italic formatting. Ctrl+4: Applies or removes underlining. Ctrl+5: Applies or removes strikethrough. Ctrl+6: Alternates between hiding objects, displaying objects and displaying placeholders for objects. Ctrl+7: Displays or hides the Standard toolbar. Ctrl+8: Displays

I know the shortcut for entering a date in Word is Alt+Shift+D, but I don’t know how to change the way the date is displayed. I want the date format to be March 19, 2009, not 3/19/09. You can change the default by clicking on Insert, Date and Time, which