14. Protection, Sharing and Printing
14.11 Version History
Steps in Excel
- The file must be on OneDrive/SharePoint (AutoSave On).
- File › Info › Version History (or click the file name at the top › Version History).
- The pane lists saved versions with time and author. Click a version – it opens read-only in a separate window.
- Restore to make it the current version, or copy the needed cells into the current file.
- For local files without OneDrive: File › Info › Manage Workbook › Recover Unsaved Workbooks (depends on AutoRecover settings – may vary by version).
- Review › Changes › Show Changes (Microsoft 365) shows who changed which cell recently.
Worked example. At 4:15 PM IST someone deleted the Nashik rows in Daily_Targets.xlsx. Open Version History, open the 3:30 PM IST version, copy the Nashik rows back (or Restore that version if nothing else changed). Show Changes tells you who deleted them.
Ravindra Bagale's Tip
Khup students chuk zalyavar ghabartat aani Ctrl + Z khup veles dabtat, kiwa file punha banavtat. File OneDrive var asel tar Version History madhe juna version sapdto – ghabru naka. Pan Restore karnyapurvi lakshat theva ki tyanantar che dusryanche badal pan jaatil; garaj asel tar fakt lagnare cells copy kara.
Practice task
In a OneDrive workbook, make three edits a few minutes apart, open Version History, open the oldest version and copy one old value back into the current file.
Thodkyaat sangaycha tar (quick recap)
- Aadhi input cells Unlock, mag Protect Sheet. Protect Workbook = sheets chi structure.
- Sheet/structure password = chukanpasun sanrakshan; khari security = Encrypt with Password (aani password visru naka!).
- Print Area, Page Break Preview, Width 1 page, headers/footers aani Print Titles
$1:$1. - PDF: aadhi page setup, mag Export › Options.
- OneDrive/SharePoint = co-authoring, @mention comments aani Version History.
Aata pudhe jaauya – sagla shiklela ekatra vaparun Final Project!