How to set print area in Excel to one page

How to set print area in Excel to one page ?
To print your worksheet on just one page, select the cells that you want to define as the print area. You can create multiple print areas by holding down CTRL and clicking the areas that you want to print. On the Page Layout tab, in the Page Setup group, click Print Area, and then click Set Print Area.

Enjoy this video ? Subscribe for more useful tutorials!
Make sure to Like, Favorite and Share this video and Subscribe if you haven't do so already at

Watch More:

If you face any problem or know any other method to set print area in MIcrosoft Excel to one page, feel free to comment or contact us. If you like this video, share it with your friends.
Do you find this tutorial a little outdated?
Please let me know :)

Your feedback is valuable to us, so don't be afraid to leave comments. Have fun and enjoy!

Follow me :

Video Link :

[FrogsDad]

Would have been nice to hear you talk and say what you were doing

[fhaque]

suppose Heroine 150 g, Fencidil 15 bottles, Home made wine 20 Litres in B1 cell. Heroine 200g, Home made wine 30 Litres, Fencidil 20 bottles in B2 cell. Fencidil 30 bottles, Heroine 300 g and Home made wine 50 Litres in B3 cell in excel. How to sum these text and number in accordance with category in B4 cell in excel ? (Result Heroine 650 g, Fencidil 65 bottles, Home made wine 100 Litres ) But How shall I do the sum with excel formula including text and number ?

[allinformationmadhan]

Totally waste of time ..no zoom you select options unable to view..

[muthuvel]

Margins do not fit page size nu varuthu g ithukku Enna pannanum pls sollunga g

[Aamir_shadan]

Thank you for such a nice tutorial, Great Job !

[michelenelson]

A step by step narrative would have been much better than this too fast tutorial with annoying music