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

Shop online 24hrs a day or call us Mon-Fri
8:30AM-4:30PM EST - 1-800-915-2088
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
 
Loading...


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 Options.



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 on.

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

~ April

Tags: ,

Comments are closed.

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:

Subscribe

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.


Subscribe


Love Worldstart? Refer A Friend!

WorldStart's Premium Membership

Tip Archive


Categories:
Archives: