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

Seeing the Unseen in Excel

Friday, December 7th, 2007 by | Filed Under: MS Excel, MS Office Help

Seeing the Unseen

Ever find yourself frustrated with MS Excel as you create a worksheet that you’re specifically trying to keep to one page wide?

Are you constantly flipping back and forth from the worksheet to the print preview so that you can “keep an eye” on things and make sure you’re not designing something that exceeds your intended print size?

I know some of you have a back up plan, right? You figure you can always use the Page Setup window to force the worksheet to be one page wide, but have you ever noticed how much it shrinks the data to make it fit?

Wouldn’t it be nice to get Excel to show you the page breaks while you’re working so that you could plan accordingly?

Yeah, I agree with you on that one!

Just show me the breaks so that I know what kind of space I have to work with.

Fortunately, help is just a few clicks away!

Give this a try and see if it helps with your situation.

In Excel 2007, you need the Office button and then the Excel Options button in the bottom right corner.

Now, we need the Advanced options button and then scroll down to the “Display options for this worksheet” section.

You can use the drop down list in the blue section title bar to select where you want to apply this setting.

Then just checkmark the “Show page breaks” option and click OK.

In older versions of MS Excel, you’ll need to go to the Tools menu, Options choice.

We’re looking for the View tab.

Under the Window options section, check the “Page breaks” choice.

Click OK.


You’ve got horizontal and vertical dotted lines throughout your worksheet, showing you exactly where Excel intends to insert the page breaks.

What could be better than removing some of the guesswork from your day?!

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