14. Protection, Sharing and Printing
Friends, the report is ready and the dashboard is ready – now we have to give it to others. But what if someone deletes a formula by mistake? What if the table prints in halves across 12 pages? In this module we learn to protect the sheet and workbook, set up printing, export to PDF and work together on OneDrive (co-authoring). These are everyday office jobs – remember them.
मित्रांनो, report बनवला, dashboard बनवला – आता तो दुसऱ्यांना द्यायचाय. पण कोणी चुकून formula delete केला तर? Print केला आणि 12 पानांवर अर्धा-अर्धा table आला तर? या module मध्ये sheet आणि workbook protect करणं, print setup, PDF export, आणि OneDrive वर एकत्र काम (co-authoring) हे सगळं शिकूया. Office मध्ये रोज लागणारी ही कामं आहेत – लक्षात ठेवा.
दोस्तों, report बन गई, dashboard बन गया – अब इसे दूसरों को देना है. पर किसी ने ग़लती से formula delete कर दिया तो? Print किया और 12 पन्नों पर आधी-आधी table आई तो? इस module में sheet और workbook protect करना, print setup, PDF export, और OneDrive पर साथ में काम (co-authoring) यह सब सीखेंगे. Office में रोज़ लगने वाले ये काम हैं – याद रखिए.
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
Live story: The file goes to six managers
Suppose the finished report goes to all six city managers. The next day the Nagpur manager has typed over a formula, and the printout of the Pune sheet comes out on 12 pages with half a table on each. This chapter locks the formula cells, protects the sheet and workbook, sets the print area and print titles, and shares the file for co-authoring.
All numbers in this story are fictional practice data.
Live story: File सहा managers कडे जाते
समजा तयार झालेला report सहाही city managers कडे जातो. दुसऱ्या दिवशी Nagpur च्या manager नी एका formula वर type केलंय, आणि Pune sheet चा printout 12 पानांवर येतो, प्रत्येक पानावर अर्धा table. हा chapter formula cells lock करतो, sheet आणि workbook protect करतो, print area आणि print titles set करतो, आणि co-authoring साठी file share करतो.
या story मधले सगळे आकडे काल्पनिक practice data आहेत.
Live story: File छह managers को जाती है
मान लीजिए तैयार report छहों city managers को जाती है. अगले दिन Nagpur के manager ने एक formula पर type कर दिया है, और Pune sheet का printout 12 पन्नों पर आता है, हर पन्ने पर आधी table. यह chapter formula cells lock करता है, sheet और workbook protect करता है, print area और print titles set करता है, और co-authoring के लिए file share करता है.
इस story के सारे आँकड़े काल्पनिक practice data हैं.
Concepts in this chapter
- 14.1Locked Cells and Protect Sheet
- 14.2Hiding Formulas and Allow Edit Ranges
- 14.3Protect Workbook Structure vs Encrypt with Password
- 14.4Print Area and Page Breaks
- 14.5Page Setup: Orientation, Scaling and Margins
- 14.6Headers and Footers
- 14.7Print Titles (Repeat Header Rows)
- 14.8Exporting to PDF
- 14.9Sharing and Co-authoring
- 14.10Comments vs Notes
- 14.11Version History
The chapter recap is at the end of the last concept page.
Quick revision cards
Quick revision
Revise this chapter in two minutes. Save the cards on your phone or download them as PNG files. All names and numbers are made up for practice.
झटपट उजळणी
हा chapter दोन मिनिटांत revise करा. Cards phone वर save करा किंवा PNG म्हणून download करा. सगळी नावं आणि आकडे सरावासाठी काल्पनिक आहेत.
झटपट दोहराई
यह chapter दो मिनट में revise करें. Cards phone पर save करें या PNG के रूप में download करें. सभी नाम और आंकड़े अभ्यास के लिए काल्पनिक हैं.
More cards for every chapter: Ravi Sir's Cards.