New, tips, and more
The Office Tips and Hints blog regulary has some great tips (hence the name). I thought one mentioned the other day was fascinating. It shows how to read all the forumalas in your worksheet and put them inside comment bubbles. You can read all about it at http://www.klippert.com/TCC/Blog/2005/03/excel-show-formulas-in-cell-comments.html
I’m sure many of you have heard of this before, but I was just reminded of it recently. Martin Aignesberger has written a bunch of utilities, one of them being software that checks your bookmarks: AM-DeadLink detects dead links and duplicates in your Browser Bookmarks. If a Bookmark has become unavailable you can delete it …
Someone at work asked how they can get an entire path name in the footer of their Excel spreadsheet. Excel 2000 only allows you to put the filename is. There is a Microsoft Knowledgebase article that explains how to create a very simple macro that will do this. Check it out at http://support.microsoft.com/default.aspx?scid=kb;en-us;213615
From InfoWorld: “As computers appeared on the public scene in the ’50s, psychologists marveled at the parallels between data-processing technology and the workings of the human mind. A handful of scientists of the day believed that the functional structure of the human mind was fully analogous to that of the computer. Considering that computers in …