Ravindra BagaleCourses & study guides

14. Protection, Sharing and Printing

By Last updated:

Mitrano, report banavla, dashboard banavla – aata to dusryanna dyaycha aahe. Pan konitari chukun formula delete kela tar? Print kela tar 12 pana var ardha-ardha table aala tar? Ya module madhe sheet aani workbook protect karna, print setup, PDF export, aani OneDrive var ekatra kaam (co-authoring) he sagla shikuya. Office madhe roj lagnari hi kaam aahet – lakshat theva.

What you will learn in this module

  • Locked cells, Protect Sheet, hiding formulas and Allow Edit Ranges
  • Protect Workbook structure vs encrypting a file with a password (and why passwords need care)
  • Print area, page breaks, page setup, headers/footers and print titles
  • Exporting to PDF
  • Sharing and co-authoring through OneDrive/SharePoint, comments vs notes, and version history

Concepts in this chapter

  1. 14.1Locked Cells and Protect Sheet
  2. 14.2Hiding Formulas and Allow Edit Ranges
  3. 14.3Protect Workbook Structure vs Encrypt with Password
  4. 14.4Print Area and Page Breaks
  5. 14.5Page Setup: Orientation, Scaling and Margins
  6. 14.6Headers and Footers
  7. 14.7Print Titles (Repeat Header Rows)
  8. 14.8Exporting to PDF
  9. 14.9Sharing and Co-authoring
  10. 14.10Comments vs Notes
  11. 14.11Version History

The chapter recap is at the end of the last concept page.