Sunday, December 30, 2007

Converting Formulas to Values in Excel

Ever need to convert cells containing a formula to its value?

Sure, you can select the cell, copy it to the clipboard, paste it back to the same cell, click the Paste Options button, click Paste Special, and then click Values. The cell contains the value instead of the formula.

There is a better way. Simply select the cell to be converted, press F2, and then F9.

Saturday, December 08, 2007

IE7 and the Scroll Wheel

I just discovered a neat feature in IE7. Click a link with the scroll wheel instead of the left or right mouse button and the page opens in a new tab. Use with links off a Web page, the Links bar in IE7, and the Favorites links. This saves a number of clicks. To close the tab, click the tab with the scroll mouse.

Monday, December 03, 2007

Remove the Hyperlink

How many times have you copy and pasted from a Web page into a Word document and been frustrated with all the links that carried over? Sure, you can pull down the Paste Option button’s arrow and select Keep Text Only, but this removes all the formatting as well. You may want to keep the fonts and colors, but just not the links.

One at a time, you might right-click each link and select Remove Hyperlink. A longer method is to click Insert > Links > Hyperlink, and then on the Insert Hyperlink dialog box, click Remove Hyperlink.

There is a better way.

Click the hyperlinked word(s) and press Shift+Ctrl+F9. The hyperlink is removed. To do all at once, Ctrl+A to select the entire document, then Shift+Ctrl+F9 and all hyperlinks in the document are removed.