4 Microsoft Excel Tricks That You Might Not Know

The Power of the Double Click
by Jessica Brown:
Over my time with New Horizons, I have taught many excel courses. While I teach Excel courses, I discover one tool that makes Excel work very well. However, very few people are aware of it. Double clicking is a powerful tool. It is a powerful strategy tool.

1. Your double click can be used to adjust your column widths.
Double-click your cursor to adjust the column size. Double clicking is a much more efficient way to adjust the column width than dragging.

2. You can also use this tool by using your auto-fill handle.
Your auto-fill handle can be found in the lower right corner of your cell. This is where you will find formulas and functions. You can copy by clicking and dragging the column down. Double-clicking the auto-fill handle will make your life much easier. This will cause the auto-fill handle to copy the column to your end.
This rule applies to Office 2010. You must have data at the left of the area you are filling out. This is necessary to ensure that your data knows where it ends.

Today’s Date: Dynamic or Static
Barbara Benneian
There are two methods to enter the date, other than manually. These will produce two different results. The spreadsheet will display the same dates. Clicking on the date and looking at the formula bar will reveal which date will be updated automatically and which one will not.
3. To enter today’s static day, hold down CTRL and type “semicolon”

4. To see the current date and have it updated every day, type =today( then press Enter.