Information management and technology assurance

All I wanted to do was copy a bunch of hyperlinks from one worksheet into another. But often when I highlight the cell containing the hyperlink, the link gets triggered before it can perform the copy task. Is there a way to prevent that? Yes, there is a little trick

I am struggling to wade through the collection of hard-to-find application functions in Office 2007. I concede that, once I locate them, some are more powerful than those in the prior version of Office, but first you’ve got to find them in that cluttered ribbon. Any thoughts? I’ve been asked

A proper place for the mouse: Since I’m a lefty, I guess I’m biased, but I think the right place for the mouse is on the left of the keyboard. That leaves your right hand free to work the number pad. Hard to make the switch from right to left?

It doesn’t look very professional to print an Excel worksheet displaying those little error symbols (#DIV/0! or #N/A). And even though I know they are harmless, I don’t want to have to explain them to a client. How can I keep them off my printed sheets without having to go

In my business I have to assemble a wide range of scenarios so we can prepare negotiations on pricing certain projects, and since the scenarios usually contain many variables, that job can take hours. Any ideas for speeding the process? Sure enough, Excel has a perfect tool for that job,

Every now and then I have to reverse the order of a long list in Excel that is not in alphabetical or numerical order—a tedious job. Do you know of a shortcut? Yes, you can adapt Custom Lists, a tool you should become familiar with because it is versatile and

I usually set up my annual budget in one Excel workbook, and then I add 12 more sheets—one for each month of the year—so I can easily track the monthly data. Each sheet contains the same rows, columns and formulas. Only the headings on each worksheet are different, along with

Each year I take some of my prior-year Excel workbooks and delete all the old data except for the formulas—a tedious process. Is there a better way to do this? Excel has a tool for that. Highlight the area of the worksheet you want cleared. In this case, since the

I use a spreadsheet for my work that’s formatted in a very complicated way. So every time I open a new worksheet, I have to go through all the preliminary format setup steps to prepare it for my special requirements—such as columns with varying widths and even different colors for