open "normal view" as default and not workbook when opening

[harrisg]

How do you open "normal view" as default and not workbook

 

[JE McGimpsey]

How do you open "normal view" as default and not workbook

A little confusing here, since workbook is the collection of one or more
worksheets that make up a file, not a view.

However, one way:

In XL04, choose Preferenes/VIew and set the "Open new worksheets using
this view" dropdown to Normal.

in XL08, choose Preferences/View, and set the "Preferred view for new
sheets" dropdown to "Normal".

Better yet, create a *template* file with the view, number of sheets,
formatting, etc that you want, and save it *as a template* with the
name "Workbook" (no quotes, no extensions) in the

Applications:Microsoft Office 200x:Office:Startup:Excel

folder (or alternate startup folder if you've set one in
Preferences/General). From then on, blank workbooks will be copied from
*that* template.

 

[Phillip Jones]

I've noticed a change between Excel2008 and Excel2004, I like for the
better.

In 2004 if you opened a blank sheet you had at the bottom 5 or 6 extra
Tabs you clicked and switched to additional blank sheets.

In 2008 You open in one sheet and then there is one tab that has a Plus
sign you can add addition sheets needed.

I am glad they finally got rid of that infuriating method from Excel
95-2004 and done it right finally. I rarely use more than one sheet. nd
I am always having to delete those extra Tabs so I can set up my screen
correctly.

A little confusing here, since workbook is the collection of one or more
worksheets that make up a file, not a view.

However, one way:

In XL04, choose Preferenes/VIew and set the "Open new worksheets using
this view" dropdown to Normal.

in XL08, choose Preferences/View, and set the "Preferred view for new
sheets" dropdown to "Normal".

Better yet, create a *template* file with the view, number of sheets,
formatting, etc that you want, and save it *as a template* with the
name "Workbook" (no quotes, no extensions) in the

Applications:Microsoft Office 200x:Office:Startup:Excel

folder (or alternate startup folder if you've set one in
Preferences/General). From then on, blank workbooks will be copied from
*that* template.

--
------------------------------------------------------------------------
Phillip M. Jones, CET |LIFE MEMBER: VPEA ETA-I, NESDA, ISCET, Sterling
616 Liberty Street |Who's Who. PHONE:276-632-5045, FAX:276-632-0868
Martinsville Va 24112 |[email protected], ICQ11269732, AIM pjonescet
------------------------------------------------------------------------

If it's "fixed", don't "break it"!

mailto[email protected]

<http://www.kimbanet.com/~pjones/default.htm>
<http://www.kimbanet.com/~pjones/90th_Birthday/index.htm>
<http://www.kimbanet.com/~pjones/Fulcher/default.html>
<http://www.kimbanet.com/~pjones/Harris/default.htm>
<http://www.kimbanet.com/~pjones/Jones/default.htm>

<http://www.vpea.org>

 

[Jim Gordon MVP]

Hi Phillip,

Please take a moment to send that comment to Microsoft at this URL:
http://www.microsoft.com/mac/suggestions.mspx?product=excel

I bet this point they would like to read a positive comment about Excel
2008.

-Jim

I am glad they finally got rid of that infuriating method from Excel
95-2004 and done it right finally. I rarely use more than one sheet. nd
I am always having to delete those extra Tabs so I can set up my screen
correctly.

--
Jim Gordon
Mac MVP

MVPs are not Microsoft Employees
MVP info

 

[Mike Middleton]

Phillip Jones -

In 2004 if you opened a blank sheet you had at the bottom 5 or 6 extra
Tabs ... <

Excel Preferences | General | Sheets in new workbook ...

- Mike Middleton
http://www.DecisionToolworks.com
Decision Analysis Add-ins for Excel

 

[Phillip Jones]

I've used Excel since Excel95 (with the except of excel x)
And I was unaware that was even there.

Oh, well Spoiled MicroSoft's joy now by not being able to comment on the
new way. :-(

Phillip Jones -


Excel Preferences | General | Sheets in new workbook ...

- Mike Middleton
http://www.DecisionToolworks.com
Decision Analysis Add-ins for Excel

--
------------------------------------------------------------------------
Phillip M. Jones, CET |LIFE MEMBER: VPEA ETA-I, NESDA, ISCET, Sterling
616 Liberty Street |Who's Who. PHONE:276-632-5045, FAX:276-632-0868
Martinsville Va 24112 |[email protected], ICQ11269732, AIM pjonescet
------------------------------------------------------------------------

If it's "fixed", don't "break it"!

mailto[email protected]

<http://www.kimbanet.com/~pjones/default.htm>
<http://www.kimbanet.com/~pjones/90th_Birthday/index.htm>
<http://www.kimbanet.com/~pjones/Fulcher/default.html>
<http://www.kimbanet.com/~pjones/Harris/default.htm>
<http://www.kimbanet.com/~pjones/Jones/default.htm>

<http://www.vpea.org>