Do you have an MS Excel formula in a single cell that needs to be converted to its value?
No problem! Simply select the cell, press and release F2 and then press F9.
The cell contains the value of the formula and not the formula itself.
Unfortunately, you'll find that this little trick doesn't work for multiple cells. So, what now?
Tackling this one isn't as difficult as you might think. That is, if you dip into the Paste button tip from Friday.
First, select the cells you need to convert from formulas to values.
Now, copy the cells.
Without moving your cell selection, go to the Paste button, click on the down arrow and choose Values (Paste Values in Excel 2007) from the list.
Do you have a favorite design theme in MS PowerPoint 2007?
Perhaps you even have a couple of favorites. Even so, are you starting to feel like they've been overused?
Looking for an easy way to give them a quick "face lift" without losing all the cool elements and formatting that made you love them in the first place?
No problem! I recently stumbled across something that will help you do just that.
On the Design Ribbon, to the right of the Themes, you'll find a button labeled Background Styles.
There you have it. A quick change to freshen up your favorite themes may be all you really need