Daniel has attended:
Excel Intermediate course
Word Intermediate course
Excel print area
Hello,
I need to print out a document whereby I keep all the column titles but I want the rest of the document to be printed out over several pages. At the moment, it is only printing over two pages and the data is really small and hard to read. Is there a way I can change the printing area somehow?
Thanks
RE: Excel print area
Hi Daniel
Sounds like your worksheet has been set to a small % scaling. It's hard to tell without seeing your document. But could you try the following and see how it prints.
Step 1 - Select FLE, Print
Step 2 - Choose the No Scaling option at the bottom
Step 3 - Press Esc key then the PAGE LAYOUT tab
Step 4 - Select Print Titles
Step 5 - Click inside the box called Rows to Repeat at Top and highlight row 1 (or the row with your column titles)
Step 6 - click the Print Preview button
If all the columns don't print on the first page you could try reducing some of the column widths rather than scaling to fit one page wide.
Another option is to print Landscape rather than Portrait?
Let me know how you get on :)
Regards
Doug
Best STL
RE: Excel print area
Hi Doug,
Thanks for getting back to me.
So I have inserted the 1st row into the "print titles' option so it prints out all rows with the column titles on each page. I have also selected the options whereby it allows me to fit all columns in one page and i'm in landscape mode too. So at the moment, all the columns fit on each page, however I suppose my question is if there is an scaling option that allows me to fit all the columns on each page but not have so many rows condensed into each page without having to increase the row height?
Thanks,
Dan
RE: Excel print area
Hi Dan
The scaling option allows you to decrease the number of pages but not increase it. I think the only way is, as you say, to increase the row height of all the rows.
Also to change the font size for the row data (not the column titles) to make it more readable.
Sorry Excel is not more helpful!
Regards
Doug
