How get rid of extraneous sheets?

K

kevs1

When I command N, the new workbook has 3 sheets at bottom. Anyone know how to get rid of two of them? thanks.
 
J

Jim Gordon MVP

When I command N, the new workbook has 3 sheets at bottom. Anyone know how to
get rid of two of them? thanks.
Click to expand...

Hi,

You are using Excel 2004 or earlier. This is explained in Excel's help
system. Here's what it says in Help:

default workbook template
The template (named Workbook) you create if you want to change the default
format of new workbooks. Microsoft Excel uses the template to create the new
workbook that opens each time you start Excel, click the New button on the
Standard toolbar, or select the Workbook template in the Project Gallery
dialog box (File menu). Unless you create the Workbook template, Microsoft
Excel bases new workbooks on built-in program settings. You must store the
Workbook template either in the Microsoft Office 2004/Office/Startup/Excel
folder or in the alternate startup folder.

-Jim

--
Jim Gordon
Mac MVP

MVPs are not Microsoft Employees
MVP info
 
K

kevs1

Thanks Jim:
Ok, I got the new workbooks to only have only one sheet, but now it's coming up in page layout which I hate. I have tried change it to normal view, but I can't seem to succed. It keeps opening up in page view.
 
K

kevs1

Now in the startup folder I used to have two files : workbook.xls and just workbook without the extension, now I only see workbook with the xls extension.

so now, the workbook that come up upon lauch is great, but the when choose new workbook, one comes up in page view which I don't like.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Section and Page numbering 0
All paragraphs now come in a box 0
Remove title bar and phase bar by default on swimlane 0
Making id cards 1
Small Thick "Bar" Below Last Typed Line ? 0
Turning off automatic calculation 0
How can the font and size of (all) citation numbers be altered? 1
Non Commercial Use 3

Top