Excel Printing Layout Issue
Closed
vanessa04
-
Patrice33740 Posted messages 8400 Registration date Status Membre Last intervention -
Patrice33740 Posted messages 8400 Registration date Status Membre Last intervention -
Hello,
I can't manage to print an Excel table correctly.
I've tried everything in the page layout: fit to one page, select the print area, insert/remove page breaks, etc., but the problem remains the same: this table, which should fit on 20 pages, is printing on over 80 pages, fragmented.
I can't manage to fit the 4 columns it contains in landscape format. The more I reduce the page layout to X% of the normal size, the more the table prints on an endless number of pages (Excel's latest suggestion: 2020 pages!!).
If I adjust to 400% of the normal size, the table reduces slightly. Conversely, if I adjust to 10%, then the table prints on hundreds of pages.
I've already printed this same table correctly. So I know it's possible, but I can't seem to perform the same operation anymore.
Can anyone help me?
P.S.: My version of Excel is Microsoft Excel 97-2003 (.xls)
Thanks a million in advance for your responses!
I can't manage to print an Excel table correctly.
I've tried everything in the page layout: fit to one page, select the print area, insert/remove page breaks, etc., but the problem remains the same: this table, which should fit on 20 pages, is printing on over 80 pages, fragmented.
I can't manage to fit the 4 columns it contains in landscape format. The more I reduce the page layout to X% of the normal size, the more the table prints on an endless number of pages (Excel's latest suggestion: 2020 pages!!).
If I adjust to 400% of the normal size, the table reduces slightly. Conversely, if I adjust to 10%, then the table prints on hundreds of pages.
I've already printed this same table correctly. So I know it's possible, but I can't seem to perform the same operation anymore.
Can anyone help me?
P.S.: My version of Excel is Microsoft Excel 97-2003 (.xls)
Thanks a million in advance for your responses!
4 réponses
Hello,
First, we need to make sure there is no other data lingering outside the table.
Click on the first empty column after your table.
Once the column is highlighted, press Ctrl + SHIFT (key above Ctrl + Right Arrow)
All columns outside the table are now highlighted.
Right-click on one of the column headers and select Delete
Then select the first empty row after your table.
Press Ctrl + SHIFT + Down Arrow
All rows above your table are selected.
Right-click and then Delete
Then go to print options and in the scaling section, set it back to 100%
Click below and put 1 in the first field and 100 in the second.
That should work.
First, we need to make sure there is no other data lingering outside the table.
Click on the first empty column after your table.
Once the column is highlighted, press Ctrl + SHIFT (key above Ctrl + Right Arrow)
All columns outside the table are now highlighted.
Right-click on one of the column headers and select Delete
Then select the first empty row after your table.
Press Ctrl + SHIFT + Down Arrow
All rows above your table are selected.
Right-click and then Delete
Then go to print options and in the scaling section, set it back to 100%
Click below and put 1 in the first field and 100 in the second.
That should work.
