Do you have content in cells that are not adjacent? Skip to the next cell with content by holding the Ctrl button and the right arrow. The same can be done using the other arrows, depending on direction.

Save time typing by using auto-fill for any type of range. The common example uses months, but this can be done with numbers as well.

Tired of changing the font each time you use Excel? Change it in the Options menu.

Resize all columns or all rows by clicking the top right Select All button. When all cells have been highlighted, select a column or row line and slide to the appropriate size. This will change the size for all columns or all rows.

Then click and hold a line on the column heading or row heading to adjust the size for all cells within that group. Arrow slider shown adjusting column C below. Adjusted columns also show below.

Easily copy formulas with a Copy and then a Paste. But what about copying only the value of a specific cell and not the formula? Copy a cell (by using Ctrl+C, the copy icon from the Clipboard area [image 1 below], or right click and select copy). Then use one of three options to paste the value instead of the formula from the first cell.

Option one - use the Paste dropdown menu from the Clipboard area to choose the Paste Value option [image 2 below].

Option two - right click in the field you want to paste into and select the Paste Special option [image 3 below].

Or, Option three - copy directly into the new field with Ctrl+V but then select the Paste Options icon that is displayed below the cell [image 4 below].

Trying to print your workbook and it is coming out with the wrong orientation or printing cells you do not care about? Use the Print Area option under Page Layout. You may still need to change your Portrait Orientation in the Print settings when attempting to print.

This line (shown in the circle below) shows what will be printed. The left of the line will show up on the first page. To the right will kick it onto a second (or third, or fourth) page depending on the number of columns.

Use the Page Layout option under the View Tab to see how your workbook will print.

Do you have titles that need to stay at the top when you scroll through your sheet? Use the Freeze Panes tool under the View Tab.

Excel Tutorial Site - Including Screenshots and Videos