Forum Discussion
Specific computer prints a one page Excel template in two pages.
Greetings, I can tell you simple trick to do this for your computer.
Just go to Page Layout Menu and under Scale to Fit Section, Set the Width to 1 Page and Height to 1 Page. Then It will be printed on one page.
But Still something goes miss in that Print Area. Then Go To Name Manager Under Formulas Menu and then Find the Name "Print Area" and There could be multiple Print Areas. So you need to see Scope showing for respective Print Area. Scope is basically a tab name of your workbook. So suppose if you want to Print "A" Tab and your print data range is A1:D50. So just update that range for that Print Area in Name Manager. So this will be the Print Area which is going to be printed on One page as you have set the Height to 1 Page in last Step
Hope it works for you
Regards
Kapil Juneja
Greetings, I can tell you simple trick to do this for your computer.
Just go to Page Layout Menu and under Scale to Fit Section, Set the Width to 1 Page and Height to 1 Page. Then It will be printed on one page.
But Still something goes miss in that Print Area. Then Go To Name Manager Under Formulas Menu and then Find the Name "Print Area" and There could be multiple Print Areas. So you need to see Scope showing for respective Print Area. Scope is basically a tab name of your workbook. So suppose if you want to Print "A" Tab and your print data range is A1:D50. So just update that range for that Print Area in Name Manager. So this will be the Print Area which is going to be printed on One page as you have set the Height to 1 Page in last Step
Hope it works for you
Regards
Kapil Juneja
jukapil Thank you for the suggestion. I checked the name manager and the print areas seems to be set up correctly. The template by default had not scaling on it but I changed the template and that seem to fix the problem. My desire is not to have the user have to change that setting all the time so I will change all the templates we have. Still not really sure why there was an error but at least this will fix it. Thank you for your help.
Jorge