Microsoft Excel 2007 tutorial: specify a number of worksheets to display


Specify a number of worksheets to display

VII. Specify a number of worksheets to display

In general, when you open Microsoft Office Excel 2007, you always see three sheets in the Excel window. The three sheets in the Excel window is default. However, you can specify a number of worksheets as you want when Microsoft Office Excel 2007 is run by following the procedure below:

- Click Office Button

- Click Excel Options

Excel 2007 Excel Options button

Microsoft Office Excel 2007 displays Excel Options dialog box as the figure:

Excel Options dialog box

- Under When creating new workbooks, enter a number of sheets or use spin up and down arrow to increase or decrease a number of sheets that you want to specify to display, in front of Include this many sheets box.

- Click Ok

You have another way to specify a number of sheets as you want when Microsoft Office Excel 2007 is opened by doing the following:

- Right-click Office Button or anywhere on the Ribbon

- Click Customize Quick Access Toolbar

Excel 2007 Customize Quick Access Toolbar

Microsoft Office Excel 2007 displays Excel Options dialog box that you already saw as the figure above.

- Click Popular

- Under When creating new workbooks, enter a number of sheets or use spin up and down arrow to increase or decrease a number of sheets that you want to specify to display, in front of Include this many sheets box.

- Click Ok

 


Comments





This website intents to provide free and high quality tutorials, examples, exercises and solutions, questions and answers of programming and scripting languages:
C, C++, C#, Java, VB.NET, Python, VBA,PHP & Mysql, SQL, JSP, ASP.NET,HTML, CSS, JQuery, JavaScript and other applications such as MS Excel, MS Access, and MS Word. However, we don't guarantee all things of the web are accurate. If you find any error, please report it then we will take actions to correct it as soon as possible.