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 |
About this data: Teaching sample for a fictional shop “CityBasket Retail”. Figures and names (e.g. Priya Deshmukh) are made up for this lesson on page setup orientation scaling and margins.
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 अगले पेजों पर.
Worked example — page setup orientation scaling and margins
Why
Vikram Rao in Pune and Yuki Tanaka abroad both need a clear, repeatable way to use page setup orientation scaling and margins on a Pearl Textiles sheet without breaking totals.
What
Page Setup Orientation Scaling And Margins is the Excel idea this page teaches. We will walk one tiny example end to end.
How
- Open a blank sheet. In A1 type a short label for page setup orientation scaling and margins.
- Enter a small made-up value for Vikram Rao using $ where money appears.
- Add a second value for Yuki Tanaka using £ so you see mixed currencies stay numeric.
- Apply the method from this lesson step by step (menu or formula as shown above).
- Check the result still works inside SUM or a simple check cell.
Formula / action
Follow the formula or ribbon steps shown in this lesson (keep values numeric).Meaning: Once page setup orientation scaling and margins is correct on one row, copy the same pattern down the column.
Practice tasks (10+)
Try these on a blank sheet. Open a hint only if you are stuck. No quiz — just practice.
1. Rebuild the smallest example of page setup orientation scaling and margins on a blank sheet for NovaCraft Tools.
Hint: Use only the steps on this page. Keep numbers numeric.
2. Change one input for Aarti Kulkarni and confirm the result updates.
Hint: If the result is stuck, check absolute vs relative references.
3. Repeat the same steps with a £ or € value for Sophie Martin.
Hint: Formatting must not break SUM.
4. Write the result meaning in one plain sentence next to the cell.
Hint: Imagine explaining it to a new joiners.
5. Add a second row and fill the method down.
Hint: Double-click the fill handle if the pattern is consistent.
6. Break the example on purpose, then fix it using this lesson.
Hint: Common break: text instead of a number.
7. Apply page setup orientation scaling and margins to a 5-row made-up NovaCraft Tools table.
Hint: Keep column headers clear.
8. Check your answer with a simple total or COUNT.
Hint: A wrong total usually means a format or key mismatch.
9. Swap ₹ and $ on one column and re-check totals.
Hint: Stored values stay the same; only the display changes.
10. List two mistakes beginners make with page setup orientation scaling and margins.
Hint: Look back at the tip box on this page.
11. Teach the steps out loud in under one minute.
Hint: Why → What → How.
12. Save the sheet as NovaCraftTo_practice.xlsx.
Hint: Use a clear file name for class.
Loading practice tasks...
- Input cells to unlock (Easy): How many cells are in the Monthly target column?
- Total target (Easy): Add up the Monthly target column.
- Total actual (Easy): Add up the Actual column.
- Highest target (Easy): What is the largest value in the Monthly target column?
- Overall achievement (Medium): Divide the total Actual by the total Monthly target. Round to 3 decimals.
- Cities below target (Medium): How many cities have a Gap below 0?
- Manager for a city (Medium): Find the Manager for City "Toronto".
- Pages to print (Medium): If one page holds 4 data rows, how many pages do the rows need?
- Gap for the first city (Medium): For the first row, find Actual minus Monthly target.
- Best performer (Hard): Which City has the largest Actual?
- Status for the first city (Hard): For the first row, return "Hit" if Actual is at least Monthly target, else "Miss".
- Total shortfall (Hard): Add up the Gap column only where it is below 0, and show it as a positive number.
Quick revision cards
Three standalone cards. Each one explains the idea with its own example. Scan the QR to open this lesson.
