I have a spreadsheet with a lot of fields on it, and pretty difficult to print it out on one page. I can do it on the legal size of paper, but the readability is the question, very small letters, and just difficult to read it. On the Screen I can scroll Left-Right, Up-Down, I want to leave the spreadsheet on one sheet. My question is it possible to program with some commands, that I can print out the contains of the sheet on more sheet, arranging it
through ranges. So I will define areas of the sheet, like:
range1=A1:AQ31
range2=A36:BA66
range3=AS1:BA36
and probably for each I have to define page orientation, scale etc…(I don't want to set the page for each range every time I want to print out the report.)
Can I do this print commands through some Icons, so I just need to click on the icon 1,2, or 3 and it will print out the chosen area of the sheet?
through ranges. So I will define areas of the sheet, like:
range1=A1:AQ31
range2=A36:BA66
range3=AS1:BA36
and probably for each I have to define page orientation, scale etc…(I don't want to set the page for each range every time I want to print out the report.)
Can I do this print commands through some Icons, so I just need to click on the icon 1,2, or 3 and it will print out the chosen area of the sheet?