Sunday, January 23, 2011

Excel Quick Tip

If you've ever needed to copy information in an Excel spreadsheet (who hasn't, right?), then this Quick Tip will become one of your favorites.

Let's say you have information in Cell A5 that needs to be copied into Cell A6.

With the cursor in Cell A6, simply press "CTRL + D."

It's that simple!

Monday, January 10, 2011

How Green is Your Excel?

Have you seen the little green triangle in the upper left corner of a cell in Excel?

What is this green triangle?

It simply tells you that something is wrong with the formula in the cell.  It may not create an error message; but when you click on the green triangle, you'll see a yellow exclamation point.

Click on the drop down next to the yellow exclamation point and Excel will provide some possible answers.

If you have Excel 2007 or 2010, the yellow exclamation point provides you with a "trace error" function which helps follow the formula to find out where there may be a mistake.

Understand these "smart tags" like the green triangle and you'll be able to correct errors without a lot of frustration.

Friday, January 7, 2011

Outlook Quick Tip

Would you like more room on the Outlook Desktop?  If so, did you know you can turn the Navigation Pane On or Off, as needed?

Simply press "ALT + F1" to toggle the Navigation Pane On or Off.

Turn it "Off" when you need more space or turn it "On" when you need to see folders.

It's that simple!

How to Delete Blank Rows in Excel