How to add the default numbers of worksheet in a Excel file.

By alexleeyy

Rate: (0 Ratings)

Default situation, inside an Excel file contains three worksheets were Sheet1, Seet2 and Sheet3, but some senior users or users with special needs, often have more higher requirements for more worksheets.

Instructions

Difficulty: Moderately Easy

Things You’ll Need:

Step1
By clicking "Insert / worksheet" on menu you can add worksheets.
Step2
or work in the table at the bottom right-click the mouse pop-up menu to choose, can be inserted into a new form of work.
Step3
but only to meet the needs of a small, only one operation to establish a working table, in a document on the need for the work table 10, you can click "Tools / Options" and select "General" tab and then change "sheets in new workbook" to the numbers you want.

Tips & Warnings

  • (1) Remember to change to the default value, or the next new every Excel document will contain a number of worksheets you just changed; (2) Each Excel document may include the work of a few tables there is a limit for 255.

Post a Comment

POST A COMMENT

Request a New How-To Article

Looking for more How To information? Chances are there’s an eHow member who knows how to do what you’re looking to do. Submit an article request now!

eHow Article:  How to add the default numbers of worksheet in a Excel file.

eHow Member: alexleeyy

alexleeyy

Enthusiast Enthusiast | 1340 Points

Category: Computers

Articles: See my other articles

Related Ads