Tech Tips Home
The Best Tech Tips And Daily Deals
Newsletter On The Internet!

WorldStart Tech Tip And Store Search
Email: Password: Login Remember Me

Like what you see here? Subscribe to the Tech Tips newsletter!   Email: Subscribe

Resetting the Default View in Excel

Tuesday, January 18th, 2011 by | Filed Under: MS Excel, MS Office Help

MS Excel 2007 & 2010: How Do You Like to View It?

We all have one… you
know, that preferred view of our MS Excel worksheets.

Some people like to see
everything in the Normal view.

Others prefer the Page
Layout view,
where Excel shows the physical breaks between each page, as well
as the header & footer areas.

And still others prefer
the Page Break Preview look of things. (Which I have to admit, on
a new workbook, feels weird to me. Also, since it is a preview, it’s tiny, but to each
his own.)

Whatever your preference,
wouldn’t it be nice if Excel just put a new worksheet into that view instead
of your usual migration to the View tab of the Ribbon to make a change?

I’m quite sure that the
answer is yes so let’s take a look at where you can make that change.

We need to open the Options
dialog box
via the Office Button / File tab of the Ribbon.

Once there click Excel

In the Popular options
category, When creating new workbooks section you’re looking
for the option labeled as Default view for new sheets.

This option comes with a
drop-down list of choices – pick one.

Once you’re satisfied with
the decision, click OK.

That’s it… you probably
noticed that the setting works for new workbooks, but I found that once I changed
and saved my old files in the View of my choice, it opened that way later

As for the new files – you’ll
have the look you want right from the start.

~ April

Tags: ,

Leave a Reply

Like these tips? Get them for FREE in your email!

WorldStart's Tech Tips Newsletter

  • Tech Tips Daily - Become a tech pro! Get the very best tech and computer help sent directly to your email every weekday!

  • Tech Tips Weekly - If you don't want our Tech Tips newsletter every day, then sign up for this weekly newsletter to get the best information of the week. Sent on Fridays.

Other Newsletters

  • WorldStart's Daily Deals - Every week, we send out great deals in our Daily Deals newsletter. Many of these deals are exclusively for our Daily Deals newsletter subscribers and can't be found with our regular specials.

  • Just For Grins - Each issue includes a couple clean jokes, some funny quotes, and a hilarious reader's story. Newsletter is sent five days a week.

Enter Email Address:


Your e-mail address is safe with us!
We only use it to send you the newsletters you request. It is NEVER disclosed to a third party for any reason, ever! Plus, if you decided you don't like our newsletters (don't worry, you'll love them), unsubscribing is fast and easy.

Free Newsletter Signup

Tech Tips Daily

Become a tech pro! Get the very best tech and computer help sent directly to your email every weekday!

Tech Tips Weekly

The week's best in tech and computer help. Get your issue sent to your email every Friday!

WorldStart's Daily Deals

The very best deals on the Internet! Get a new set of incredible sales every day of the week!

Just For Grins

Clean jokes, funny quotes, and hilarious comics. Sent 5 times a week straight to your email.


Love Worldstart? Refer A Friend!

WorldStart's Premium Membership

Tip Archive