14. Protection, Sharing and Printing
14.4 Print Area and Page Breaks
Steps in Excel
- Select the range to print (for example the City summary
A1:F40) › Page Layout › Page Setup › Print Area › Set Print Area. - To add another range: select it › Print Area › Add to Print Area (each area prints on its own page).
- View › Workbook Views › Page Break Preview – blue lines show page breaks; drag them to change pages.
- Insert a manual break: select the row below where the new page should start › Page Layout › Page Setup › Breaks › Insert Page Break.
- Breaks › Reset All Page Breaks removes manual breaks; Print Area › Clear Print Area removes the print area.
Worked example. A 90-row city-wise orders list: set a print area A1:H90, insert a manual page break above the first row of each new city (Pune starts row 2, Nagpur row 32, Nashik row 50…) so every city manager gets their own page.
Ravindra Bagale's Tip
Many students press Ctrl + P and print directly, and then 15 pages come out – half of them blank or with a single column. Before printing, always check in Page Break Preview and set the Print Area. Save paper, and the manager is happy too!
Ravindra Bagale's Tip – मराठी
बरेच students Ctrl + P दाबून थेट print करतात आणि मग 15 पानं छापतात – त्यात अर्धी रिकामी किंवा एकाच column ची. Print करण्यापूर्वी नेहमी Page Break Preview मध्ये बघून Print Area set करा. कागद वाचवा आणि manager पण खूश!
Ravindra Bagale's Tip – हिंदी
बहुत से students Ctrl + P दबाकर सीधे print कर देते हैं और फिर 15 पन्ने छपते हैं – उनमें आधे खाली या सिर्फ़ एक column वाले. Print करने से पहले हमेशा Page Break Preview में देखकर Print Area set करो. काग़ज़ बचाओ और manager भी ख़ुश!
Practice task
Set a print area on your city summary, open Page Break Preview, and insert manual page breaks so that each of the six cities starts on a new page.