0
votes
1answer
1k views

How to print two different sheets with different scale options using Excel 2007 and Excel 2010?

I have two sheets in a .xlsx file. The first sheet uses columns A to C and fits into a single landscape orientation A4 size paper. The second sheet will fit into a single landscape orientation A4 ...
0
votes
1answer
525 views

Print multiple copies of “Print Selection” Excel 2007

I have a user who is trying to print only a certain set of cells in Excel 2007, but she needs to print 2 copies of the selection. Using the print dialog, she selects Selection under Print What and ...
0
votes
2answers
8k views

Is there a way to fit two pages on one page in MS Excel when printing?

I have a table in Excel. It is 2 pages long, but only half-page wide. Is there a way to print both parts of this table on one page, so one next to another? I don't want to move the data, I would like ...
1
vote
3answers
1k views

Hide cells when printing in Excel

I'm using Excel 2007. I have an estimate sheet, which I will use to keep track of client information. There is some low level information that the client shouldnt see on their version of the document. ...
4
votes
2answers
1k views

How to I preview prints in Excel 2007 when I have no printer at hand?

How can I preview my Excel document before printing, when there is no printer installed? Simply choosing "Microsoft XPS Writer" or "Fax" as a default printer doesn't do the trick, system balks with ...
2
votes
2answers
500 views

Printing a dynamic sheet as one document

I have a spreadsheet structured as follows: Summary section at the top Detail section on the bottom Summary section summarizes the detail section which is filtered using auto filters There are ten ...
0
votes
1answer
168 views

Is there a registry setting to force printing gridlines, column headers for Excel 2007 on Windows XP?

I think I already know the answer to this ("NO!") but I thought I would reach out and hope that someone can prove me wrong. I have a lot (tens of thousands) of Excel spreadsheets that I will be ...
1
vote
1answer
879 views

How to mark cell in Excel spreadsheet as non-page-breaking?

Is there any way to declare a cell/row in Excel as a cell/row that should not be used for page break. Example: A1: 1. My content title in bold A2: Empty row A3: More and more content, description, ...
1
vote
3answers
1k views

De-select worksheets after printing in Excel

I have setup a excel worksheet that uses multiple sheets for calculations that don't need to be printed. My entire workbook has 8 sheets and I normally only print the first 4. The workbook may be ...