Jump to content

Change default worksheet options


Recommended Posts

Change default worksheet options

By default, Excel includes three worksheets in a new workbook. But if most of your users rarely use more than one worksheet per workbook, you can prevent Excel from generating the two extra worksheets.

Follow these steps:

1. Go to Tools | Options.

2. On the General tab, set the value in the Sheets In New Workbook box to 1, and click OK.

The next time you create a new workbook, it will have only one worksheet. You can also increase the number of sheets per workbook.

You can also use the Options dialog box to change the worksheet's default font. For example, to change the default font from Arial 10 to Times New Roman 12, follow these steps:

1. On the General tab, select Times New Roman from the Standard Font drop-down list.

2. Select 12 from the Size drop-down list, and click OK.

You must restart Excel for your font changes to take effect.

Link to comment
Share on other sites

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.

Reply to this topic...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.


  • Create New...