14. Protection, Sharing and Printing
14.5 Page Setup: Orientation, Scaling and Margins
Steps in Excel
- Page Layout › Page Setup › Orientation › Landscape for wide tables.
- Page Layout › Page Setup › Size › A4 (Indian offices normally use A4, not Letter).
- Page Layout › Scale to Fit › Width: 1 page, Height: Automatic – all columns fit one page width; rows flow to more pages.
- Margins › Narrow or Custom Margins… › tick Center on page: Horizontally.
- Page Layout › Sheet Options › Gridlines: tick Print if you want lines on paper (or add borders instead).
- Check with File › Print (Ctrl + P) – the preview on the right.
Worked example – Orders extract with 15 columns.
| Setting | Value |
|---|---|
| Orientation | Landscape |
| Paper | A4 |
| Scale to Fit | Width 1 page, Height Automatic |
| Margins | Narrow, centred horizontally |
Ravindra Bagale's Tip
Many students use "Fit Sheet on One Page" and squeeze a big table onto one page – then the letters become so small they can't be read. Use the combination Width = 1 page and Height = Automatic: the columns fit on one page, and the rows continue onto the next pages.
Ravindra Bagale's Tip – मराठी
बरेच students "Fit Sheet on One Page" वापरतात आणि मोठ्या table ला एकाच पानावर बसवतात – मग अक्षरं इतकी लहान होतात की वाचताच येत नाहीत. Width = 1 page आणि Height = Automatic हे combination वापरा: columns एकाच पानावर, rows पुढच्या पानांवर.
Ravindra Bagale's Tip – हिंदी
बहुत से students "Fit Sheet on One Page" इस्तेमाल करके बड़ी table को एक ही पन्ने पर ठूँस देते हैं – फिर अक्षर इतने छोटे हो जाते हैं कि पढ़े ही नहीं जाते. Width = 1 page और Height = Automatic वाला combination इस्तेमाल करो: columns एक पन्ने पर, rows अगले पन्नों पर.
Practice task
Set up your Orders sheet to print landscape on A4, one page wide, narrow margins, centred horizontally, and check the page count in Print Preview.