Digital Streets

Change The Function of the Enter Key

Normally, when you press the Enter key, Excel goes to the next cell down. The Enter key can be made to move to in any direction (up, down, left, right) or leave you in the same cell. To change this, go to Tools | Options and select the Edit tab. Change the value in the dropdown for Move selection after Enter direction setting or uncheck the box to remain in the same cell.

Change The Number of Worksheets That Excel Starts With

Excel, by default, creates new spreadsheets with three sheets. To change this number go to Tools | Options and select the General tab. Set the number for Sheets in New Workbook.

Other Tips:

How To Bypass Table Recalculation

How To Hide Formulas from Other Users

How To Copy Excel Column Widths

Copy Formatting from One Cell or Range to Another

How To Copy Formatting From One Chart To Another

How To Email an Excel Workbook

Calculating Elapsed Time

How To Reference Cells in Other Worksheets