Solved

How come the format is changing?

Posted on 2011-03-23
7
181 Views
Last Modified: 2013-11-05
I converted one of my users to Office 2010 from 2003.  She opens a work book that is 10 pages, and you can see all of the data.  When she tried to print it only shows 1 page of data and the second page is blank minus the header and footer.  Any ideas as to why it would not let her print the whole document.  I did notice if I copy all cells onto sheet 2 all the data will print.
0
Comment
Question by:Bada_Bing
  • 4
  • 3
7 Comments
 
LVL 33

Expert Comment

by:jppinto
Comment Utility
Did you check the Print Area setting? On View tab click on the Page Break Preview to check if all of your data is inside the defined Print Area.
0
 
LVL 33

Accepted Solution

by:
jppinto earned 500 total points
Comment Utility
The Print Area button is on the Page Layout tab and you need to select the range of data that you want to print and then click on the Set Print Area.
0
 

Author Comment

by:Bada_Bing
Comment Utility
jppinto
I just went and checked and it was on Page Break Preview, shows as 10 Pages.  Click on Print it shows only 2 pages.  Click back to the Home tab and the whole workbook shows only 2 pages now.  Unless I close and reopen it.
0
Highfive + Dolby Voice = No More Audio Complaints!

Poor audio quality is one of the top reasons people don’t use video conferencing. Get the crispest, clearest audio powered by Dolby Voice in every meeting. Highfive and Dolby Voice deliver the best video conferencing and audio experience for every meeting and every room.

 

Author Comment

by:Bada_Bing
Comment Utility
Let me go try that
0
 
LVL 33

Expert Comment

by:jppinto
Comment Utility
Do you have only problems with this file? If so, can you try and check on another computer this file to see if the same happens there?

Also, this might be a problem with your default printer. Can you change to another printer and make a print preview to see if it's OK?

jppinto
0
 

Author Comment

by:Bada_Bing
Comment Utility
I think I have got it.  I had to go to the Page Layou tab and Clear Print Area.  Thank you for the ideas to get me in the right direction
0
 
LVL 33

Expert Comment

by:jppinto
Comment Utility
Glad I helped you find the way... :)
0

Featured Post

Highfive Gives IT Their Time Back

Highfive is so simple that setting up every meeting room takes just minutes and every employee will be able to start or join a call from any room with ease. Never be called into a meeting just to get it started again. This is how video conferencing should work!

Join & Write a Comment

Drop Down List with Unique/Distinct Values (enhancing the Combo-Box with a few steps and a little code) David miller (dlmille) Intro Have you ever created a data validation list from a database field or spreadsheet column (e.g., Zip Codes or Co…
This article descibes how to create a connection between Excel and SAP and how to move data from Excel to SAP or the other way around.
The viewer will learn how to simulate a series of coin tosses with the rand() function and learn how to make these “tosses” depend on a predetermined probability. Flipping Coins in Excel: Enter =RAND() into cell A2: Recalculate the random variable…
This Micro Tutorial will demonstrate how to use a scrolling table in Microsoft Excel using the INDEX function.

772 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

15 Experts available now in Live!

Get 1:1 Help Now