16. Practice Exercises with Answer Hints
16.13 Module 14: Protection and Printing
- Let users type only in target cells; protect everything else. Hint: unlock input cells (Ctrl + 1 › Protection) › Review › Protect Sheet.
- Stop users from deleting or unhiding sheets. Hint: Review › Protect › Protect Workbook › Structure.
- Print a 15-column sheet on A4 landscape, one page wide, with the header row on every page.
Hint: Scale to Fit Width 1 page; Page Layout › Print Titles ›
$1:$1. - Add "Page X of Y" in the footer.
Hint: Insert › Header & Footer ›
Page &[Page] of &[Pages]. - Export the Dashboard and Summary sheets to one PDF. Hint: select both tabs › File › Export › PDF › Options › Active sheet(s).
- Difference between a note and a threaded comment? Hint: notes = static sticky note; comments = replies, @mentions, resolve.
Ravindra Bagale's Tip
Khup students print preview na bagta print kartat. Ctrl + P madhe right side cha preview aani page count nehmi tapasa – kagad aani vel doghanchi bachat. Aani Protect Sheet la security samju naka.