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
When they make a mistake, many students panic and press Ctrl + Z many times, or rebuild the file. If the file is on OneDrive, you can find an old version in Version History – don't panic. But before you Restore, remember that other people's changes made after that will also be lost; if needed, copy only the cells you need.
Ravindra Bagale's Tip – मराठी
चूक झाल्यावर बरेच students घाबरतात आणि Ctrl + Z खूप वेळा दाबतात, किंवा file पुन्हा बनवतात. File OneDrive वर असेल तर Version History मध्ये जुनं version सापडतं – घाबरू नका. पण Restore करण्यापूर्वी लक्षात ठेवा की त्यानंतरचे इतरांचे बदल पण जातील; गरज असेल तर फक्त लागणाऱ्या cells copy करा.
Ravindra Bagale's Tip – हिंदी
गलती होने पर बहुत से students घबराकर Ctrl + Z कई बार दबाते हैं, या file दोबारा बनाते हैं. File OneDrive पर हो तो Version History में पुराना version मिल जाता है – घबराओ मत. लेकिन Restore करने से पहले याद रखो कि उसके बाद के दूसरों के बदलाव भी चले जाएँगे; ज़रूरत हो तो सिर्फ़ ज़रूरी cells copy कर लो.
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!