I am currently spending a large part of my workday using Excel. I love the program, but as with anything used everyday, I have a list of annoyances. (For example: the default chart colors are butt-ugly*.) While perusing
Excel 2003 Bible in hopes of picking up some new tricks, I found a link back to John Walkenbach's
spreadsheet page. I've occasionally read and enjoyed J-walk's blog, but never realized he was Mr. Spreadsheet. Anyway, his Power Utility Pack, currently on sale for $10, fixes on of my current peeves -- removal of hyperlinks.
Excel likes to automatically hyperlink anything that looks like an email or web site. You can remove them, but only on individual cells: right-click on the cell and select the "Remove Hyperlink" option. (In frustration, I've worked around this by doing copy and paste-special a couple of times.) PUP fixes this, and has other cool links like "exact copy of formula" and "search and replace in comments" and "change case." Ahhh... nerdvana.
In a redux of last year's snow prognostication, nearly all of the forecasters were hyping up the "two inches -- or more" of accumulated snow expected this weekend. As Friday approached, they were tempering this back to "an inch or two." Saturday morning we had a light dusting, not even enough to build a snowball. It melted quickly and we had a relatively pretty day. (Perhaps to make up for the Seahawks' loss?) On Sunday morning, we had maybe half an inch. It all melted by noon. On the radio this morning they were suggesting more snow's possible Tuesday night. Feh.
(*On the default chart color -- you can edit the pallette in the spreadsheet by going into Tools -> Options -> Color, but it saves it on a per-spreadsheet basis. You can import from another open sheet; however, it would be nice to change this globally, once.)
Excel likes to automatically hyperlink anything that looks like an email or web site. You can remove them, but only on individual cells: right-click on the cell and select the "Remove Hyperlink" option. (In frustration, I've worked around this by doing copy and paste-special a couple of times.) PUP fixes this, and has other cool links like "exact copy of formula" and "search and replace in comments" and "change case." Ahhh... nerdvana.
In a redux of last year's snow prognostication, nearly all of the forecasters were hyping up the "two inches -- or more" of accumulated snow expected this weekend. As Friday approached, they were tempering this back to "an inch or two." Saturday morning we had a light dusting, not even enough to build a snowball. It melted quickly and we had a relatively pretty day. (Perhaps to make up for the Seahawks' loss?) On Sunday morning, we had maybe half an inch. It all melted by noon. On the radio this morning they were suggesting more snow's possible Tuesday night. Feh.
(*On the default chart color -- you can edit the pallette in the spreadsheet by going into Tools -> Options -> Color, but it saves it on a per-spreadsheet basis. You can import from another open sheet; however, it would be nice to change this globally, once.)
.