Use the OFFSET Function for a Running Balance

If you have a spreadsheet that uses a running balance, the OFFSET function is a great way to allow you to easily insert and delete rows, without messing up the balance.

Adding AutoCorrect Exceptions

There is one AutoCorrect option that I like to always turn OFF in Excel: It is the "Correct TWo INitial CApitals" option.

Dynamic Print Area in Excel

I was creating a new version of my amortization schedule spreadsheet today and wanted to set the print area so that it didn't print a bunch of blank pages. If a person chooses a 15-year loan with monthly payments, I wanted the print area to show only those payments - not the entire table.

Keyboard Shortcuts to Insert Special Symbols in Excel

The copyright ©, trademark ™, and registered trademark ®, symbols can be inserted quickly in Office applications using the Autocorrect feature. Typing (c), (tm), or (r) will accomplish this. The other way to enter special symbols in Excel is by going to Insert > Symbol.

Copying/Pasting Excel Charts Into Other Programs

One of the valuable "hidden" tricks in Excel is how to copy a chart as an image so that when pasting into another program, it will paste as an image rather than an Excel object (which generally saves the entire workbook along with the chart). Here's the trick: