Changing the default number of worksheets

By default, a workbook has three worksheets.
We can customize the number of worksheets.

Click the “Office” button and choose “Excel Options” at the bottom.

On the right side of the dialog box select the “Popular” tab.
Enter the number of sheets you want to open, in the field  “Include this many sheets”, and click OK.

Whenever you create a new workbook, it will open with the number of worksheets that you have entered here.

Changing the direction after clicking the Enter key

In Excel we also have the possibility to adjust the direction of the cursor when we click the Enter key.
Default it is set to Down, but we can change this to right.
To change this, click the “Office” button, and select the “Advanced” tab.
Click the downward pointing arrow next to the “Direction” box in “After pressing enter, move selection” and make your choice.
Click OK.

When you deselect the field  “After pressing Enter move selection”, the cursor will remain in place after clicking “Enter”.

Featured Courses

• Downloading iPad Apps
• Lesson 1: Introduction to Publisher
• Lesson 65: File Formats