Excel Print Preview

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

In older versions of Excel, after going to the Print Preview screen and then returning to the main page, there is a line that shows up to tell how many columns will fit onto one page. From this I could adjust the column witdths to fit the data on the page that I wanted. In Excel 2003, I go to the Print Preview page, and then return to the main page and no line shows up. How do I make that very useful line appear?
 
I don't use xl2003, but there's an option under:
tools|options|view tab|Page Breaks

You may want to try View|Page Break Preview. Sometimes that's easier to see.

Just toggle it back to normal when you're done.
 
You must log in or register to reply here.

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

Excel VBA - Problem with Closing Print Preview 0
dashed line after print preview 4
scale to page error in Excel 2007 3
Page Break Preview 4
How to remove dashed page lines after using print preview 1
How to match data in worksheet same as in Print Preview? 4
Images/objects moving when printing or print preview. 1
setting the area to show up in preview 3

Back
Top