Information management and technology assurance

Character spacing of justified type is a common problem, and, I’m sorry to say, depending on how fussy you are, you may have to try several format tweaks before you can repair, or at least minimize, the problem. To save time, try these steps: Add automatic hyphenation. The hyphenation option

 I’ve got a “security” problem. I often distribute a memo to staff members inviting them to use Track Changes to suggest editorial changes and to make comments on it. Every now and then someone—intentionally or not, I don’t know—effectively erases all the work done by those who read and edited

So what you want is a formula that locates the last number in a column or row. An Excel array formula can perform the search and then drop the target number in any formula you wish. Here’s how it’s done: If the column with prices starts at cell E1, the

In the pre-Vista days, renaming computers was a snap, but Vista makes you dig down several menu layers and the trip is a little tricky. Start by opening Control Panel ; if that icon isn’t already on your desktop, now’s a good time to install it because it’s one of

Alt+Esc: Switches keyboard focus to next application window on taskbar. Press Esc more than once to switch through successive windows. Add Shift to reverse the direction. Move to next Excel worksheet: Ctrl+Page Up goes to the right; Ctrl+Page Down goes to the left.

 I’m glad you find it helpful. Yes, you can default to a tinted screen. It takes a bit of effort, but, since you’re finding it so helpful, I’m sure you’ll gladly invest the effort to go through the steps. Many middle-age or older users or those who suffer from mild

 Your colleague’s right. There’s no need to switch into Outlook to compose and transmit a message. In fact, you even can do it in Excel. Not only can you send e-mails in those applications, but also you can add the document or spreadsheet you’re in as an attachment. You need

   Although there is no official way to do that, I’ll show you an unpublished way to trick XP into displaying that information, and it works in all Office XP applications. If you’re running XP, you can convert this… …into this full path statement of the open file: Office 2007

  The easiest way to do that is to apply a formula using two columns—store the full nine-digit number in one, which then is hidden and protected, and apply a formula that effectively camouflages all but the last four digits in the other, as shown in the screenshot below. The

  You can do it several ways, but I think Excel’s Data Validation tool does it best. You can program it to display a popup memo with your instructions and then disappear after data are entered. The screenshot below illustrates what a Data Validation pop–up memo looks like when cell

   It’s very easy. Go to the File menu, click on Page Setup and make sure the Header/Footer tab is selected. Click on the Custom Header or Custom Footer button, depending on which you want, and then, depending on where you want the graphic to appear on the page, click