Excel Formula Auditing, Part 2

Last week we covered the first three items in Excel’s “Formula Auditing” tools: Tracing Precedents, Dependents, Remove Arrows and Show Formulas in Excel’s “Formula Auditing” tools. Today we will wrap up the last three features. I am sure you have never seen an “Error” popup box in Excel. That’s not true, unless you are an…

Excel Formula Auditing

At the end of last year I wrote a column with regard to Microsoft’s spreadsheet program Excel.  Due to the email response, (which to me at least was unexpected) it has now turned into three columns.  I guess there are more of you Excel users out there than I thought. I have continued to get…

Office Tricks, again

Today we will continue on with our last week’s discussion about tricks and tips for Office, which generated a lot of email, thanks! Try this. Open up a blank Word document and type the following sentence on a new blank line (without quotes) exactly as it appears here, without edits for spelling or capitalization. "teh…

Office Tricks

When I originally started writing this column years ago it was going to be devoted mostly to Microsoft Office products.  Since that time I have written about those products and most everything under the sun, at least computer-wise. Today, I am going back to the beginning and will answer questions I have received from several…