MrExcel Publishing
Your One Stop for Excel Tips & Solutions

How do you shrink worksheet to fit paper printout?

Posted by Julie on October 07, 2001 4:13 AM

I am having major problems trying to figuire out how to shrink size of worksheet so it will print out on normal paper. Will you please help

Posted by JULIE on October 07, 2001 4:18 AM

Posted by J on October 07, 2001 5:33 AM

Shrinking ??? Be Careful

First question, if you shrink the sheet, rem you will make the letter small/hard to read! Try this File | Print Preview |from the top your see setup click that and change scaling (click radio button fit to and choose the re size ie default is 1 by 1

That will do it, but could be to small, play arround, on close will show the new results befor you click print to printer.